Line 1: using System;
Line 2: using System.Collections.Generic;
Line 3: using System.Web;
Line 4: using System.IO;
Line 5: using System.Data.OleDb;
Line 6: using System.Data;
Line 7: using System.Collections;
Line 8: using System.Drawing;
Line 9: using System.Drawing.Drawing2D;
Line 10: using System.Drawing.Imaging;
Line 11:
Line 12: // eran 21/6/16
Line 13: using System.Net;
Line 14:
Line 15: //eran 27/3/16
Line 16: using System.Net.Mail;
Line 17: using System.Text.RegularExpressions;
Line 18: using System.Text;
Line 19: using System.Collections.Specialized;
Line 20: using System.Reflection;
Line 21:
Line 22: //eran 20/6/16
Line 23: //namespace masterpage.master.cs;
Line 24: //Assembly Src="ClassFiles/CommanFunctions.cs";
Line 25:
Line 26: /// <summary>
Line 27: /// Summary description for CommanFunctions
Line 28: /// </summary>
Line 29:
Line 30: public class CommanFunctions
Line 31: {
Line 32:
Line 33: //eran 21/6/16 moved from master
Line 34: static bool AreWeInDebugNewfeatureMode = false;
Line 35:
Line 36:
Line 37: //block added by Vibhav Bhavsar, For Multi Language Connection
Line 38: OleDbConnection conLanguage = new OleDbConnection(); // connection object
Line 39: OleDbCommand cmdLanguage = new OleDbCommand(); // command object
Line 40: OleDbDataReader readerLanguage; // Datareader object
Line 41:
Line 42: //block added by Vibhav Bhavsar, For Slide Show
Line 43: OleDbConnection conSlider = new OleDbConnection(); // connection object
Line 44: OleDbCommand cmdSlider = new OleDbCommand(); // command object
Line 45: OleDbDataReader readerSlider; // Datareader object
Line 46:
Line 47: //block added by Vibhav Bhavsar, For Main
Line 48: OleDbConnection conMain = new OleDbConnection(); // connection object
Line 49: OleDbConnection ConSelectedMDB = new OleDbConnection(); // added eran 11/5/23
Line 50: OleDbCommand cmdMain = new OleDbCommand(); // command object
Line 51: OleDbDataReader readerMain; // Datareader object
Line 52:
Line 53: static string[,] Language_TextID_Text;
Line 54:
Line 55: string _LanguageConnectionPath;
Line 56:
Line 57: //vibhav 11/04/2019
Line 58: long[] intReservedCode = { 996, 997, 998 };
Line 59:
Line 60:
Line 61: // eran 11/5/23 ********************** block start
Line 62: /*
Line 63: public string test523()
Line 64: {
Line 65: string result="";
Line 66: string DBformSending = "..//App_Data//DBusersPhoneEmailFormFills.mdb";
Line 67: openConSelectedMDB(DBformSending);
Line 68:
Line 69:
Line 70: // Ahmad H 16/5/23 block
Line 71: List<string> fieldNames = new List<string>();
Line 72: fieldNames.Add("NameFilled");
Line 73: fieldNames.Add("Phone");
Line 74: fieldNames.Add("Email");
Line 75: List<string> fieldValues = new List<string>();
Line 76: fieldValues.Add("NameFilled1");
Line 77: fieldValues.Add("Phone1");
Line 78: fieldValues.Add("Email1");
Line 79:
Line 80: // List<string> names = new List<string> { "name", "Ana", "Felipe" };
Line 81: / *
Line 82: foreach (var name in names)
Line 83: {
Line 84: //Console.WriteLine($"Hello {name.ToUpper()}!");
Line 85: Console.WriteLine("Hello {name.ToUpper()}!");
Line 86: }
Line 87: * /
Line 88:
Line 89: // ahmad h 17/5/23
Line 90: string relativePath = @"..\App_Data\DBusersPhoneEmailFormFills.mdb";
Line 91:
Line 92:
Line 93: InsertRecord(relativePath, "UsersClientsFilledForms", fieldNames, fieldValues);
Line 94: return result;
Line 95:
Line 96:
Line 97:
Line 98: //result = InsertSelectedFieldInSelectedTableRecordAnddCon("UsersClientsFilledForms", "Email", "test2", ConSelectedMDB);
Line 99: //result = FetchSelectedFieldInSelectedTableAnddCon("UsersClientsFilledForms", "Email", "UserId=2", ConSelectedMDB);
Line 100: //return result;
Line 101:
Line 102: }
Line 103: */
Line 104:
Line 105: // Added by jemark 07-06-2023
Line 106: /// <summary>
Line 107: /// Creates log upon sending an email
Line 108: /// </summary>
Line 109: /// <param name="tableColumnWithValueList"></param>
Line 110: /// <param name="tableName"></param>
Line 111: /// <returns></returns>
Line 112: public bool WriteRecordInSpecificDBandListFieldsValues(string mdbFileName, string tableName, List<TableColumnInformation> tableColumnWithValueList)
Line 113: {
Line 114: bool result = false;
Line 115:
Line 116: try
Line 117: {
Line 118: List<TableColumnInformation> columnsWithValue = new List<TableColumnInformation>();
Line 119:
Line 120: string relativePath = string.Format(@"~/App_Data/{0}", mdbFileName);
Line 121: List<TableColumnInformation> tableColumns = GetMDBTableColumns(relativePath, tableName);
Line 122:
Line 123: // Get the exact column name from tableColumns based on the input tableColumnWithValueList
Line 124: foreach (TableColumnInformation tblColumnAndDataType in tableColumns)
Line 125: {
Line 126: foreach (TableColumnInformation fromFormColumn in tableColumnWithValueList)
Line 127: {
Line 128: // Checking on both column name field is there was a similar name
Line 129: if (
Line 130: (
Line 131: tblColumnAndDataType.ColumnName.ToLower().Contains(fromFormColumn.ColumnName.ToLower()) ||
Line 132: tblColumnAndDataType.ColumnName.ToLower().StartsWith(fromFormColumn.ColumnName.ToLower()) ||
Line 133: tblColumnAndDataType.ColumnName.ToLower().EndsWith(fromFormColumn.ColumnName.ToLower())
Line 134: )
Line 135: ||
Line 136: (
Line 137: fromFormColumn.ColumnName.ToLower().Contains(tblColumnAndDataType.ColumnName.ToLower()) ||
Line 138: fromFormColumn.ColumnName.ToLower().StartsWith(tblColumnAndDataType.ColumnName.ToLower()) ||
Line 139: fromFormColumn.ColumnName.ToLower().EndsWith(tblColumnAndDataType.ColumnName.ToLower())
Line 140: )
Line 141: )
Line 142: {
Line 143: TableColumnInformation columnWithValue = new TableColumnInformation();
Line 144: columnWithValue.ColumnName = tblColumnAndDataType.ColumnName;
Line 145: columnWithValue.ColumnValue = fromFormColumn.ColumnValue;
Line 146: columnWithValue.ColumnDataType = tblColumnAndDataType.ColumnDataType;
Line 147: columnsWithValue.Add(columnWithValue);
Line 148: break;
Line 149: }
Line 150: }
Line 151: }
Line 152:
Line 153: // If theres no column name match then use the tableColumnWithValueList
Line 154: if (columnsWithValue.Count == 0)
Line 155: {
Line 156: columnsWithValue = tableColumnWithValueList;
Line 157: }
Line 158:
Line 159: result = InsertDataFromFieldValuesIntoTheGivenMdbTable(relativePath, tableName, columnsWithValue);
Line 160: }
Line 161: catch (Exception ex)
Line 162: {
Line 163: // For log purposes it should be save in a log file
Line 164: Console.Write(string.Format("Error at [WriteRecordInSpecificDBandListFieldsValues]*** Exception: {0} *** Inner exception: {1} *** Stack trace: {2} ***", ex.Message, ex.InnerException, ex.StackTrace));
Line 165: }
Line 166:
Line 167: return result;
Line 168: }
Line 169:
Line 170: // Added by jemark 07-06-2023
Line 171: /// <summary>
Line 172: /// Gets the table columns from the given mdb table name
Line 173: /// </summary>
Line 174: /// <param name="mdbPath"></param>
Line 175: /// <param name="tableName"></param>
Line 176: /// <returns></returns>
Line 177: public List<TableColumnInformation> GetMDBTableColumns(string mdbPath, string tableName)
Line 178: {
Line 179: List<TableColumnInformation> result = null;
Line 180:
Line 181: try
Line 182: {
Line 183: string connectionString = GetConnectionString(mdbPath);
Line 184: using (OleDbConnection connection = new OleDbConnection(connectionString))
Line 185: {
Line 186: connection.Open();
Line 187:
Line 188: using (OleDbDataAdapter OleDbAdapter = new OleDbDataAdapter(string.Format("SELECT * FROM {0}", tableName), connection))
Line 189: {
Line 190: DataTable dt = new DataTable();
Line 191: OleDbAdapter.Fill(dt);
Line 192:
Line 193: if (dt.Rows.Count > 0)
Line 194: {
Line 195: result = new List<TableColumnInformation>();
Line 196: foreach (DataColumn dc in dt.Columns)
Line 197: {
Line 198: TableColumnInformation tableColumnInformation = new TableColumnInformation();
Line 199: tableColumnInformation.ColumnName = dc.ColumnName;
Line 200: tableColumnInformation.ColumnDataType = dc.DataType.ToString().ToLower();
Line 201: result.Add(tableColumnInformation);
Line 202: }
Line 203: }
Line 204: }
Line 205: }
Line 206: }
Line 207: catch (Exception ex)
Line 208: {
Line 209: // For log purposes it should be save in a log file
Line 210: Console.Write(string.Format("Error at [GetMDBTableColumns]*** Exception: {0} *** Inner exception: {1} *** Stack trace: {2} ***", ex.Message, ex.InnerException, ex.StackTrace));
Line 211: }
Line 212:
Line 213: return result;
Line 214: }
Line 215:
Line 216: // added 16/5/23 Ahmad H
Line 217: public string GetConnectionString(string mdbPath)
Line 218: {
Line 219: string strDBPath = mdbPath;
Line 220: string physicalPath = System.Web.Hosting.HostingEnvironment.MapPath(strDBPath);
Line 221: string cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + physicalPath;
Line 222: return cs;
Line 223: }
Line 224:
Line 225: //Ahmad H 17/5/23
Line 226:
Line 227: // Ahmad H 16/5/23
Line 228: public void InsertRecord(string mdbPath, string tableName, List<string> fieldNames, List<string> fieldValues)
Line 229: {
Line 230: string fieldNamesString = string.Join(",", fieldNames.ToArray());
Line 231: List<string> quotedFieldValues = new List<string>();
Line 232: foreach (string value in fieldValues)
Line 233: {
Line 234: quotedFieldValues.Add("'" + value + "'");
Line 235: }
Line 236: string fieldValuesString = string.Join(",", quotedFieldValues.ToArray());
Line 237: string connectionString = GetConnectionString(mdbPath);
Line 238: using (OleDbConnection connection = new OleDbConnection(connectionString))
Line 239: {
Line 240:
Line 241:
Line 242: using (OleDbCommand command = new OleDbCommand())
Line 243: {
Line 244: command.CommandText = "INSERT INTO " + tableName + " (" + fieldNamesString + ") VALUES (" + fieldValuesString + ")";
Line 245: command.Connection = connection;
Line 246:
Line 247: try
Line 248: {
Line 249: connection.Open();
Line 250: command.ExecuteNonQuery();
Line 251: }
Line 252: catch (Exception e)
Line 253: {
Line 254:
Line 255: }
Line 256: }
Line 257: }
Line 258: }
Line 259:
Line 260: // Added by jemark 07-06-2023
Line 261: /// <summary>
Line 262: /// Inserting new record(s) into the specified db table
Line 263: /// </summary>
Line 264: /// <param name="mdbPath"></param>
Line 265: /// <param name="tableName"></param>
Line 266: /// <param name="fieldValues"></param>
Line 267: /// <returns></returns>
Line 268: public bool InsertDataFromFieldValuesIntoTheGivenMdbTable(string mdbPath, string tableName, List<TableColumnInformation> fieldValues)
Line 269: {
Line 270: bool result = false;
Line 271:
Line 272: try
Line 273: {
Line 274: // Generate query
Line 275: string insert_sql = "INSERT INTO {0} ({1}) VALUES({2})";
Line 276:
Line 277: if (fieldValues.Count > 0)
Line 278: {
Line 279: string columns = string.Empty;
Line 280: string values = string.Empty;
Line 281:
Line 282: foreach (TableColumnInformation fieldValue in fieldValues)
Line 283: {
Line 284: columns += fieldValue.ColumnName + ",";
Line 285: values += GetColumnDataValueByDataType(fieldValue.ColumnDataType, fieldValue.ColumnValue) + ",";
Line 286: }
Line 287:
Line 288: columns = columns.TrimEnd(',');
Line 289: values = values.TrimEnd(',');
Line 290:
Line 291: insert_sql = string.Format(insert_sql, tableName, columns, values);
Line 292: }
Line 293: else { return false; }
Line 294:
Line 295: string connectionString = GetConnectionString(mdbPath);
Line 296: using (OleDbConnection connection = new OleDbConnection(connectionString))
Line 297: {
Line 298: connection.Open();
Line 299:
Line 300: using (OleDbCommand command = new OleDbCommand(insert_sql, connection))
Line 301: {
Line 302: result = Convert.ToBoolean(command.ExecuteNonQuery());
Line 303: }
Line 304: }
Line 305: }
Line 306: catch (Exception ex)
Line 307: {
Line 308: // For log purposes it should be save in a log file
Line 309: Console.Write(string.Format("Error at [InsertDataFromFieldValuesIntoTheGivenMdbTable]*** Exception: {0} *** Inner exception: {1} *** Stack trace: {2} ***", ex.Message, ex.InnerException, ex.StackTrace));
Line 310: }
Line 311:
Line 312: return result;
Line 313: }
Line 314:
Line 315: // Added by jemark 07-06-2023
Line 316: /// <summary>
Line 317: /// Gets the appropriate data value based on the column data type
Line 318: /// </summary>
Line 319: /// <param name="dataType"></param>
Line 320: /// <param name="value"></param>
Line 321: /// <returns></returns>
Line 322: public string GetColumnDataValueByDataType(string dataType, string value)
Line 323: {
Line 324: string result = string.Empty;
Line 325:
Line 326: try
Line 327: {
Line 328: if (dataType.Contains("string") || dataType.Contains("datetime"))
Line 329: {
Line 330: result = string.Format(@"'{0}'", value);
Line 331: }
Line 332: else if (dataType.Contains("int"))
Line 333: {
Line 334: result = string.Format(@"{0}", value);
Line 335: }
Line 336: else if (dataType.Contains("bool"))
Line 337: {
Line 338: result = string.Format(@"{0}", value);
Line 339: }
Line 340: }
Line 341: catch (Exception ex)
Line 342: {
Line 343: // For log purposes it should be save in a log file
Line 344: Console.Write(string.Format("Error at [GetColumnDataValueByDataType]*** Exception: {0} *** Inner exception: {1} *** Stack trace: {2} ***", ex.Message, ex.InnerException, ex.StackTrace));
Line 345: }
Line 346:
Line 347: return result;
Line 348: }
Line 349:
Line 350: // eran 11/5/23
Line 351: /*
Line 352: public string InsertSelectedFieldInSelectedTableRecordAnddCon(string TableName, string FieldName, string FieldContent, OleDbConnection ConSelectedMDB)
Line 353: {
Line 354: string query = "INSERT INTO " + tableName + " (" + FieldName + ") VALUES (" + fieldValuesString + ")";
Line 355: OleDbCommand command = new OleDbCommand(query, ConSelectedMDB);
Line 356: command.ExecuteNonQuery();
Line 357: return "";
Line 358:
Line 359: }
Line 360: */
Line 361:
Line 362: // eran 10/5/23
Line 363: public string FetchSelectedFieldInSelectedTableAnddCon(string TableName, string FieldName, string Whereclause, OleDbConnection ConSelectedMDB)
Line 364: {
Line 365: // Create connection string
Line 366: // ConSelectedMDB.Open();
Line 367:
Line 368: // Create SQL query string
Line 369: string query = string.Format("SELECT {0} FROM {1} " + "where " + Whereclause, FieldName, TableName, 0);
Line 370: //return query;
Line 371:
Line 372: // Create OleDbConnection object
Line 373: using (ConSelectedMDB)
Line 374: {
Line 375: // Create OleDbCommand object
Line 376:
Line 377: using (OleDbCommand command = new OleDbCommand(query, ConSelectedMDB))
Line 378: {
Line 379: object result = command.ExecuteScalar();
Line 380:
Line 381: // Check if result is null
Line 382: if (result != null)
Line 383: {
Line 384: // Convert result to string and return
Line 385: return result.ToString();
Line 386: }
Line 387: }
Line 388: }
Line 389:
Line 390: // Return empty string if value not found
Line 391: return string.Empty;
Line 392: }
Line 393:
Line 394: /*
Line 395: public string aFetchSelectedFieldInSelectedTableAnddCon(string TableName, string FieldName, string Whereclause, OleDbConnection ConSelectedMDB)
Line 396: {
Line 397: using (ConSelectedMDB)
Line 398: {
Line 399: openConMain();
Line 400: cmdMain.CommandText = "SELECT RunNo from " + TableName + " " + Whereclause + " " + " order by " + FieldName;
Line 401: readerMain = cmdMain.ExecuteReader();
Line 402:
Line 403: long NewPlaceInMenuOrder = 0;
Line 404: OleDbCommand newcmdMain = new OleDbCommand();
Line 405: newcmdMain.Connection = conMain;
Line 406:
Line 407: while (readerMain.Read())
Line 408: {
Line 409: NewPlaceInMenuOrder = NewPlaceInMenuOrder + 1;
Line 410: newcmdMain.CommandText = "Update " + TableName + " set " + FieldName + " = " + NewPlaceInMenuOrder + " WHERE RunNo =" + Convert.ToInt32(readerMain["RunNo"]);
Line 411: newcmdMain.ExecuteNonQuery();
Line 412: }
Line 413:
Line 414: readerMain.Dispose(); //eran 12/4/16
Line 415: newcmdMain.Dispose(); //vibhav 13/4/16
Line 416: cmdMain.Dispose(); //vibhav 13/4/16
Line 417: }
Line 418: }
Line 419: */
Line 420:
Line 421: /*
Line 422: using System.Data.OleDb;
Line 423:
Line 424: public void InsertRecord(string mdbPath, string tableName, List<string> fieldNames, List<string> fieldValues)
Line 425: {
Line 426: string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath;
Line 427: string fieldNamesString = string.Join(",", fieldNames);
Line 428: string fieldValuesString = string.Join(",", fieldValues.Select(s => "'" + s + "'"));
Line 429:
Line 430: using (OleDbConnection connection = new OleDbConnection(connectionString))
Line 431: {
Line 432: connection.Open();
Line 433: string query = "INSERT INTO " + tableName + " (" + fieldNamesString + ") VALUES (" + fieldValuesString + ")";
Line 434: OleDbCommand command = new OleDbCommand(query, connection);
Line 435: command.ExecuteNonQuery();
Line 436: }
Line 437: }
Line 438:
Line 439: public string saveRecordToSelectedMdb()
Line 440: {
Line 441: string mdbPath = "C:/mydatabase.mdb";
Line 442: string tableName = "mytable";
Line 443: List<string> fieldNames = new List<string> {field1", "field2", "field3" };
Line 444: List<string> fieldValues = new List<string> { "value1", "value2", "value3" };
Line 445:
Line 446: InsertRecord(mdbPath, tableName, fieldNames, fieldValues);
Line 447:
Line 448: }
Line 449: */
Line 450: // eran 11/5/23 ********************** block end
Line 451:
Line 452: //eran 21/6/16 block moved from master
Line 453: //public void SiteRestartAtCatch(bool AreWeInDebugNewfeatureMode)
Line 454: public void SiteRestartAtCatch()
Line 455: {
Line 456: AreWeInDebugNewfeatureMode = false;
Line 457:
Line 458: //vibhav 14/4/2016
Line 459:
Line 460: string fileName = "PIC/ShouldCodeBlockSiteRestartAtExternalCode.txt";
Line 461: string fileBlcokRestartEntirely = "PIC/ShouldCodeIgnoreSiteRestartEntirely.txt";
Line 462: string BlockRestartAnyWayQueryString = "BlockRestartAnyWay=false";
Line 463:
Line 464: if (CheckFileExistsOrNot(fileBlcokRestartEntirely) == true)
Line 465: {
Line 466: return;
Line 467: }
Line 468:
Line 469: if (CheckFileExistsOrNot(fileName))
Line 470: {
Line 471: string fileContain = System.IO.File.ReadAllText(System.Web.HttpContext.Current.Server.MapPath(fileName));
Line 472: if (fileContain.ToLower() == "true" || fileContain.ToLower() == "")
Line 473: {
Line 474: BlockRestartAnyWayQueryString = "BlockRestartAnyWay=true";
Line 475: }
Line 476: else if (fileContain.ToLower() == "false")
Line 477: {
Line 478: //vibhav 29/03/2017, call restart only when file contain false
Line 479:
Line 480: // ERAN 30/3/16 pass to another site the current name to restart
Line 481: HttpContext.Current.Response.Redirect("http://" + GetIpAddress() + "/restart_other_site_current_server/restartInputSite.aspx?sitenametorestart=" + System.Web.Hosting.HostingEnvironment.ApplicationHost.GetSiteName() + "&" + BlockRestartAnyWayQueryString);
Line 482: }
Line 483: }
Line 484: else
Line 485: {
Line 486: //vibhav 29/03/2017
Line 487:
Line 488: // ERAN 30/3/16 pass to another site the current name to restart
Line 489: HttpContext.Current.Response.Redirect("http://" + GetIpAddress() + "/restart_other_site_current_server/restartInputSite.aspx?sitenametorestart=" + System.Web.Hosting.HostingEnvironment.ApplicationHost.GetSiteName() + "&" + BlockRestartAnyWayQueryString);
Line 490: }
Line 491:
Line 492: }
Line 493: public string GetIpAddress()
Line 494: {
Line 495: // eran 1/5/16 string IpAddress = "";
Line 496:
Line 497: string IpAddress = IPofTheServerThisSiteRunOn(); //Gadi 13/04/2016
Line 498: if (IpAddress == "") //Gadi 13/04/2016
Line 499: {
Line 500: if (System.Web.HttpContext.Current.Request.ServerVariables["LOCAL_ADDR"] != null)
Line 501: IpAddress = System.Web.HttpContext.Current.Request.ServerVariables["LOCAL_ADDR"].ToString();
Line 502:
Line 503: // eran 1/5/16
Line 504: //if (System.Web.HttpContext.Current.Request.ServerVariables["LOCAL_ADDR"] != null)
Line 505: // IpAddress = System.Web.HttpContext.Current.Request.ServerVariables["LOCAL_ADDR"].ToString();
Line 506:
Line 507: // eran 12/4/16 special hard coded case
Line 508: if (IpAddress == "100.90.212.83")
Line 509: {
Line 510: IpAddress = "40.114.145.57";
Line 511: }
Line 512: }
Line 513:
Line 514: return IpAddress;
Line 515: }
Line 516: //eran 21/6/16 END block moved from master
Line 517:
Line 518:
Line 519:
Line 520:
Line 521:
Line 522: //eran ADD BLOCK 27/3/16 ****************************************************
Line 523: public string IPofTheServerThisSiteRunOn()
Line 524: {
Line 525: return (Convert.ToString(getContentFromFile("PIC/IPofTheServerThisSiteRunOn.txt")));
Line 526: }
Line 527:
Line 528: public void SendMailGeneral(string toAddress, string Subject, string Message_Body)
Line 529: {
Line 530: // Redi 22.04.2022 Commented unnecesary code below
Line 531: //bool IsThereAnyAffiliate = false;
Line 532: //string AffiliateName, AffiliateMailUser, AffiliateMailDomain; //to change 27/3/16
Line 533: //string Company = "Client of Mainframe CMS";
Line 534: //string siteUrlToMoveAfterSend = "../index.asp";
Line 535: //string fromAddress = "info@g1948.com";
Line 536:
Line 537: //Added by vibhav bhavsar, 25-07-2015
Line 538: //string EmailSmtpClient = "";
Line 539:
Line 540: //System.Net.Mail.SmtpClient mailClient;
Line 541: //if (CheckFileExistsOrNot("pic/WhatMailServerToUse.txt"))
Line 542: //{
Line 543: // EmailSmtpClient = getContentFromFile("pic/WhatMailServerToUse.txt");
Line 544: //}
Line 545:
Line 546: //eran 16/4/14
Line 547: //string toAddress = "" + getContentFromFile("pic/EmailOfTheSiteOwner.txt") + ",info@g1948.com" + ""; //; //
Line 548:
Line 549: //if (EmailSmtpClient.ToLower() == "gmail")
Line 550: //{
Line 551: // // To use Gmail.com as smtp with GmailID
Line 552: // mailClient = new System.Net.Mail.SmtpClient("smtp.gmail.com", 587);
Line 553: //}
Line 554: //else
Line 555: //{
Line 556: // // To use live.com as smtp for LiveID
Line 557: // mailClient = new System.Net.Mail.SmtpClient("smtp.live.com", 587);
Line 558: //}
Line 559:
Line 560: //mailClient.UseDefaultCredentials = false;
Line 561: //mailClient.EnableSsl = true;
Line 562:
Line 563:
Line 564: //System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage("a@a.com", "g1948.com@gmail.com");
Line 565: //message.Subject = "this is test email from Azure ";
Line 566: //message.Body = "Sending test email WAWS using smtp server";
Line 567: //message.Priority = System.Net.Mail.MailPriority.High;
Line 568:
Line 569:
Line 570: System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage("fromAddress@norelevant.com", toAddress);
Line 571:
Line 572:
Line 573: // eran add 18/9/15
Line 574:
Line 575:
Line 576: message.Subject = Subject;
Line 577: message.Body = Message_Body;
Line 578: message.IsBodyHtml = true; //2/4/14 eran
Line 579: message.Priority = System.Net.Mail.MailPriority.High;
Line 580:
Line 581: //trying to retry if fails for token expiration
Line 582: //Redi 22.04.2022
Line 583: SendEmailViaApi(message, true);
Line 584: // Redi 22.04.2022 Commented unnecesary code below
Line 585:
Line 586: // System.Net.NetworkCredential credentials = new System.Net.NetworkCredential("publictolet@gmail.com", "aaAA1235");
Line 587: //string UserForCloudMailServer = "";
Line 588: //string PasswordForCloudMailServer = "";
Line 589:
Line 590: //if (EmailSmtpClient.ToLower() == "gmail")
Line 591: //{
Line 592: // if (CheckFileExistsOrNot("pic/UserForGmailCloudMailServer.txt"))
Line 593: // {
Line 594: // UserForCloudMailServer = getContentFromFile("pic/UserForGmailCloudMailServer.txt");
Line 595: // }
Line 596:
Line 597: // if (CheckFileExistsOrNot("App_Data/PasswordForGmailCloudMailServer.txt"))
Line 598: // {
Line 599: // PasswordForCloudMailServer = getContentFromFile("App_Data/PasswordForGmailCloudMailServer.txt");
Line 600: // }
Line 601: //}
Line 602: //else
Line 603: //{
Line 604: // if (CheckFileExistsOrNot("pic/UserForCloudMailServer.txt"))
Line 605: // {
Line 606: // UserForCloudMailServer = getContentFromFile("pic/UserForCloudMailServer.txt");
Line 607: // }
Line 608:
Line 609: // if (CheckFileExistsOrNot("pic/PasswordForCloudMailServer.txt"))
Line 610: // {
Line 611: // PasswordForCloudMailServer = getContentFromFile("pic/PasswordForCloudMailServer.txt");
Line 612: // }
Line 613: //}
Line 614:
Line 615: //System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(UserForCloudMailServer, PasswordForCloudMailServer);
Line 616: //mailClient.Credentials = credentials;
Line 617: //to back 27/3/16 message.BodyEncoding = Encoding.UTF8;
Line 618:
Line 619:
Line 620:
Line 621:
Line 622: // to drop remark
Line 623: //mailClient.Send(message);
Line 624: //Response.Write("Email sent!");
Line 625:
Line 626: // to get back
Line 627: //Response.Redirect("response-redirect.asp?siteUrlToMoveAfterSend=../index.asp");
Line 628:
Line 629: }
Line 630:
Line 631:
Line 632:
Line 633: //eran 27/3/16 end ****************************************************
Line 634:
Line 635: public string LanguageConnectionPath
Line 636: {
Line 637: get
Line 638: {
Line 639: return this._LanguageConnectionPath;
Line 640: }
Line 641: set
Line 642: {
Line 643: this._LanguageConnectionPath = value;
Line 644: }
Line 645:
Line 646: }
Line 647:
Line 648: string _LanguageFilePath;
Line 649: public string LanguageFilePath
Line 650: {
Line 651: get
Line 652: {
Line 653: return this._LanguageFilePath;
Line 654: }
Line 655: set
Line 656: {
Line 657: this._LanguageFilePath = value;
Line 658: }
Line 659:
Line 660: }
Line 661:
Line 662: string[,] _Language_TextID_TextIn;
Line 663: public string[,] Language_TextID_TextIn
Line 664: {
Line 665: get
Line 666: {
Line 667: return this._Language_TextID_TextIn;
Line 668: }
Line 669: set
Line 670: {
Line 671: this._Language_TextID_TextIn = value;
Line 672: }
Line 673: }
Line 674:
Line 675: string _SliderConnectionPath;
Line 676: public string SliderConnectionPath
Line 677: {
Line 678: get
Line 679: {
Line 680: return this._SliderConnectionPath;
Line 681: }
Line 682: set
Line 683: {
Line 684: this._SliderConnectionPath = value;
Line 685: }
Line 686:
Line 687: }
Line 688:
Line 689: string _MainConnectionPath;
Line 690: public string MainConnectionPath
Line 691: {
Line 692: get
Line 693: {
Line 694: return this._MainConnectionPath;
Line 695: }
Line 696: set
Line 697: {
Line 698: this._MainConnectionPath = value;
Line 699: }
Line 700:
Line 701: }
Line 702:
Line 703: //Added by Vibhav Bhavsar
Line 704: //Date: 7-Feb-2015
Line 705:
Line 706: /// <summary>
Line 707: /// Return the texts from the MDB based on data holds by PIC/LanguageToUse.txt
Line 708: /// </summary>
Line 709:
Line 710: public string[,] FetchTextInCurrentLanguageFromDb(int LanguageID)
Line 711: {
Line 712: //Generate Language Text
Line 713: string Language_Text = "";
Line 714: if (CheckFileExistsOrNot(LanguageFilePath))
Line 715: {
Line 716: //get current language ID from text file
Line 717: string TextInCurrentLanguage = getContentFromFile(LanguageFilePath);
Line 718: int count = 0;
Line 719: using (conLanguage)
Line 720: {
Line 721: if (conLanguage.State == ConnectionState.Closed)
Line 722: {
Line 723: openConLanguagePage();
Line 724: }
Line 725:
Line 726: cmdLanguage.CommandText = "SELECT COUNT(*) FROM TextsInSelectedLanguage WHERE LanguageId = " + LanguageID + " ";
Line 727: count = Convert.ToInt32(cmdLanguage.ExecuteScalar());
Line 728:
Line 729: cmdLanguage.Dispose(); //vibhav 13/4/16
Line 730: }
Line 731:
Line 732: if (count > 0)
Line 733: {
Line 734: Language_TextID_Text = new string[count, 2];
Line 735: }
Line 736:
Line 737: using (conLanguage)
Line 738: {
Line 739: if (conLanguage.State == ConnectionState.Closed)
Line 740: {
Line 741: openConLanguagePage();
Line 742: }
Line 743:
Line 744: cmdLanguage.CommandText = "SELECT TextID,TextInLanguage FROM TextsInSelectedLanguage WHERE LanguageId = " + Convert.ToInt32(TextInCurrentLanguage) + " ";
Line 745:
Line 746: readerLanguage = cmdLanguage.ExecuteReader();
Line 747: int RowCount = 0;
Line 748: while (readerLanguage.Read())
Line 749: {
Line 750: Language_TextID_Text[RowCount, 0] = Convert.ToString(readerLanguage["TextID"]);
Line 751: Language_TextID_Text[RowCount, 1] = Convert.ToString(readerLanguage["TextInLanguage"]);
Line 752: RowCount = RowCount + 1;
Line 753: }
Line 754:
Line 755: cmdLanguage.Dispose(); //vibhav 13/4/16
Line 756:
Line 757: }
Line 758: }
Line 759:
Line 760: return Language_TextID_Text;
Line 761: readerLanguage.Dispose(); //eran 12/4/16
Line 762: cmdLanguage.Dispose(); //vibhav 13/4/16
Line 763:
Line 764: }
Line 765:
Line 766: //Added by Vibhav Bhavsar
Line 767: //Date: 7-Feb-2015
Line 768:
Line 769: /// <summary>
Line 770: /// Return the text from given text filename
Line 771: /// </summary>
Line 772:
Line 773:
Line 774: public string getContentFromFile(string fileName)
Line 775: {
Line 776: string strContentInFile = "";
Line 777: if (CheckFileExistsOrNot(fileName))
Line 778: {
Line 779: strContentInFile = System.IO.File.ReadAllText(System.Web.HttpContext.Current.Server.MapPath(fileName));
Line 780: }
Line 781: return strContentInFile;
Line 782: }
Line 783:
Line 784: //Added by Vibhav Bhavsar
Line 785: //Date: 7-Feb-2015
Line 786:
Line 787: /// <summary>
Line 788: /// Return true if given file exists otherwise return false
Line 789: /// </summary>
Line 790:
Line 791:
Line 792: public bool CheckFileExistsOrNot(string file)
Line 793: {
Line 794:
Line 795: if (File.Exists(System.Web.HttpContext.Current.Server.MapPath(file)))
Line 796: {
Line 797: return true;
Line 798: }
Line 799: else
Line 800: {
Line 801: return false;
Line 802: }
Line 803:
Line 804: }
Line 805:
Line 806: //Added by Vibhav Bhavsar
Line 807: //Date: 7-Feb-2015
Line 808:
Line 809: /// <summary>
Line 810: /// Return Multi Language conection String.
Line 811: /// </summary>
Line 812: public static string GetLanguageConectioString(string ConnectionStringPath)
Line 813: {
Line 814: //return @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Multi_Language_Languages_CodeSupport.mdb";
Line 815: return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(ConnectionStringPath);
Line 816: }
Line 817:
Line 818: /// <summary>
Line 819: /// Open connection if close
Line 820: /// </summary>
Line 821:
Line 822: public void openConLanguagePage()
Line 823: {
Line 824:
Line 825: // eran add try-catch block 20/6/16
Line 826: try
Line 827: {
Line 828: if (conLanguage.State == ConnectionState.Closed)
Line 829: {
Line 830: conLanguage.ConnectionString = GetLanguageConectioString(LanguageConnectionPath);
Line 831: cmdLanguage.Connection = conLanguage;
Line 832:
Line 833: // eran add try-catch block 20/6/16
Line 834: try
Line 835: {
Line 836: conLanguage.Open();
Line 837: }
Line 838: catch (Exception e)
Line 839: {
Line 840: SiteRestartAtCatch();
Line 841: }
Line 842: finally
Line 843: {
Line 844:
Line 845: }
Line 846:
Line 847:
Line 848:
Line 849: }
Line 850: }
Line 851: catch (Exception e)
Line 852: {
Line 853: SiteRestartAtCatch();
Line 854: }
Line 855: finally
Line 856: {
Line 857:
Line 858: }
Line 859: }
Line 860:
Line 861: public void openConSlider()
Line 862: {
Line 863: if (conSlider.State == ConnectionState.Closed)
Line 864: {
Line 865: conSlider.ConnectionString = GetConectionString(SliderConnectionPath);
Line 866: cmdSlider.Connection = conSlider;
Line 867:
Line 868: // eran add try-catch block 20/6/16
Line 869: try
Line 870: {
Line 871: conSlider.Open();
Line 872: }
Line 873: catch (Exception e)
Line 874: {
Line 875: SiteRestartAtCatch();
Line 876: }
Line 877: finally
Line 878: {
Line 879:
Line 880: }
Line 881:
Line 882: }
Line 883:
Line 884: }
Line 885:
Line 886: public void openConMain()
Line 887: {
Line 888: if (conMain.State == ConnectionState.Closed)
Line 889: {
Line 890: conMain.ConnectionString = GetConectionString(MainConnectionPath);
Line 891: cmdMain.Connection = conMain;
Line 892:
Line 893: // eran add try-catch block 20/6/16
Line 894: try
Line 895: {
Line 896: conMain.Open();
Line 897: }
Line 898: catch (Exception e)
Line 899: {
Line 900: SiteRestartAtCatch();
Line 901: }
Line 902: finally
Line 903: {
Line 904:
Line 905: }
Line 906:
Line 907:
Line 908: }
Line 909:
Line 910: }
Line 911: // eran duplicated for specific 11/5/23
Line 912: public void openConSelectedMDB(string WhatMDB)
Line 913: {
Line 914: if (ConSelectedMDB.State == ConnectionState.Closed)
Line 915: {
Line 916: ConSelectedMDB.ConnectionString = GetConectionString(WhatMDB);
Line 917: cmdMain.Connection = ConSelectedMDB;
Line 918: try
Line 919: {
Line 920: ConSelectedMDB.Open();
Line 921: }
Line 922: catch (Exception e)
Line 923: {
Line 924: }
Line 925: finally
Line 926: {
Line 927: }
Line 928: }
Line 929: }
Line 930:
Line 931:
Line 932:
Line 933: //Added by Vibhav bhavsar
Line 934: //Date : 9-Feb-2015
Line 935:
Line 936: /// <summary>
Line 937: /// Return alternative value if given value is null
Line 938: /// </summary>
Line 939:
Line 940: public object GetAternativeValueIfValueNull(object value, object alternative)
Line 941: {
Line 942: try
Line 943: {
Line 944: if (value.GetType() == typeof(string))
Line 945: {
Line 946: if ((string)value == "")
Line 947: return alternative;
Line 948: else
Line 949: return value;
Line 950: }
Line 951: else
Line 952: {
Line 953: if (value == System.DBNull.Value || value == null)
Line 954: {
Line 955: return alternative;
Line 956: }
Line 957: else
Line 958: {
Line 959: return value;
Line 960: }
Line 961: }
Line 962:
Line 963: }
Line 964: catch
Line 965: {
Line 966: if (value == System.DBNull.Value || value == null)
Line 967: {
Line 968: return alternative;
Line 969: }
Line 970: else
Line 971: {
Line 972: return value;
Line 973: }
Line 974: }
Line 975: }
Line 976:
Line 977: //Added by Vibhav bhavsar
Line 978: //Date : 9-Feb-2015
Line 979:
Line 980: /// <summary>
Line 981: /// Return trim string if string length is grater then max length, i.e "Latest New..."
Line 982: /// </summary>
Line 983:
Line 984: public string TrimStringLength(string value, int maxLength)
Line 985: {
Line 986: if (value.Length > maxLength)
Line 987: {
Line 988: return value.Substring(0, maxLength) + "...";
Line 989: }
Line 990: else
Line 991: {
Line 992: return value;
Line 993: }
Line 994: }
Line 995:
Line 996: //To get langauge text by passing TextID
Line 997: public string GetLanguageInText(int TextID)
Line 998: {
Line 999: string TextInLanguageByTextID = "";
Line 1000: if (Language_TextID_TextIn != null && Language_TextID_TextIn.Length > 0)
Line 1001: {
Line 1002: for (int i = 0; i < (Language_TextID_TextIn.Length) / 2; i++)
Line 1003: {
Line 1004: if (Language_TextID_TextIn[i, 0] == Convert.ToString(TextID))
Line 1005: {
Line 1006: TextInLanguageByTextID = Language_TextID_TextIn[i, 1];
Line 1007: break;
Line 1008: }
Line 1009: }
Line 1010: }
Line 1011: return TextInLanguageByTextID;
Line 1012: }
Line 1013:
Line 1014: //Added by Nitesh Sahu
Line 1015: //Date: 2-Feb-2009
Line 1016:
Line 1017: /// <summary>
Line 1018: /// Return conection String.
Line 1019: /// </summary>
Line 1020: public static string GetConectionString(string ConnectionStringPath)
Line 1021: {
Line 1022: return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(ConnectionStringPath);
Line 1023: }
Line 1024:
Line 1025: //Added by vibhav
Line 1026: //01-Mar-2015
Line 1027:
Line 1028: /// <summary>
Line 1029: /// Prepate external path
Line 1030: /// Take path as input parameter as refrence type and make changes for external path.
Line 1031: /// </summary>
Line 1032: /// <param name="str_TopLogolinkURLorRelativeFileName"> Refrence type Path</param>
Line 1033: public static void PrepareExternalPath(ref string str_TopLogolinkURLorRelativeFileName)
Line 1034: {
Line 1035: if (IsExternalURL(ref str_TopLogolinkURLorRelativeFileName))
Line 1036: {
Line 1037: str_TopLogolinkURLorRelativeFileName = PrepareHrefForExternalURL(str_TopLogolinkURLorRelativeFileName);
Line 1038: }
Line 1039: }
Line 1040:
Line 1041:
Line 1042: //Added by Nitesh Sahu
Line 1043: //Date: 8-Jan-2009
Line 1044:
Line 1045: /// <summary>
Line 1046: /// Prepare container of logo Image and SWF.
Line 1047: /// And add Image of Logo.
Line 1048: /// </summary>
Line 1049: /// <summary>
Line 1050: /// Check weather input path is Extenal path or same.
Line 1051: /// </summary>
Line 1052: /// <param name="linkURLorRelativeFileName"> inpur path</param>
Line 1053: /// <returns>true if path is external url</returns>
Line 1054: public static bool IsExternalURL(ref string linkURLorRelativeFileName)
Line 1055: {
Line 1056: linkURLorRelativeFileName = linkURLorRelativeFileName.Trim();
Line 1057: // posibble error to check - eran 4/3/10
Line 1058: if (linkURLorRelativeFileName.StartsWith("www."))
Line 1059: {
Line 1060: return true;
Line 1061: }
Line 1062:
Line 1063:
Line 1064:
Line 1065: // Eran 4/3 if(linkURLorRelativeFileName.StartsWith("http:"))
Line 1066: if ((linkURLorRelativeFileName.StartsWith("http:")) || (linkURLorRelativeFileName.StartsWith("https:")))
Line 1067: {
Line 1068: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("http://", "http:\\\\");
Line 1069: //linkURLorRelativeFileName= linkURLorRelativeFileName.Replace("http://","http:\\");
Line 1070: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("http://", "http:\\\\");
Line 1071: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("http://", "http:\\\\");
Line 1072: linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("\\", "//");
Line 1073: linkURLorRelativeFileName = HttpUtility.UrlPathEncode(linkURLorRelativeFileName);
Line 1074:
Line 1075: return true;
Line 1076: }
Line 1077:
Line 1078:
Line 1079: /* eran 4/3/10
Line 1080: if (linkURLorRelativeFileName.StartsWith("https:"))
Line 1081: {
Line 1082: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("https://", "https:\\\\");
Line 1083: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("https://", "https:\\");
Line 1084: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("https://", "https:\\\\");
Line 1085: //linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("https://", "http:\\\\");
Line 1086: linkURLorRelativeFileName = linkURLorRelativeFileName.Replace("\\", "//");
Line 1087: linkURLorRelativeFileName = HttpUtility.UrlPathEncode(linkURLorRelativeFileName);
Line 1088: return true;
Line 1089: }
Line 1090: */
Line 1091:
Line 1092: return false;
Line 1093: }
Line 1094:
Line 1095: //Added by Nitesh Sahu
Line 1096: //Date: 8-Jan-2009
Line 1097: //Purpose: ToPalce Logo Image.
Line 1098:
Line 1099: /// <summary>
Line 1100: /// Prepare container of logo Image and SWF.
Line 1101:
Line 1102: /// </summary>
Line 1103: /// <summary>
Line 1104: /// Add prefix to input path
Line 1105: /// </summary>
Line 1106: /// <param name="linkURLorRelativeFileName">Input path</param>
Line 1107: /// <returns> updated path with prefix http:\\</returns>
Line 1108: public static string PrepareHrefForExternalURL(string linkURLorRelativeFileName)
Line 1109: {
Line 1110:
Line 1111: if (linkURLorRelativeFileName.StartsWith("www."))
Line 1112: {
Line 1113: linkURLorRelativeFileName = @"http://" + linkURLorRelativeFileName;
Line 1114: }
Line 1115:
Line 1116: return linkURLorRelativeFileName;
Line 1117: }
Line 1118:
Line 1119: //Added by Vibhav Bhavsar
Line 1120: //Date: 09-Feb-2015
Line 1121:
Line 1122: /// <summary>
Line 1123: /// Prepare External and Internal URL and Return link
Line 1124: /// </summary>
Line 1125: public string GetLinkStringByCheck(string UrlItemLinksTo)
Line 1126: {
Line 1127: //First check if URL is external or same directory
Line 1128: if (Convert.ToString(UrlItemLinksTo) != "")
Line 1129: {
Line 1130: PrepareExternalPath(ref UrlItemLinksTo);
Line 1131: }
Line 1132:
Line 1133: return UrlItemLinksTo;
Line 1134: }
Line 1135:
Line 1136:
Line 1137: public object GetSingleValueFromDb(string ColumnName, string TableName, string WhereCondition, OleDbConnection connection)
Line 1138: {
Line 1139: if (connection.State == ConnectionState.Closed)
Line 1140: {
Line 1141: return null;
Line 1142: }
Line 1143: object value;
Line 1144:
Line 1145: OleDbCommand cmd = new OleDbCommand();
Line 1146: using (connection)
Line 1147: {
Line 1148: string sqlString = "";
Line 1149: sqlString = "SELECT " + ColumnName + " FROM " + TableName;
Line 1150:
Line 1151: if (WhereCondition.Length > 0)
Line 1152: {
Line 1153: sqlString += " WHERE " + WhereCondition;
Line 1154: }
Line 1155: cmd.Connection = connection;
Line 1156: cmd.CommandText = sqlString;
Line 1157: value = cmd.ExecuteScalar();
Line 1158:
Line 1159: }
Line 1160:
Line 1161: cmd.Dispose(); //vibhav 13/4/16
Line 1162:
Line 1163: return value;
Line 1164: }
Line 1165:
Line 1166: public int GetCountByColumnTableName(string ColumnName, string TableName, string WhereCondition, OleDbConnection connection)
Line 1167: {
Line 1168:
Line 1169: OleDbCommand cmd = new OleDbCommand();
Line 1170: int Count = 0;
Line 1171: using (connection)
Line 1172: {
Line 1173: if (connection.State == ConnectionState.Closed)
Line 1174: {
Line 1175:
Line 1176: // eran add try-catch block 20/6/16
Line 1177: try
Line 1178: {
Line 1179: connection.Open();
Line 1180: }
Line 1181: catch (Exception e)
Line 1182: {
Line 1183: SiteRestartAtCatch();
Line 1184: }
Line 1185: finally
Line 1186: {
Line 1187:
Line 1188: }
Line 1189:
Line 1190:
Line 1191:
Line 1192: }
Line 1193: string sqlString = "";
Line 1194: sqlString = "SELECT COUNT(" + ColumnName + ") FROM " + TableName;
Line 1195:
Line 1196: if (WhereCondition.Length > 0)
Line 1197: {
Line 1198: sqlString += " WHERE " + WhereCondition;
Line 1199: }
Line 1200: cmd.Connection = connection;
Line 1201: cmd.CommandText = sqlString;
Line 1202: Count = Convert.ToInt32(GetAternativeValueIfValueNull(cmd.ExecuteScalar(), 0));
Line 1203:
Line 1204: }
Line 1205:
Line 1206: cmd.Dispose(); //vibhav 13/4/16
Line 1207:
Line 1208: return Count;
Line 1209: }
Line 1210:
Line 1211: public void ReorderSelectedFieldInSelectedTable_ForMenuId(string TableName, string FieldName, long MenuCode)
Line 1212: {
Line 1213: using (conMain)
Line 1214: {
Line 1215: openConMain();
Line 1216: cmdMain.CommandText = "SELECT RunNo from " + TableName + " WHERE MenuCode = " + MenuCode + " order by " + FieldName;
Line 1217: readerMain = cmdMain.ExecuteReader();
Line 1218:
Line 1219: long NewPlaceInMenuOrder = 0;
Line 1220: OleDbCommand newcmdMain = new OleDbCommand();
Line 1221: newcmdMain.Connection = conMain;
Line 1222:
Line 1223: while (readerMain.Read())
Line 1224: {
Line 1225: NewPlaceInMenuOrder = NewPlaceInMenuOrder + 1;
Line 1226: newcmdMain.CommandText = "Update " + TableName + " set " + FieldName + " = " + NewPlaceInMenuOrder + " WHERE RunNo =" + Convert.ToInt32(readerMain["RunNo"]);
Line 1227: newcmdMain.ExecuteNonQuery();
Line 1228: }
Line 1229:
Line 1230: readerMain.Dispose(); //eran 12/4/16
Line 1231: newcmdMain.Dispose(); //vibhav 13/4/16
Line 1232: cmdMain.Dispose(); //vibhav 13/4/16
Line 1233: }
Line 1234: }
Line 1235:
Line 1236: public void ReorderSelectedFieldInSelectedTable(string TableName, string FieldName, string Whereclause)
Line 1237: {
Line 1238: using (conMain)
Line 1239: {
Line 1240: openConMain();
Line 1241: cmdMain.CommandText = "SELECT RunNo from " + TableName + " " + Whereclause + " " + " order by " + FieldName;
Line 1242: readerMain = cmdMain.ExecuteReader();
Line 1243:
Line 1244: long NewPlaceInMenuOrder = 0;
Line 1245: OleDbCommand newcmdMain = new OleDbCommand();
Line 1246: newcmdMain.Connection = conMain;
Line 1247:
Line 1248: while (readerMain.Read())
Line 1249: {
Line 1250: NewPlaceInMenuOrder = NewPlaceInMenuOrder + 1;
Line 1251: newcmdMain.CommandText = "Update " + TableName + " set " + FieldName + " = " + NewPlaceInMenuOrder + " WHERE RunNo =" + Convert.ToInt32(readerMain["RunNo"]);
Line 1252: newcmdMain.ExecuteNonQuery();
Line 1253: }
Line 1254:
Line 1255: readerMain.Dispose(); //eran 12/4/16
Line 1256: newcmdMain.Dispose(); //vibhav 13/4/16
Line 1257: cmdMain.Dispose(); //vibhav 13/4/16
Line 1258: }
Line 1259: }
Line 1260:
Line 1261: public void GenerateSliderHTMLByFilm(int FilmID, string SliderVersion)
Line 1262: {
Line 1263:
Line 1264: //get total count of the available frames for requested film
Line 1265: int FrameCount = 0;
Line 1266: using (conSlider)
Line 1267: {
Line 1268: openConSlider();
Line 1269: FrameCount = GetCountByColumnTableName("*", "SlideShowsFramesLevel", "FilmID =" + FilmID, conSlider);
Line 1270: }
Line 1271:
Line 1272: int MenuCode = 0;
Line 1273: int PlaceInMenu = 0;
Line 1274: string FilmDefaultBackgroundPicFile = "";
Line 1275: string FilmDefaultBackgroundColor = "";
Line 1276:
Line 1277: //Read menucode and placeinmenu for given filmID
Line 1278: using (conSlider)
Line 1279: {
Line 1280:
Line 1281: openConSlider();
Line 1282: cmdSlider.CommandText = "SELECT MenuCode, PlaceInMenu, FilmDefaultBackgroundPicFile, FilmDefaultBackgroundColor FROM SlideShowFilmsLevel WHERE FilmID =" + FilmID;
Line 1283:
Line 1284: OleDbDataReader rdrData;
Line 1285:
Line 1286: rdrData = cmdSlider.ExecuteReader();
Line 1287:
Line 1288: while (rdrData.Read())
Line 1289: {
Line 1290:
Line 1291: MenuCode = Convert.ToInt32(rdrData["MenuCode"]);
Line 1292: PlaceInMenu = Convert.ToInt32(rdrData["PlaceInMenu"]);
Line 1293: FilmDefaultBackgroundPicFile = Convert.ToString(rdrData["FilmDefaultBackgroundPicFile"]);
Line 1294: FilmDefaultBackgroundColor = Convert.ToString(rdrData["FilmDefaultBackgroundColor"]);
Line 1295: }
Line 1296:
Line 1297: rdrData.Dispose(); //eran 12/4/16
Line 1298: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1299: }
Line 1300:
Line 1301: //If film has more than one frame then start to create html for slider
Line 1302: if (FrameCount > 0)
Line 1303: {
Line 1304:
Line 1305: //To store complete silder html
Line 1306: string SliderFramesHTML = "";
Line 1307:
Line 1308: //to hold small images html which we generate based on film's frames
Line 1309: string SliderSmallImagesHTML = "";
Line 1310:
Line 1311: //to hold caption, desction and back ground image
Line 1312: string SliderMainContent = "";
Line 1313:
Line 1314: if (SliderVersion == "101" || SliderVersion == "" || SliderVersion == "0")
Line 1315: {
Line 1316:
Line 1317:
Line 1318: using (conSlider)
Line 1319: {
Line 1320:
Line 1321: openConSlider();
Line 1322: cmdSlider.CommandText = "SELECT RunNo, FrameOrder, CaptionText, DetailsText, BackgroundPictureItem, UrlFrameWillLinkTo,Is_BlankUrlFrameWillLinkTo,captionClass, detailsClass FROM SlideShowsFramesLevel WHERE FilmID =" + FilmID + " Order by FrameOrder";
Line 1323:
Line 1324: OleDbDataReader rdrData;
Line 1325:
Line 1326: rdrData = cmdSlider.ExecuteReader();
Line 1327:
Line 1328: while (rdrData.Read())
Line 1329: {
Line 1330: string FrameBackgroundPic = "";
Line 1331: string FrameBackgroundColor = "";
Line 1332:
Line 1333: if (Convert.ToString(rdrData["BackgroundPictureItem"]) != "")
Line 1334: {
Line 1335: FrameBackgroundPic = Convert.ToString(rdrData["BackgroundPictureItem"]);
Line 1336: }
Line 1337: else if (FilmDefaultBackgroundPicFile != "")
Line 1338: {
Line 1339: FrameBackgroundPic = FilmDefaultBackgroundPicFile;
Line 1340: }
Line 1341: else if (FilmDefaultBackgroundColor != "")
Line 1342: {
Line 1343: FrameBackgroundColor = FilmDefaultBackgroundColor;
Line 1344: }
Line 1345:
Line 1346: if (FrameBackgroundPic != "")
Line 1347: {
Line 1348: string FileNameWithoutExtension = Path.GetFileNameWithoutExtension(FrameBackgroundPic);
Line 1349: string GetUploadedFileExtension = Path.GetExtension(FrameBackgroundPic);
Line 1350: string FrameBackgroundsmallPic = FileNameWithoutExtension + "_small" + GetUploadedFileExtension;
Line 1351:
Line 1352: SliderSmallImagesHTML += "<li><a title=\"" + Convert.ToString(rdrData["CaptionText"]) + "\" href=\"#\" rel=\"nofollow\"><img src=\"" + "PIC/" + FrameBackgroundsmallPic + "\" alt=\"[Alternative text]\" width=\"100%\" height=\"100%\" /></a></li>\r\n";
Line 1353: }
Line 1354: else if (FrameBackgroundColor != "")
Line 1355: {
Line 1356: SliderSmallImagesHTML += "<li><a title=\"" + Convert.ToString(rdrData["CaptionText"]) + "\" href=\"#\" rel=\"nofollow\" Style=\"Background-color: " + FrameBackgroundColor + "\"><img width=\"100%\" height=\"100%\" /></a></li>\r\n";
Line 1357: }
Line 1358:
Line 1359:
Line 1360:
Line 1361: if (FrameBackgroundPic != "" || FrameBackgroundColor != "")
Line 1362: {
Line 1363:
Line 1364:
Line 1365: if (FrameBackgroundPic != "")
Line 1366: {
Line 1367: SliderMainContent += "<div class=\"sliderkit-panel\">";
Line 1368: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1369: {
Line 1370: SliderMainContent += "<a href=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" Style=\"text-decoration: none;color: inherit;\"";
Line 1371:
Line 1372: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1373: {
Line 1374: SliderMainContent += " target=\"_blank\"";
Line 1375: }
Line 1376:
Line 1377: SliderMainContent += " >";
Line 1378: }
Line 1379:
Line 1380: SliderMainContent += "<img src=\"PIC/" + FrameBackgroundPic + "\" alt=\"[Alternative text]\" />\r\n";
Line 1381:
Line 1382:
Line 1383: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1384: {
Line 1385: SliderMainContent += " </a>\r\n";
Line 1386: }
Line 1387: }
Line 1388: else if (FrameBackgroundColor != "")
Line 1389: {
Line 1390: SliderMainContent += "<div class=\"sliderkit-panel\" Style=\"Background-color: " + FrameBackgroundColor + "\">";
Line 1391: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1392: {
Line 1393: SliderMainContent += "<a href=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" Style=\"text-decoration: none;color: inherit;\"";
Line 1394:
Line 1395: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1396: {
Line 1397: SliderMainContent += " target=\"_blank\"";
Line 1398: }
Line 1399:
Line 1400: SliderMainContent += " >";
Line 1401: }
Line 1402: SliderMainContent += " <img src=\"#\" Style=\"display:none;\" alt=\"[Alternative text]\" />\r\n";
Line 1403:
Line 1404: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1405: {
Line 1406: SliderMainContent += " </a>\r\n";
Line 1407: }
Line 1408: }
Line 1409:
Line 1410:
Line 1411:
Line 1412: SliderMainContent += "<div class=\"sliderkit-panel-textbox\">\r\n";
Line 1413:
Line 1414: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1415: {
Line 1416: SliderMainContent += "<a href=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" Style=\"text-decoration: none;color: inherit;\"";
Line 1417:
Line 1418: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1419: {
Line 1420: SliderMainContent += " target=\"_blank\"";
Line 1421: }
Line 1422:
Line 1423: SliderMainContent += " >";
Line 1424: }
Line 1425:
Line 1426:
Line 1427: if (Convert.ToString(rdrData["detailsClass"]) != "")
Line 1428: {
Line 1429: SliderMainContent += "<div class=\"sliderkit-panel-text " + Convert.ToString(rdrData["detailsClass"]) + "\" >\r\n";
Line 1430: }
Line 1431: else
Line 1432: {
Line 1433: SliderMainContent += "<div class=\"sliderkit-panel-text\" >\r\n";
Line 1434: }
Line 1435:
Line 1436: //caption
Line 1437: if (Convert.ToString(rdrData["CaptionClass"]) != "")
Line 1438: {
Line 1439: SliderMainContent += "<h4 class=\"" + Convert.ToString(rdrData["CaptionClass"]) + "\">" + Convert.ToString(rdrData["CaptionText"]) + "</h4>\r\n";
Line 1440: }
Line 1441: else
Line 1442: {
Line 1443: SliderMainContent += "<h4>" + Convert.ToString(rdrData["CaptionText"]) + "</h4>\r\n";
Line 1444: }
Line 1445:
Line 1446:
Line 1447: //Description
Line 1448: SliderMainContent += "" + Convert.ToString(rdrData["DetailsText"]) + "</div>\r\n";
Line 1449:
Line 1450: SliderMainContent += " <div class=\"sliderkit-panel-overlay\"> </div> </div>\r\n";
Line 1451:
Line 1452: SliderMainContent += "</div>\r\n";
Line 1453:
Line 1454: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1455: {
Line 1456: SliderMainContent += " </a>\r\n";
Line 1457: }
Line 1458:
Line 1459: }
Line 1460: }
Line 1461:
Line 1462: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1463:
Line 1464: }
Line 1465:
Line 1466:
Line 1467: SliderFramesHTML += "<!-- Start photosgallery-captions -->\r\n";
Line 1468: SliderFramesHTML += "<div class=\"sliderkit photosgallery-captions\">\r\n";
Line 1469: SliderFramesHTML += "<div class=\"sliderkit-nav\">\r\n";
Line 1470: SliderFramesHTML += "<div class=\"sliderkit-nav-clip\"><!-- test drop space <ul> --> <!--solve space 9/2/15 <ul> -->\r\n";
Line 1471: SliderFramesHTML += "<ul>\r\n";
Line 1472:
Line 1473: // small images
Line 1474: SliderFramesHTML += SliderSmallImagesHTML;
Line 1475:
Line 1476: SliderFramesHTML += "</ul>\r\n";
Line 1477: SliderFramesHTML += "<!--solve space 9/2/15 </ul> --> <!-- test drop space </ul> --></div>\r\n";
Line 1478:
Line 1479: SliderFramesHTML += "<div class=\"sliderkit-btn sliderkit-nav-btn sliderkit-nav-prev\"><a title=\"Previous line\" href=\"#\" rel=\"nofollow\"><span>Previous line</span></a></div>\r\n";
Line 1480: SliderFramesHTML += "<div class=\"sliderkit-btn sliderkit-nav-btn sliderkit-nav-next\"><a title=\"Next line\" href=\"#\" rel=\"nofollow\"><span>Next line</span></a></div>\r\n";
Line 1481:
Line 1482: SliderFramesHTML += "<div class=\"sliderkit-btn sliderkit-go-btn sliderkit-go-prev\"><a title=\"Previous photo\" href=\"#\" rel=\"nofollow\"><span>Previous photo</span></a></div>\r\n";
Line 1483: SliderFramesHTML += "<div class=\"sliderkit-btn sliderkit-go-btn sliderkit-go-next\"><a title=\"Next photo\" href=\"#\" rel=\"nofollow\"><span>Next photo</span></a></div>\r\n";
Line 1484:
Line 1485: SliderFramesHTML += "</div>\r\n";
Line 1486:
Line 1487: SliderFramesHTML += "<div class=\"sliderkit-panels\">\r\n";
Line 1488:
Line 1489: //Main content, caption text, description text and
Line 1490: SliderFramesHTML += SliderMainContent;
Line 1491:
Line 1492: SliderFramesHTML += " </div> </div>\r\n";
Line 1493:
Line 1494: SliderFramesHTML += "<div class=\"spacer\"> </div>";
Line 1495: }
Line 1496: else if (SliderVersion == "102")
Line 1497: {
Line 1498: using (conSlider)
Line 1499: {
Line 1500:
Line 1501: openConSlider();
Line 1502: cmdSlider.CommandText = "SELECT RunNo, FrameOrder, CaptionText, DetailsText, BackgroundPictureItem, UrlFrameWillLinkTo,Is_BlankUrlFrameWillLinkTo,captionClass, detailsClass FROM SlideShowsFramesLevel WHERE FilmID =" + FilmID + " Order by FrameOrder";
Line 1503:
Line 1504: OleDbDataReader rdrData;
Line 1505:
Line 1506: rdrData = cmdSlider.ExecuteReader();
Line 1507:
Line 1508: if (rdrData.HasRows)
Line 1509: {
Line 1510: SliderMainContent += "<div class=\"sliderContainer fullWidth clearfix\">";
Line 1511: SliderMainContent += "<div class=\"full-width-slider royalSlider heroSlider rsMinW\">";
Line 1512: }
Line 1513:
Line 1514: while (rdrData.Read())
Line 1515: {
Line 1516: string FrameBackgroundPic = "";
Line 1517: string FrameBackgroundColor = "";
Line 1518:
Line 1519: if (Convert.ToString(rdrData["BackgroundPictureItem"]) != "")
Line 1520: {
Line 1521: FrameBackgroundPic = Convert.ToString(rdrData["BackgroundPictureItem"]);
Line 1522: }
Line 1523: else if (FilmDefaultBackgroundPicFile != "")
Line 1524: {
Line 1525: FrameBackgroundPic = FilmDefaultBackgroundPicFile;
Line 1526: }
Line 1527: else if (FilmDefaultBackgroundColor != "")
Line 1528: {
Line 1529: FrameBackgroundColor = FilmDefaultBackgroundColor;
Line 1530: }
Line 1531:
Line 1532:
Line 1533:
Line 1534:
Line 1535: if (FrameBackgroundPic != "" || FrameBackgroundColor != "")
Line 1536: {
Line 1537:
Line 1538:
Line 1539: if (FrameBackgroundPic != "")
Line 1540: {
Line 1541:
Line 1542: SliderMainContent += " <div class=\"rsContent\">";
Line 1543:
Line 1544: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1545: {
Line 1546: SliderMainContent += "<a href=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" Style=\"text-decoration: none;color: inherit;\"";
Line 1547:
Line 1548: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1549: {
Line 1550: SliderMainContent += " target=\"_blank\"";
Line 1551: }
Line 1552:
Line 1553: SliderMainContent += " >";
Line 1554: }
Line 1555:
Line 1556: string FileNameWithoutExtension = Path.GetFileNameWithoutExtension(FrameBackgroundPic);
Line 1557: string GetUploadedFileExtension = Path.GetExtension(FrameBackgroundPic);
Line 1558: string FrameBackgroundsmallPic = FileNameWithoutExtension + "_small" + GetUploadedFileExtension;
Line 1559:
Line 1560: SliderMainContent += " <img class=\"rsImg\" src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mP8Xw8AAoMBgDTD2qgAAAAASUVORK5CYII=\" data-src=\"PIC/" + FrameBackgroundPic + "\" data-src-small=\"PIC/" + FrameBackgroundsmallPic + "\" alt=\"\" />";
Line 1561: //SliderMainContent += " <a class=\"rsImg\" href=\"PIC/" + FrameBackgroundPic + "\" data-src-small=\"PIC/" + FrameBackgroundsmallPic + "\" alt=\"\"></a>";
Line 1562:
Line 1563: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1564: {
Line 1565: SliderMainContent += " </a>\r\n";
Line 1566: }
Line 1567: }
Line 1568: else if (FrameBackgroundColor != "")
Line 1569: {
Line 1570:
Line 1571: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1572: {
Line 1573: SliderMainContent += "<a href=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" Style=\"text-decoration: none;color: inherit;\"";
Line 1574:
Line 1575: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1576: {
Line 1577: SliderMainContent += " target=\"_blank\"";
Line 1578: }
Line 1579:
Line 1580: SliderMainContent += " >";
Line 1581:
Line 1582: SliderMainContent += " <div class=\"rsContent\" style=\"Background-color: " + FrameBackgroundColor + "\" >";
Line 1583:
Line 1584: }
Line 1585:
Line 1586: else
Line 1587: {
Line 1588: SliderMainContent += " <div class=\"rsContent\" style=\"Background-color: " + FrameBackgroundColor + "\" >";
Line 1589: }
Line 1590:
Line 1591: //SliderMainContent += " <div class=\"rsImg\" style=\"Background-color: " + FrameBackgroundColor + "\" alt=\"\" />";
Line 1592:
Line 1593: //if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1594: //{
Line 1595: // SliderMainContent += " </a>\r\n";
Line 1596: //}
Line 1597: }
Line 1598:
Line 1599: if (Convert.ToString(rdrData["CaptionText"]) != "" || Convert.ToString(rdrData["DetailsText"]) != "")
Line 1600: {
Line 1601: SliderMainContent += "<div class=\"infoBlock rsAbsoluteEl\" style=\"color: #000; height: auto;\" data-fade-effect=\"\" data-move-offset=\"10\" data-move-effect=\"bottom\" data-speed=\"200\">";
Line 1602:
Line 1603: //caption
Line 1604: if (Convert.ToString(rdrData["CaptionClass"]) != "")
Line 1605: {
Line 1606: SliderMainContent += "<h4 class=\"" + Convert.ToString(rdrData["CaptionClass"]) + "\">" + Convert.ToString(rdrData["CaptionText"]) + "</h4>\r\n";
Line 1607: }
Line 1608: else
Line 1609: {
Line 1610: SliderMainContent += "<h4>" + Convert.ToString(rdrData["CaptionText"]) + "</h4>\r\n";
Line 1611: }
Line 1612:
Line 1613: if (Convert.ToString(rdrData["detailsClass"]) != "")
Line 1614: {
Line 1615: SliderMainContent += "<p class=\"" + Convert.ToString(rdrData["detailsClass"]) + "\">" + Convert.ToString(rdrData["DetailsText"]) + "</p>\r\n";
Line 1616: }
Line 1617: else
Line 1618: {
Line 1619: SliderMainContent += "<p>" + Convert.ToString(rdrData["DetailsText"]) + "</p>\r\n";
Line 1620: }
Line 1621:
Line 1622: SliderMainContent += " </div>";
Line 1623:
Line 1624: }
Line 1625:
Line 1626: SliderMainContent += " </div>";
Line 1627:
Line 1628: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1629: {
Line 1630: SliderMainContent += " </a>\r\n";
Line 1631: }
Line 1632:
Line 1633: //setInterval(function () { $(".rsOverflow").css("width", ""); }, 300);
Line 1634:
Line 1635: }
Line 1636: }
Line 1637:
Line 1638: if (rdrData.HasRows)
Line 1639: {
Line 1640: SliderMainContent += "</div>";
Line 1641: SliderMainContent += "</div>";
Line 1642: }
Line 1643:
Line 1644: SliderMainContent += "<script>setInterval(function () { jq(\".rsOverflow\").css(\"width\", \"\"); }, 300);</script>";
Line 1645:
Line 1646: //Main content, caption text, description text and
Line 1647: SliderFramesHTML += SliderMainContent;
Line 1648:
Line 1649: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1650:
Line 1651: }
Line 1652: }
Line 1653: else if (SliderVersion == "103")
Line 1654: {
Line 1655: using (conSlider)
Line 1656: {
Line 1657:
Line 1658: openConSlider();
Line 1659: cmdSlider.CommandText = "SELECT RunNo, FrameOrder, CaptionText, DetailsText, BackgroundPictureItem, UrlFrameWillLinkTo,Is_BlankUrlFrameWillLinkTo,captionClass, detailsClass FROM SlideShowsFramesLevel WHERE FilmID =" + FilmID + " Order by FrameOrder";
Line 1660:
Line 1661: OleDbDataReader rdrData;
Line 1662:
Line 1663: rdrData = cmdSlider.ExecuteReader();
Line 1664:
Line 1665: if (rdrData.HasRows)
Line 1666: {
Line 1667: SliderMainContent += "<div class=\"tp-banner-container\">";
Line 1668: SliderMainContent += "<div class=\"tp-banner\">";
Line 1669: SliderMainContent += "<ul>";
Line 1670: }
Line 1671:
Line 1672: int CountNumberToConvertToWord = 0;
Line 1673:
Line 1674: while (rdrData.Read())
Line 1675: {
Line 1676: string FrameBackgroundPic = "";
Line 1677: string FrameBackgroundColor = "";
Line 1678:
Line 1679: if (Convert.ToString(rdrData["BackgroundPictureItem"]) != "")
Line 1680: {
Line 1681: FrameBackgroundPic = Convert.ToString(rdrData["BackgroundPictureItem"]);
Line 1682: }
Line 1683: else if (FilmDefaultBackgroundPicFile != "")
Line 1684: {
Line 1685: FrameBackgroundPic = FilmDefaultBackgroundPicFile;
Line 1686: }
Line 1687: else if (FilmDefaultBackgroundColor != "")
Line 1688: {
Line 1689: FrameBackgroundColor = FilmDefaultBackgroundColor;
Line 1690: }
Line 1691:
Line 1692: if (FrameBackgroundPic != "")
Line 1693: {
Line 1694: string FileNameWithoutExtension = Path.GetFileNameWithoutExtension(FrameBackgroundPic);
Line 1695: string GetUploadedFileExtension = Path.GetExtension(FrameBackgroundPic);
Line 1696: string FrameBackgroundsmallPic = FileNameWithoutExtension + "_small" + GetUploadedFileExtension;
Line 1697:
Line 1698: CountNumberToConvertToWord = CountNumberToConvertToWord + 1;
Line 1699:
Line 1700: //<!-- SLIDE -->
Line 1701: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1702: {
Line 1703: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1704: {
Line 1705: SliderMainContent += "<li data-transition=\"fade\" data-link=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" data-target=\"_blank\" data-slotamount=\"7\" data-masterspeed=\"500\" data-thumb=\"" + "PIC/" + FrameBackgroundsmallPic + "\" data-saveperformance=\"on\" data-title=\"slide " + ConvertNumbertoWords(CountNumberToConvertToWord) + "\">";
Line 1706: }
Line 1707: else
Line 1708: {
Line 1709: SliderMainContent += "<li data-transition=\"fade\" data-link=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" data-slotamount=\"7\" data-masterspeed=\"500\" data-thumb=\"" + "PIC/" + FrameBackgroundsmallPic + "\" data-saveperformance=\"on\" data-title=\"slide " + ConvertNumbertoWords(CountNumberToConvertToWord) + "\">";
Line 1710: }
Line 1711: }
Line 1712: else
Line 1713: {
Line 1714: SliderMainContent += "<li data-transition=\"fade\" data-slotamount=\"7\" data-masterspeed=\"500\" data-thumb=\"" + "PIC/" + FrameBackgroundsmallPic + "\" data-saveperformance=\"on\" data-title=\"slide " + ConvertNumbertoWords(CountNumberToConvertToWord) + "\">";
Line 1715: }
Line 1716: //<!-- MAIN IMAGE -->
Line 1717:
Line 1718: SliderMainContent += "<img src=\"" + "PIC/" + FrameBackgroundPic + "\" alt=\"slidebg1\" data-lazyload=\"" + "PIC/" + FrameBackgroundPic + "\" data-bgposition=\"center top\" data-bgfit=\"cover\" data-bgrepeat=\"no-repeat\">";
Line 1719: }
Line 1720: else if (FrameBackgroundColor != "")
Line 1721: {
Line 1722:
Line 1723: CountNumberToConvertToWord = CountNumberToConvertToWord + 1;
Line 1724:
Line 1725: //<!-- SLIDE -->
Line 1726: if (Convert.ToString(rdrData["UrlFrameWillLinkTo"]) != "")
Line 1727: {
Line 1728: if (Convert.ToBoolean(GetAternativeValueIfValueNull(rdrData["Is_BlankUrlFrameWillLinkTo"], false)))
Line 1729: {
Line 1730: SliderMainContent += "<li data-transition=\"fade\" data-link=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" data-target=\"_blank\" data-slotamount=\"7\" data-masterspeed=\"500\" Style=\"Background-color: " + FrameBackgroundColor + "\" data-saveperformance=\"on\" data-title=\"slide " + ConvertNumbertoWords(CountNumberToConvertToWord) + "\">";
Line 1731: }
Line 1732: else
Line 1733: {
Line 1734: SliderMainContent += "<li data-transition=\"fade\" data-link=\"" + GetAternativeValueIfValueNull(GetLinkStringByCheck(Convert.ToString(rdrData["UrlFrameWillLinkTo"])), "#") + "\" data-slotamount=\"7\" data-masterspeed=\"500\" Style=\"Background-color: " + FrameBackgroundColor + "\" data-saveperformance=\"on\" data-title=\"slide " + ConvertNumbertoWords(CountNumberToConvertToWord) + "\">";
Line 1735: }
Line 1736:
Line 1737: }
Line 1738: else
Line 1739: {
Line 1740: SliderMainContent += "<li data-transition=\"fade\" data-slotamount=\"7\" data-masterspeed=\"500\" Style=\"Background-color: " + FrameBackgroundColor + "\" data-saveperformance=\"on\" data-title=\"slide " + ConvertNumbertoWords(CountNumberToConvertToWord) + "\">";
Line 1741: }
Line 1742:
Line 1743: //<!-- MAIN IMAGE -->
Line 1744: //SliderMainContent += "<img alt=\"slidebg1\" data-bgposition=\"center top\" data-bgfit=\"cover\" data-bgrepeat=\"no-repeat\">";
Line 1745:
Line 1746: }
Line 1747:
Line 1748: //<!-- LAYERS -->
Line 1749: if (Convert.ToString(rdrData["CaptionText"]) != "" || Convert.ToString(rdrData["DetailsText"]) != "")
Line 1750: {
Line 1751: //<!-- CAPTION-->
Line 1752: if (Convert.ToString(rdrData["CaptionClass"]) != "")
Line 1753: {
Line 1754: SliderMainContent += "<div class=\"caption sft cap_style_14 rs-parallaxlevel-0 " + Convert.ToString(rdrData["CaptionClass"]) + "\" data-x=\"center\" data-y=\"center\" data-speed=\"900\" data-start=\"800\" data-easing=\"Power3.easeInOut\" >";
Line 1755: SliderMainContent += Convert.ToString(rdrData["CaptionText"]) + "</div>";
Line 1756: }
Line 1757: else
Line 1758: {
Line 1759: SliderMainContent += "<div class=\"caption sft cap_style_14 rs-parallaxlevel-0\" data-x=\"center\" data-y=\"center\" data-speed=\"900\" data-start=\"800\" data-easing=\"Power3.easeInOut\" >";
Line 1760: SliderMainContent += Convert.ToString(rdrData["CaptionText"]) + "</div>";
Line 1761: }
Line 1762:
Line 1763: //<!-- DESCRIPTION-->
Line 1764: if (Convert.ToString(rdrData["DetailsClass"]) != "")
Line 1765: {
Line 1766: SliderMainContent += "<div class=\"caption sft cap_style_14_subtitle rs-parallaxlevel-0 " + Convert.ToString(rdrData["DetailsClass"]) + "\" data-x=\"center\" data-y=\"510\" data-speed=\"900\" data-start=\"1000\" data-easing=\"Power3.easeInOut\" >";
Line 1767: SliderMainContent += Convert.ToString(rdrData["DetailsText"]) + "</div>";
Line 1768: }
Line 1769: else
Line 1770: {
Line 1771: SliderMainContent += "<div class=\"caption sft cap_style_14_subtitle rs-parallaxlevel-0\" data-x=\"center\" data-y=\"510\" data-speed=\"900\" data-start=\"1000\" data-easing=\"Power3.easeInOut\" >";
Line 1772: SliderMainContent += Convert.ToString(rdrData["DetailsText"]) + "</div>";
Line 1773: }
Line 1774: }
Line 1775:
Line 1776: SliderMainContent += "</li>";
Line 1777:
Line 1778: }
Line 1779:
Line 1780: SliderMainContent += "</ul>";
Line 1781: SliderMainContent += "<div class=\"tp-bannertimer\"></div>";
Line 1782: SliderMainContent += "</div>";
Line 1783: SliderMainContent += "</div><div class='spaceFromTopMenu'></div>";
Line 1784:
Line 1785: SliderFramesHTML = SliderMainContent;
Line 1786:
Line 1787: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1788: }
Line 1789:
Line 1790: }
Line 1791: //Now insert updated content to main database
Line 1792:
Line 1793: using (conMain)
Line 1794: {
Line 1795: openConMain();
Line 1796: string updateCommand = "";
Line 1797: cmdMain.Parameters.Clear();
Line 1798: updateCommand += "UPDATE textsInTheSite SET TextInParagraph = @SliderFramesHTML ";
Line 1799: updateCommand += " WHERE MenuCode = " + MenuCode + " AND PlaceInMenu =" + PlaceInMenu;
Line 1800: cmdMain.CommandText = updateCommand;
Line 1801: cmdMain.Parameters.AddWithValue("@SliderFramesHTML", SliderFramesHTML);
Line 1802: cmdMain.ExecuteNonQuery();
Line 1803: cmdMain.Dispose(); //vibhav 13/4/16
Line 1804: }
Line 1805:
Line 1806: }
Line 1807: else
Line 1808: {
Line 1809: using (conMain)
Line 1810: {
Line 1811: openConMain();
Line 1812: string updateCommand = "";
Line 1813: cmdMain.Parameters.Clear();
Line 1814: updateCommand += "UPDATE textsInTheSite SET TextInParagraph = @SliderFramesHTML ";
Line 1815: updateCommand += " WHERE MenuCode = " + MenuCode + " AND PlaceInMenu =" + PlaceInMenu;
Line 1816: cmdMain.CommandText = updateCommand;
Line 1817: cmdMain.Parameters.AddWithValue("@SliderFramesHTML", string.Empty);
Line 1818: cmdMain.ExecuteNonQuery();
Line 1819: cmdMain.Dispose(); //vibhav 13/4/16
Line 1820: }
Line 1821: }
Line 1822: }
Line 1823:
Line 1824: //To generate thumbnails
Line 1825: public void GenerateThumbnails(double scaleFactor, Stream sourcePath, string targetPath)
Line 1826: {
Line 1827: using (System.Drawing.Image image = System.Drawing.Image.FromStream(sourcePath))
Line 1828: {
Line 1829: int newWidth = (int)(image.Width * scaleFactor);
Line 1830: int newHeight = (int)(image.Height * scaleFactor);
Line 1831: Bitmap thumbnailImg = new Bitmap(newWidth, newHeight);
Line 1832: Graphics thumbGraph = Graphics.FromImage(thumbnailImg);
Line 1833: thumbGraph.CompositingQuality = CompositingQuality.HighQuality;
Line 1834: thumbGraph.SmoothingMode = SmoothingMode.HighQuality;
Line 1835: thumbGraph.InterpolationMode = InterpolationMode.HighQualityBicubic;
Line 1836: Rectangle imageRectangle = new Rectangle(0, 0, newWidth, newHeight);
Line 1837: thumbGraph.DrawImage(image, imageRectangle);
Line 1838: thumbnailImg.Save(targetPath, image.RawFormat);
Line 1839: }
Line 1840: }
Line 1841:
Line 1842: //added by vibhav bhavsar 28/09/2015, to reorder all films by comparing it with main mdb
Line 1843:
Line 1844: public void ReorderFilmBeforeAnyAction_ForMenuID(string TableName, string FieldName, long MenuCode)
Line 1845: {
Line 1846: using (conMain)
Line 1847: {
Line 1848: openConMain();
Line 1849: cmdMain.CommandText = "SELECT RunNo,PlaceinMenu from " + TableName + " WHERE MenuCode = " + MenuCode + " order by " + FieldName;
Line 1850: readerMain = cmdMain.ExecuteReader();
Line 1851:
Line 1852: long NewPlaceInMenuOrder = 0;
Line 1853: OleDbCommand newcmdMain = new OleDbCommand();
Line 1854: newcmdMain.Connection = conMain;
Line 1855: long OldPlaceInMenuOrder = 0;
Line 1856:
Line 1857: string MissedPlaceInMenu = "";
Line 1858:
Line 1859: while (readerMain.Read())
Line 1860: {
Line 1861: NewPlaceInMenuOrder = NewPlaceInMenuOrder + 1;
Line 1862: OldPlaceInMenuOrder = Convert.ToInt32(readerMain["PlaceinMenu"]);
Line 1863: OleDbCommand newcmdMain2 = new OleDbCommand();
Line 1864: newcmdMain2.Connection = conMain;
Line 1865: OleDbDataReader newrdrdata;
Line 1866:
Line 1867: newcmdMain2.CommandText = "SELECT * from textsInTheSite WHERE MenuCode = " + MenuCode + " AND (TextInParagraph LIKE '%<!-- Start photosgallery-captions -->%' OR TextInParagraph LIKE '%full-width-slider%' OR TextInParagraph LIKE '%tp-banner-container%') AND PlaceInMenu = " + OldPlaceInMenuOrder;
Line 1868: newrdrdata = newcmdMain2.ExecuteReader();
Line 1869:
Line 1870: while (newrdrdata.Read())
Line 1871: {
Line 1872: if (NewPlaceInMenuOrder != OldPlaceInMenuOrder)
Line 1873: {
Line 1874: using (conSlider)
Line 1875: {
Line 1876: openConSlider();
Line 1877:
Line 1878: OleDbCommand newslidercmd = new OleDbCommand();
Line 1879: newslidercmd.Connection = conSlider;
Line 1880: OleDbDataReader sliderdrddata;
Line 1881:
Line 1882: newslidercmd.CommandText = "select * from SlideShowFilmsLevel WHERE MenuCode =" + MenuCode + " AND PlaceInMenu = " + OldPlaceInMenuOrder;
Line 1883: sliderdrddata = newslidercmd.ExecuteReader();
Line 1884:
Line 1885: if (sliderdrddata.HasRows)
Line 1886: {
Line 1887: cmdSlider.CommandText = "Update SlideShowFilmsLevel set PlaceInMenu = " + NewPlaceInMenuOrder + " WHERE MenuCode =" + MenuCode + " AND PlaceInMenu = " + OldPlaceInMenuOrder;
Line 1888: cmdSlider.ExecuteNonQuery();
Line 1889: }
Line 1890: else
Line 1891: {
Line 1892: MissedPlaceInMenu = MissedPlaceInMenu + Convert.ToString(NewPlaceInMenuOrder) + ",";
Line 1893: }
Line 1894:
Line 1895: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1896: }
Line 1897: }
Line 1898: }
Line 1899:
Line 1900:
Line 1901:
Line 1902: newrdrdata.Close();
Line 1903: newcmdMain.CommandText = "Update " + TableName + " set " + FieldName + " = " + NewPlaceInMenuOrder + " WHERE RunNo =" + Convert.ToInt32(readerMain["RunNo"]);
Line 1904: newcmdMain.ExecuteNonQuery();
Line 1905:
Line 1906: newcmdMain2.Dispose(); //vibhav 13/4/16
Line 1907: }
Line 1908:
Line 1909: newcmdMain.Dispose(); //vibhav 13/4/16
Line 1910:
Line 1911: MissedPlaceInMenu = MissedPlaceInMenu.Trim(',');
Line 1912:
Line 1913: if (MissedPlaceInMenu != "")
Line 1914: {
Line 1915: string[] FromMainMDB = MissedPlaceInMenu.Split(',');
Line 1916: string FinallyMissedPlaceinMenuFromFilm = "";
Line 1917: string FinallyMissedPlaceinMenuFromMain = "";
Line 1918: if (FromMainMDB.Length > 0)
Line 1919: {
Line 1920: using (conSlider)
Line 1921: {
Line 1922: openConSlider();
Line 1923: for (int i = 0; i < FromMainMDB.Length; i++)
Line 1924: {
Line 1925: cmdSlider.CommandText = "select * from SlideShowFilmsLevel WHERE MenuCode =" + MenuCode + " AND PlaceInMenu = " + FromMainMDB[i];
Line 1926: readerSlider = cmdSlider.ExecuteReader();
Line 1927: readerSlider.Read();
Line 1928: if (!readerSlider.HasRows)
Line 1929: {
Line 1930: FinallyMissedPlaceinMenuFromFilm = FinallyMissedPlaceinMenuFromFilm + FromMainMDB[i] + ",";
Line 1931: }
Line 1932: readerSlider.Close();
Line 1933: }
Line 1934:
Line 1935: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1936:
Line 1937: }
Line 1938: }
Line 1939:
Line 1940: using (conSlider)
Line 1941: {
Line 1942: openConSlider();
Line 1943: cmdSlider.CommandText = "SELECT RunNo,PlaceinMenu from SlideShowFilmsLevel WHERE MenuCode = " + MenuCode + " order by placeinmenu";
Line 1944: readerSlider = cmdSlider.ExecuteReader();
Line 1945:
Line 1946: using (conMain)
Line 1947: {
Line 1948: openConMain();
Line 1949:
Line 1950: while (readerSlider.Read())
Line 1951: {
Line 1952: readerMain.Close();
Line 1953: cmdMain.CommandText = "SELECT * from textsInTheSite WHERE MenuCode = " + MenuCode + " AND PlaceInMenu = " + Convert.ToString(readerSlider["PlaceInMenu"]);
Line 1954: readerMain = cmdMain.ExecuteReader();
Line 1955: readerMain.Read();
Line 1956: if (!readerMain.HasRows)
Line 1957: {
Line 1958: FinallyMissedPlaceinMenuFromMain = FinallyMissedPlaceinMenuFromMain + Convert.ToString(readerSlider["PlaceInMenu"]) + ",";
Line 1959: }
Line 1960: readerMain.Close();
Line 1961: }
Line 1962:
Line 1963: }
Line 1964:
Line 1965: cmdSlider.Dispose(); //vibhav 13/4/16
Line 1966:
Line 1967: }
Line 1968:
Line 1969: FinallyMissedPlaceinMenuFromFilm = FinallyMissedPlaceinMenuFromFilm.Trim(',');
Line 1970: FinallyMissedPlaceinMenuFromMain = FinallyMissedPlaceinMenuFromMain.Trim(',');
Line 1971:
Line 1972: if (FinallyMissedPlaceinMenuFromFilm != "" && FinallyMissedPlaceinMenuFromMain != "")
Line 1973: {
Line 1974: string[] ArrayFinallyMissedPlaceinMenuFromFilm = FinallyMissedPlaceinMenuFromFilm.Split(',');
Line 1975: string[] ArrayFinallyMissedPlaceinMenuFromMain = FinallyMissedPlaceinMenuFromMain.Split(',');
Line 1976:
Line 1977: //int[] IntFinallyMissedPlaceinMenuFromFilm = Array.ConvertAll(ArrayFinallyMissedPlaceinMenuFromFilm, int.Parse);
Line 1978: //int[] IntFinallyMissedPlaceinMenuFromMain = Array.ConvertAll(ArrayFinallyMissedPlaceinMenuFromMain, int.Parse);
Line 1979:
Line 1980: Array.Sort(ArrayFinallyMissedPlaceinMenuFromFilm);
Line 1981: Array.Sort(ArrayFinallyMissedPlaceinMenuFromMain);
Line 1982:
Line 1983: using (conSlider)
Line 1984: {
Line 1985: openConSlider();
Line 1986:
Line 1987: for (int i = 0; i < ArrayFinallyMissedPlaceinMenuFromFilm.Length; i++)
Line 1988: {
Line 1989: if (Convert.ToString(ArrayFinallyMissedPlaceinMenuFromMain[i]) != "")
Line 1990: {
Line 1991: cmdSlider.CommandText = "Update SlideShowFilmsLevel set PlaceInMenu = " + ArrayFinallyMissedPlaceinMenuFromFilm[i] + " WHERE MenuCode =" + MenuCode + " AND PlaceInMenu = " + ArrayFinallyMissedPlaceinMenuFromMain[i];
Line 1992: cmdSlider.ExecuteNonQuery();
Line 1993: }
Line 1994: }
Line 1995: }
Line 1996:
Line 1997: }
Line 1998:
Line 1999: }
Line 2000:
Line 2001: cmdMain.Dispose(); //vibhav 13/4/16
Line 2002:
Line 2003: }
Line 2004: }
Line 2005:
Line 2006: //Added by vibhav bhavsar 15/10/2015, convert number to word
Line 2007:
Line 2008: public static string ConvertNumbertoWords(int number)
Line 2009: {
Line 2010: if (number == 0)
Line 2011: return "ZERO";
Line 2012: if (number < 0)
Line 2013: return "minus " + ConvertNumbertoWords(Math.Abs(number));
Line 2014: string words = "";
Line 2015: if ((number / 1000000) > 0)
Line 2016: {
Line 2017: words += ConvertNumbertoWords(number / 1000000) + " MILLION ";
Line 2018: number %= 1000000;
Line 2019: }
Line 2020: if ((number / 1000) > 0)
Line 2021: {
Line 2022: words += ConvertNumbertoWords(number / 1000) + " THOUSAND ";
Line 2023: number %= 1000;
Line 2024: }
Line 2025: if ((number / 100) > 0)
Line 2026: {
Line 2027: words += ConvertNumbertoWords(number / 100) + " HUNDRED ";
Line 2028: number %= 100;
Line 2029: }
Line 2030: if (number > 0)
Line 2031: {
Line 2032: if (words != "")
Line 2033: words += "AND ";
Line 2034: string[] unitsMap = new string[] { "ZERO", "ONE", "TWO", "THREE", "FOUR", "FIVE", "SIX", "SEVEN", "EIGHT", "NINE", "TEN", "ELEVEN", "TWELVE", "THIRTEEN", "FOURTEEN", "FIFTEEN", "SIXTEEN", "SEVENTEEN", "EIGHTEEN", "NINETEEN" };
Line 2035: string[] tensMap = new string[] { "ZERO", "TEN", "TWENTY", "THIRTY", "FORTY", "FIFTY", "SIXTY", "SEVENTY", "EIGHTY", "NINETY" };
Line 2036:
Line 2037: if (number < 20)
Line 2038: words += unitsMap[number];
Line 2039: else
Line 2040: {
Line 2041: words += tensMap[number / 10];
Line 2042: if ((number % 10) > 0)
Line 2043: words += " " + unitsMap[number % 10];
Line 2044: }
Line 2045: }
Line 2046: return words;
Line 2047: }
Line 2048:
Line 2049:
Line 2050: //vibhav 05-10-2016, renumber menu ID by Menu Name
Line 2051: public void RenumberMenuIDByMenuName(string MenuText, int MenuCode)
Line 2052: {
Line 2053:
Line 2054: int currentMenuCode = 0;
Line 2055:
Line 2056: // vibhav 2/5/16 add block try-catch
Line 2057: try
Line 2058: {
Line 2059:
Line 2060: openConMain();
Line 2061:
Line 2062: cmdMain.CommandText = "SELECT MenuCode FROM menus WHERE MenuText = '" + MenuText + "' ";
Line 2063:
Line 2064: readerMain = cmdMain.ExecuteReader();
Line 2065:
Line 2066: readerMain.Read();
Line 2067: if (readerMain.HasRows)
Line 2068: {
Line 2069: currentMenuCode = Convert.ToInt32(readerMain["MenuCode"]);
Line 2070: }
Line 2071:
Line 2072: readerMain.Close();
Line 2073:
Line 2074: if (currentMenuCode > 0 && currentMenuCode != MenuCode)
Line 2075: {
Line 2076: //Update Menu Table
Line 2077: cmdMain.CommandText = "update menus set MenuCode = " + MenuCode + " WHERE MenuText = '" + MenuText + "' ";
Line 2078: cmdMain.ExecuteNonQuery();
Line 2079:
Line 2080: //Update TextInSite Table
Line 2081: OleDbCommand new_cmd = new OleDbCommand();
Line 2082: new_cmd.Connection = conMain;
Line 2083: new_cmd.CommandText = "update textsInTheSite set MenuCode = " + MenuCode + " WHERE menuCode = " + currentMenuCode + " ";
Line 2084: new_cmd.ExecuteNonQuery();
Line 2085: new_cmd.Dispose();
Line 2086: }
Line 2087:
Line 2088: }
Line 2089: catch (Exception e)
Line 2090: {
Line 2091: // eran 7/4/16
Line 2092: SiteRestartAtCatch();
Line 2093: }
Line 2094: finally
Line 2095: {
Line 2096: readerMain.Dispose(); //eran 12/4/16
Line 2097: cmdMain.Dispose(); //vibhav 13/4/16
Line 2098: }
Line 2099:
Line 2100: }
Line 2101:
Line 2102: //vibhav 26/03/2017, replace ' quote with ''
Line 2103: public string StringTrans_replaceSingleQuoteWithDouble(string strFieldValue)
Line 2104: {
Line 2105: string strUpdatedString = "";
Line 2106: strUpdatedString = strFieldValue;
Line 2107:
Line 2108: if (strFieldValue.Length > 0 && strFieldValue.Contains("'"))
Line 2109: {
Line 2110: strUpdatedString = strFieldValue.Replace("'", "''");
Line 2111: }
Line 2112:
Line 2113: return strUpdatedString;
Line 2114: }
Line 2115:
Line 2116: public static string GenerateHTMLFileName(string strMainMenuText, string strSubMenuText, long intMenuCode)
Line 2117: {
Line 2118: string strName = "";
Line 2119: if (strMainMenuText.Length > 0)
Line 2120: strName = ReplaceSpaceWithDash(ReplaceSpecialCharacters(strMainMenuText)) + "-";
Line 2121: if (strSubMenuText.Length > 0)
Line 2122: strName = strName + ReplaceSpaceWithDash(ReplaceSpecialCharacters(strSubMenuText)) + "-";
Line 2123: strName = strName + intMenuCode + ".html";
Line 2124: return strName;
Line 2125: }
Line 2126:
Line 2127: public static string ReplaceSpecialCharacters(string str)
Line 2128: {
Line 2129: string strString = "";
Line 2130: strString = Regex.Replace(str, @"[!""#$%&'()*+,./:;<=>?@[\\\]^_`{|}~-]+", "");
Line 2131: return strString;
Line 2132: }
Line 2133:
Line 2134: public static string ReplaceSpaceWithDash(string str)
Line 2135: {
Line 2136: string strString = "";
Line 2137: strString = Regex.Replace(str, @"\s+", "-");
Line 2138: return strString;
Line 2139: }
Line 2140:
Line 2141: //vibhav 13/12/2018,
Line 2142: public string GetHtmlFileNameByMenuCode(long intMenuCode)
Line 2143: {
Line 2144: string strHTMLFileName = "";
Line 2145:
Line 2146: try
Line 2147: {
Line 2148:
Line 2149: using (conMain)
Line 2150: {
Line 2151: openConMain();
Line 2152:
Line 2153: string strMainMenuText = "";
Line 2154: string strSubMenuText = "";
Line 2155:
Line 2156: string strQuery = "SELECT menus.MenuText, menus.MenuCode, MenuTree.MainMenuCode, m1.MenuText as mainmenutext FROM ";
Line 2157: strQuery += " (( menus INNER JOIN MenuTree ON menus.MenuCode = MenuTree.SubMenuCode ) ";
Line 2158: strQuery += " LEFT JOIN menus m1 ON m1.MenuCode = MenuTree.MainMenuCode ) WHERE MenuTree.MainMenuCode >= 0 AND menus.menucode = " + intMenuCode;
Line 2159:
Line 2160: cmdMain.CommandText = strQuery;
Line 2161: readerMain = cmdMain.ExecuteReader();
Line 2162:
Line 2163: while (readerMain.Read())
Line 2164: {
Line 2165: long intMainMenuCode;
Line 2166: bool parsed = Int64.TryParse(Convert.ToString(readerMain["MainMenuCode"]), out intMainMenuCode);
Line 2167:
Line 2168: if (!parsed)
Line 2169: intMainMenuCode = -1;
Line 2170:
Line 2171: if (intMainMenuCode == 0)
Line 2172: {
Line 2173: strMainMenuText = Convert.ToString(readerMain["MenuText"]).Trim();
Line 2174: }
Line 2175: else if (intMainMenuCode > 0)
Line 2176: {
Line 2177: strMainMenuText = Convert.ToString(readerMain["mainmenutext"]);
Line 2178: strSubMenuText = Convert.ToString(readerMain["MenuText"]).Trim();
Line 2179: }
Line 2180: strHTMLFileName = GenerateHTMLFileName(strMainMenuText, strSubMenuText, intMenuCode);
Line 2181: }
Line 2182: }
Line 2183: }
Line 2184: catch (Exception e)
Line 2185: {
Line 2186:
Line 2187: }
Line 2188: finally
Line 2189: {
Line 2190: readerMain.Dispose(); //eran 12/4/16
Line 2191: cmdMain.Dispose(); //vibhav 13/4/16
Line 2192: }
Line 2193:
Line 2194: return strHTMLFileName;
Line 2195: }
Line 2196:
Line 2197: public int GetMenuCodeByMenuTitle(string MenuText)
Line 2198: {
Line 2199:
Line 2200: int MenuCode = 0;
Line 2201: try
Line 2202: {
Line 2203: using (conMain)
Line 2204: {
Line 2205: openConMain();
Line 2206: cmdMain.CommandText = "SELECT MenuCode FROM menus WHERE MenuText = '" + MenuText + "' ";
Line 2207: readerMain = cmdMain.ExecuteReader();
Line 2208: readerMain.Read();
Line 2209: if (readerMain.HasRows)
Line 2210: {
Line 2211: MenuCode = Convert.ToInt32(readerMain["MenuCode"]);
Line 2212: }
Line 2213: }
Line 2214:
Line 2215: }
Line 2216: catch (Exception e)
Line 2217: {
Line 2218:
Line 2219: }
Line 2220: finally
Line 2221: {
Line 2222: readerMain.Dispose(); //eran 12/4/16
Line 2223: cmdMain.Dispose(); //vibhav 13/4/16
Line 2224: }
Line 2225:
Line 2226: return MenuCode;
Line 2227:
Line 2228: }
Line 2229:
Line 2230: public List<int> getKindOfSliderCodeByMenu(long lngMenuCode)
Line 2231: {
Line 2232: List<int> lstListOfKindOfSlider = new List<int>();
Line 2233: OleDbDataReader rdrData = null;
Line 2234:
Line 2235: try
Line 2236: {
Line 2237: using (conSlider)
Line 2238: {
Line 2239: openConSlider();
Line 2240: cmdSlider.CommandText = "SELECT Distinct KindOfSliderCode FROM SlideShowFilmsLevel WHERE menuCode = " + lngMenuCode;
Line 2241: rdrData = cmdSlider.ExecuteReader();
Line 2242: while (rdrData.Read())
Line 2243: {
Line 2244: lstListOfKindOfSlider.Add(Convert.ToInt32(rdrData["KindOfSliderCode"]));
Line 2245: }
Line 2246: }
Line 2247: }
Line 2248: catch (Exception e)
Line 2249: {
Line 2250:
Line 2251: }
Line 2252: finally
Line 2253: {
Line 2254: rdrData.Dispose(); //eran 12/4/16
Line 2255: cmdSlider.Dispose(); //vibhav 13/4/16
Line 2256: }
Line 2257:
Line 2258: return lstListOfKindOfSlider;
Line 2259:
Line 2260: }
Line 2261:
Line 2262: public List<int> GetDistinctValues(List<int> array)
Line 2263: {
Line 2264: List<int> tmp = new List<int>();
Line 2265:
Line 2266: for (int i = 0; i < array.Count; i++)
Line 2267: {
Line 2268: if (tmp.Contains(array[i]))
Line 2269: continue;
Line 2270: tmp.Add(array[i]);
Line 2271: }
Line 2272:
Line 2273: return tmp;
Line 2274: }
Line 2275:
Line 2276: //vibhav 05-12-2018, Get list of menus
Line 2277: public DataSet GetListOfMenuTextAndCode()
Line 2278: {
Line 2279:
Line 2280: DataSet dsMenus = new DataSet();
Line 2281: // vibhav 2/5/16 add block try-catch
Line 2282:
Line 2283: try
Line 2284: {
Line 2285: using (conMain)
Line 2286: {
Line 2287: openConMain();
Line 2288: cmdMain.CommandText = "SELECT MenuText,MenuCode FROM menus INNER JOIN MenuTree ON menus.MenuCode = MenuTree.SubMenuCode WHERE MenuTree.MainMenuCode = 0 ORDER BY MenuTree.PlaceInMenu";
Line 2289: OleDbDataAdapter objectOfDataAdapter = new OleDbDataAdapter(cmdMain);
Line 2290: objectOfDataAdapter.Fill(dsMenus, "MainMenu");
Line 2291:
Line 2292: cmdMain.CommandText = "SELECT MenuText,MenuCode,MainMenuCode FROM menus INNER JOIN MenuTree ON menus.MenuCode = MenuTree.SubMenuCode";
Line 2293: objectOfDataAdapter = new OleDbDataAdapter(cmdMain);
Line 2294: objectOfDataAdapter.Fill(dsMenus, "AllMenu");
Line 2295: }
Line 2296: }
Line 2297: catch (Exception e)
Line 2298: {
Line 2299:
Line 2300: }
Line 2301: finally
Line 2302: {
Line 2303: cmdMain.Dispose();
Line 2304: }
Line 2305: return dsMenus;
Line 2306: }
Line 2307:
Line 2308: public DataTable PrepareTableForEachManuWithHTMLFileName(DataSet ds)
Line 2309: {
Line 2310: DataTable dt = new DataTable();
Line 2311: if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
Line 2312: {
Line 2313: dt.Columns.Add("MenuCode", typeof(System.Int64));
Line 2314: dt.Columns.Add("HTMLFileName", typeof(System.String));
Line 2315:
Line 2316: List<long> lstReservedMenuCode = new List<long>();
Line 2317: lstReservedMenuCode.AddRange(intReservedCode);
Line 2318:
Line 2319: string strMenuText = "";
Line 2320: string strMainMenuText = "";
Line 2321: string strHTMLFileName = "";
Line 2322: long intMenuCode = 0;
Line 2323:
Line 2324: for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
Line 2325: {
Line 2326: strMainMenuText = Convert.ToString(ds.Tables[0].Rows[i]["MenuText"]).Trim();
Line 2327: intMenuCode = Convert.ToInt64(ds.Tables[0].Rows[i]["MenuCode"]);
Line 2328: //if (!lstReservedMenuCode.Contains(intMenuCode))
Line 2329: strHTMLFileName = CommanFunctions.GenerateHTMLFileName(strMainMenuText, "", intMenuCode);//ReplaceSpaceWithDash(ReplaceSpecialCharacters(strMenuText)) + "-" + intMenuCode + ".html";
Line 2330: //else
Line 2331: // strHTMLFileName = ReplaceSpaceWithDash(strMenuText).ToLower() + ".html";
Line 2332: dt.Rows.Add(intMenuCode, strHTMLFileName);
Line 2333: DataRow[] drSubMenus = ds.Tables[1].Select("MainMenuCode = " + intMenuCode);
Line 2334: for (int j = 0; j < drSubMenus.Length; j++)
Line 2335: {
Line 2336: intMenuCode = Convert.ToInt64(drSubMenus[j]["MenuCode"]);
Line 2337: strMenuText = Convert.ToString(drSubMenus[j]["MenuText"]).Trim();
Line 2338: strHTMLFileName = CommanFunctions.GenerateHTMLFileName(strMainMenuText, strMenuText, intMenuCode);
Line 2339: dt.Rows.Add(intMenuCode, strHTMLFileName);
Line 2340: }
Line 2341: }
Line 2342:
Line 2343: DataTable dtReservedMenuCode = GetListOfMenuTextAndCodeOfResevedMenuCode();
Line 2344: if (dtReservedMenuCode != null && dtReservedMenuCode.Rows.Count > 0)
Line 2345: {
Line 2346: for (int i = 0; i < dtReservedMenuCode.Rows.Count; i++)
Line 2347: {
Line 2348: strMenuText = Convert.ToString(dtReservedMenuCode.Rows[i]["MenuText"]).Trim();
Line 2349: intMenuCode = Convert.ToInt64(dtReservedMenuCode.Rows[i]["MenuCode"]);
Line 2350: strHTMLFileName = CommanFunctions.ReplaceSpaceWithDash(strMenuText).ToLower() + ".html";
Line 2351: dt.Rows.Add(intMenuCode, strHTMLFileName);
Line 2352: }
Line 2353: }
Line 2354:
Line 2355: }
Line 2356: return dt;
Line 2357: }
Line 2358:
Line 2359: public DataTable GetListOfMenuTextAndCodeOfResevedMenuCode()
Line 2360: {
Line 2361: DataTable dtMenus = new DataTable();
Line 2362:
Line 2363: string strReservedMenuCode = "";
Line 2364: for (int i = 0; i < intReservedCode.Length; i++)
Line 2365: {
Line 2366: strReservedMenuCode = strReservedMenuCode + intReservedCode[i] + ",";
Line 2367: }
Line 2368: strReservedMenuCode = strReservedMenuCode.Trim(',');
Line 2369:
Line 2370: try
Line 2371: {
Line 2372: using (conMain)
Line 2373: {
Line 2374: openConMain();
Line 2375: cmdMain.CommandText = "SELECT MenuText,MenuCode FROM menus WHERE MenuCode IN (" + strReservedMenuCode + ")";
Line 2376: OleDbDataAdapter objectOfDataAdapter = new OleDbDataAdapter(cmdMain);
Line 2377: objectOfDataAdapter.Fill(dtMenus);
Line 2378: }
Line 2379: }
Line 2380: catch (Exception e)
Line 2381: {
Line 2382:
Line 2383: }
Line 2384: finally
Line 2385: {
Line 2386: cmdMain.Dispose();
Line 2387: }
Line 2388: return dtMenus;
Line 2389: }
Line 2390:
Line 2391: /// <summary>
Line 2392: /// Generate HTML static pages, vibhav 05-12-2018
Line 2393: /// </summary>
Line 2394: /// <param name="lngMenuCode">Pass 0 if need to generate HTML for all the pages ELSE pass validate page ID if need to generate HTML for a single page</param>
Line 2395: /// <returns></returns>
Line 2396:
Line 2397: public bool MakeDynamicPageStaticFromExternalCode(long lngMenuCode, string RelativePathOfSiteTextsAndSettings, string strParentPathLocation)
Line 2398: // eran 20/4/19
Line 2399: {
Line 2400: MainConnectionPath = RelativePathOfSiteTextsAndSettings;
Line 2401: string strErrorMsg = "";
Line 2402: return MakeDynamicPageStatic(lngMenuCode, strParentPathLocation, ref strErrorMsg);
Line 2403: }
Line 2404:
Line 2405: public bool MakeDynamicPageStatic(long lngMenuCode, string strParentPathLocation, ref string strErrorMsg)
Line 2406: {
Line 2407:
Line 2408: if (lngMenuCode == null)
Line 2409: lngMenuCode = 0;
Line 2410:
Line 2411: bool isSuccess = false;
Line 2412:
Line 2413: try
Line 2414: {
Line 2415: DataSet ds = GetListOfMenuTextAndCode();
Line 2416: DataTable dt = PrepareTableForEachManuWithHTMLFileName(ds);
Line 2417:
Line 2418: if (lngMenuCode > 0 && dt.Rows.Count > 0)
Line 2419: {
Line 2420: DataRow[] filteredRows = dt.Select("MenuCode <> " + lngMenuCode);
Line 2421: foreach (DataRow row in filteredRows)
Line 2422: row.Delete();
Line 2423: }
Line 2424:
Line 2425: List<long> lstReservedMenuCode = new List<long>();
Line 2426: lstReservedMenuCode.AddRange(intReservedCode);
Line 2427: StringBuilder data = new StringBuilder();
Line 2428: StringBuilder stbMenuNameWithCode = new StringBuilder();
Line 2429: for (int i = 0; i < dt.Rows.Count; i++)
Line 2430: {
Line 2431:
Line 2432: string strURL = HttpContext.Current.Request.Url.AbsoluteUri.ToLower();
Line 2433: string strFinalURL = "";
Line 2434:
Line 2435: if (lstReservedMenuCode.Contains(Convert.ToInt32(dt.Rows[i]["MenuCode"])))
Line 2436: {
Line 2437: if (!string.IsNullOrEmpty(strParentPathLocation))
Line 2438: strFinalURL = strURL.Replace("/" + strParentPathLocation.ToLower() + "/" + GetCurrentPageName(), "") + "/details.aspx?title=" + Convert.ToString(dt.Rows[i]["HTMLFileName"]).Replace(".html", "") + "&gethtml=1";
Line 2439: else
Line 2440: strFinalURL = strURL.Replace("/" + GetCurrentPageName(), "") + "/details.aspx?title=" + Convert.ToString(dt.Rows[i]["HTMLFileName"]).Replace(".html", "") + "&gethtml=1";
Line 2441:
Line 2442: }
Line 2443: else
Line 2444: {
Line 2445: if (!string.IsNullOrEmpty(strParentPathLocation))
Line 2446: strFinalURL = strURL.Replace("/" + strParentPathLocation.ToLower() + "/" + GetCurrentPageName(), "") + "/details.aspx?id=" + Convert.ToString(dt.Rows[i]["MenuCode"]) + "&gethtml=1";
Line 2447: else
Line 2448: strFinalURL = strURL.Replace("/" + GetCurrentPageName(), "") + "/details.aspx?id=" + Convert.ToString(dt.Rows[i]["MenuCode"]) + "&gethtml=1";
Line 2449: }
Line 2450:
Line 2451: // We'll use WebClient class for reading HTML of web page
Line 2452: WebClient MyWebClient = new WebClient();
Line 2453: MyWebClient.Headers.Add("user-agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.0.3705;)");
Line 2454: // Read web page HTML to byte array
Line 2455: Byte[] PageHTMLBytes;
Line 2456:
Line 2457: UTF8Encoding oUTF8 = new UTF8Encoding();
Line 2458: PageHTMLBytes = MyWebClient.DownloadData(strFinalURL);
Line 2459: data.Append(oUTF8.GetString(PageHTMLBytes));
Line 2460: for (int j = 0; j < dt.Rows.Count; j++)
Line 2461: {
Line 2462: data = data.Replace("href=\"details.aspx?Id=" + Convert.ToString(dt.Rows[j]["MenuCode"]) + "\"", "href=\"" + Convert.ToString(dt.Rows[j]["HTMLFileName"]) + "\"");
Line 2463: if (lstReservedMenuCode.Contains(Convert.ToInt32(dt.Rows[j]["MenuCode"])))
Line 2464: data = data.Replace("href=\"details.aspx?title=" + Convert.ToString(dt.Rows[j]["HTMLFileName"]).Replace(".html", "") + "\"", "href=\"" + Convert.ToString(dt.Rows[j]["HTMLFileName"]) + "\"");
Line 2465: }
Line 2466: if (!string.IsNullOrEmpty(strParentPathLocation))
Line 2467: System.IO.File.WriteAllText(HttpContext.Current.Server.MapPath("../" + Convert.ToString(dt.Rows[i]["HTMLFileName"])), data.ToString());
Line 2468: else
Line 2469: System.IO.File.WriteAllText(HttpContext.Current.Server.MapPath(Convert.ToString(dt.Rows[i]["HTMLFileName"])), data.ToString());
Line 2470: data.Length = 0;
Line 2471:
Line 2472: if (lngMenuCode <= 0)
Line 2473: stbMenuNameWithCode.AppendLine(Convert.ToString(dt.Rows[i]["MenuCode"]) + " |##| " + Convert.ToString(dt.Rows[i]["HTMLFileName"]));
Line 2474:
Line 2475: }
Line 2476:
Line 2477: if (lngMenuCode <= 0)
Line 2478: {
Line 2479: if (stbMenuNameWithCode.Length > 0)
Line 2480: {
Line 2481: string strFilePath = HttpContext.Current.Server.MapPath("../pic/redirectDetails2.txt");
Line 2482: System.IO.File.WriteAllText(strFilePath, Convert.ToString(stbMenuNameWithCode));
Line 2483: stbMenuNameWithCode = null;
Line 2484: }
Line 2485:
Line 2486: if (CheckFileExistsOrNot("../pic/EnableStaticSite.txt"))
Line 2487: {
Line 2488: string strFileContent = getContentFromFile("../pic/EnableStaticSite.txt");
Line 2489: if (strFileContent.ToLower() == "yes" || strFileContent.ToLower() == "true")
Line 2490: {
Line 2491: long intMainMenuCode = GetMenuCodeINIndexASPFile();
Line 2492: if (intMainMenuCode > 0)
Line 2493: {
Line 2494: DataRow[] dtMenuName = dt.Select("MenuCode = " + intMainMenuCode);
Line 2495: string strHTMLFileName = "";
Line 2496: if (dtMenuName.Length > 0)
Line 2497: strHTMLFileName = Convert.ToString(dtMenuName[0]["HTMLFileName"]);
Line 2498: if (!string.IsNullOrEmpty(strHTMLFileName))
Line 2499: updateIndexASPFile(Convert.ToString(intMainMenuCode), strHTMLFileName);
Line 2500: }
Line 2501: }
Line 2502: }
Line 2503: }
Line 2504:
Line 2505: isSuccess = true;
Line 2506:
Line 2507: }
Line 2508: catch (Exception ex)
Line 2509: {
Line 2510: strErrorMsg = ex.Message;
Line 2511: }
Line 2512:
Line 2513: return isSuccess;
Line 2514:
Line 2515: }
Line 2516:
Line 2517: public void updateIndexASPFile(string strMenuCode, string strHTMLFileName)
Line 2518: {
Line 2519: string strFileContent = getContentFromFile("../index.asp");
Line 2520: strFileContent = strFileContent.ToLower();
Line 2521: strFileContent = strFileContent.Replace("details.aspx?id=" + strMenuCode, strHTMLFileName);
Line 2522: File.WriteAllText(HttpContext.Current.Server.MapPath("../index.asp"), strFileContent, Encoding.UTF8);
Line 2523: }
Line 2524:
Line 2525: public long GetMenuCodeINIndexASPFile()
Line 2526: {
Line 2527: long intMenuCode = 0;
Line 2528:
Line 2529: if (CheckFileExistsOrNot("../index.asp"))
Line 2530: {
Line 2531: string strFileContent = getContentFromFile("../index.asp");
Line 2532: strFileContent = strFileContent.ToLower();
Line 2533:
Line 2534: if (strFileContent.Contains("details.aspx?id="))
Line 2535: {
Line 2536: int intStartInx = strFileContent.IndexOf("?id=");
Line 2537: int intEndInx = strFileContent.IndexOf("\"", intStartInx);
Line 2538: string strMenuCode = strFileContent.Substring(intStartInx + 4, intEndInx - (intStartInx + 4)).Trim();
Line 2539:
Line 2540: bool isInt = false;
Line 2541: isInt = Int64.TryParse(strMenuCode, out intMenuCode);
Line 2542: }
Line 2543: }
Line 2544:
Line 2545: return intMenuCode;
Line 2546: }
Line 2547:
Line 2548: public string GetCurrentPageName()
Line 2549: {
Line 2550: string sPath = HttpContext.Current.Request.Url.AbsolutePath;
Line 2551: System.IO.FileInfo oInfo = new System.IO.FileInfo(sPath);
Line 2552: string sRet = oInfo.Name;
Line 2553: return sRet.ToLower();
Line 2554: }
Line 2555:
Line 2556: //-------------------------By Nikunj---------------------------------------------------------------------//
Line 2557:
Line 2558: #region Nikunj Code
Line 2559: /// <summary>
Line 2560: /// Created by Nikunj 07/08/2015
Line 2561: /// gets All language to fill language dropdown
Line 2562: /// </summary>
Line 2563: /// <param name="m_con"></param>
Line 2564: /// <param name="TextOfCode"></param>
Line 2565: /// <param name="RunNo"></param>
Line 2566: /// <returns></returns>
Line 2567: public DataTable getAllLanguages(OleDbConnection m_con, out string TextOfCode, out string RunNo)
Line 2568: {
Line 2569: OleDbDataAdapter adaptor = null;
Line 2570: OleDbCommandBuilder builder = null;
Line 2571: DataTable tblTarget = null;
Line 2572: string strSql = "";
Line 2573:
Line 2574: strSql = "select RunNo,TextOfCode from master_coding_general";
Line 2575: adaptor = new OleDbDataAdapter(strSql, m_con);
Line 2576: builder = new OleDbCommandBuilder(adaptor);
Line 2577:
Line 2578:
Line 2579: tblTarget = new DataTable();
Line 2580: adaptor.Fill(tblTarget);
Line 2581: TextOfCode = "TextOfCode";
Line 2582: RunNo = "RunNo";
Line 2583: return tblTarget;
Line 2584: }
Line 2585:
Line 2586: /// <summary>
Line 2587: /// Created by Nikunj 07/08/2015
Line 2588: /// </summary>
Line 2589: /// <param name="LogContent"></param>
Line 2590: public static void AppendLog(string LogContent)
Line 2591: {
Line 2592: try
Line 2593: {
Line 2594: string flname = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Error_Log.txt");
Line 2595: FileStream fs = File.Open(flname, FileMode.OpenOrCreate | FileMode.Append);
Line 2596:
Line 2597: StreamWriter sw = new StreamWriter(fs);
Line 2598: sw.WriteLine(string.Format("{0} ==>{1}", LogContent, DateTime.Now));
Line 2599: sw.Flush();
Line 2600: sw.Close();
Line 2601: fs.Close();
Line 2602: }
Line 2603: catch (Exception ex) { }
Line 2604: }
Line 2605:
Line 2606: /// <summary>
Line 2607: /// Created by Nikunj 07/16/2015
Line 2608: /// </summary>
Line 2609: /// <param name="LanguageID"></param>
Line 2610: public string[,] FetchTextInCurrentLanguageFromDbForMultiLingual(int LanguageID)
Line 2611: {
Line 2612: string TextInCurrentLanguage = LanguageID.ToString();
Line 2613: int count = 0;
Line 2614: using (conLanguage)
Line 2615: {
Line 2616: if (conLanguage.State == ConnectionState.Closed)
Line 2617: {
Line 2618: openConLanguagePage();
Line 2619: }
Line 2620:
Line 2621: cmdLanguage.CommandText = "SELECT COUNT(*) FROM TextsInSelectedLanguage WHERE LanguageId = " + LanguageID + " ";
Line 2622: count = Convert.ToInt32(cmdLanguage.ExecuteScalar());
Line 2623:
Line 2624: cmdLanguage.Dispose(); //vibhav 13/4/16
Line 2625:
Line 2626: }
Line 2627:
Line 2628: if (count > 0)
Line 2629: {
Line 2630: Language_TextID_Text = new string[count, 2];
Line 2631: }
Line 2632:
Line 2633: using (conLanguage)
Line 2634: {
Line 2635: if (conLanguage.State == ConnectionState.Closed)
Line 2636: {
Line 2637: openConLanguagePage();
Line 2638: }
Line 2639:
Line 2640: cmdLanguage.CommandText = "SELECT TextID,TextInLanguage FROM TextsInSelectedLanguage WHERE LanguageId = " + Convert.ToInt32(TextInCurrentLanguage) + " ";
Line 2641:
Line 2642: readerLanguage = cmdLanguage.ExecuteReader();
Line 2643: int RowCount = 0;
Line 2644: while (readerLanguage.Read())
Line 2645: {
Line 2646: Language_TextID_Text[RowCount, 0] = Convert.ToString(readerLanguage["TextID"]);
Line 2647: Language_TextID_Text[RowCount, 1] = Convert.ToString(readerLanguage["TextInLanguage"]);
Line 2648: RowCount = RowCount + 1;
Line 2649: }
Line 2650:
Line 2651: cmdLanguage.Dispose(); //vibhav 13/4/16
Line 2652: }
Line 2653:
Line 2654: return Language_TextID_Text;
Line 2655: }
Line 2656:
Line 2657: /// <summary>
Line 2658: ///To get langauge text by passing TextID
Line 2659: /// Created by Nikunj 07/16/2015
Line 2660: /// </summary>
Line 2661: /// <param name="TextID"></param>
Line 2662: /// <returns></returns>
Line 2663: public string GetLanguageInTextForMultiLingual(int TextID)
Line 2664: {
Line 2665: string TextInLanguageByTextID = "";
Line 2666: if (Language_TextID_TextIn != null && Language_TextID_TextIn.Length > 0)
Line 2667: {
Line 2668: for (int i = 0; i < (Language_TextID_TextIn.Length) / 2; i++)
Line 2669: {
Line 2670: if (Language_TextID_TextIn[i, 0] == Convert.ToString(TextID))
Line 2671: {
Line 2672: TextInLanguageByTextID = Language_TextID_TextIn[i, 1];
Line 2673: break;
Line 2674: }
Line 2675: }
Line 2676: }
Line 2677:
Line 2678: return TextInLanguageByTextID;
Line 2679: }
Line 2680:
Line 2681: /// <summary>
Line 2682: /// Created by nikunj07/16/2015
Line 2683: /// gets and sets current language manages by cookies
Line 2684: /// </summary>
Line 2685: public string CurrentLanguageId
Line 2686: {
Line 2687: get
Line 2688: {
Line 2689: return Convert.ToString(HttpContext.Current.Request.Cookies["CurrentLanguage"].Value);
Line 2690: }
Line 2691: set
Line 2692: {
Line 2693: HttpContext.Current.Response.Cookies["CurrentLanguage"].Value = value;
Line 2694: }
Line 2695: }
Line 2696: #endregion
Line 2697:
Line 2698: //-------------------------END By Nikunj---------------------------------------------------------------------//
Line 2699:
Line 2700: //-------------------------By Redi 22.04.2022 OAuth---------------------------------------------------------------------//
Line 2701: #region Redi 22.04.2022
Line 2702: /// <summary>
Line 2703: /// Created by Redi 22.04.2022
Line 2704: /// After Authenticating with to google, authorizing using code and getting token back
Line 2705: /// </summary>
Line 2706: public void SendAuthorizationRequest(string returnURI)
Line 2707: {
Line 2708: CredentialProperties oAuthCredentials = OAuthConfigs.Instance.GetCredentials();
Line 2709: string querystring = "client_id=" + oAuthCredentials.ClientId + "&client_secret=" + oAuthCredentials.ClientSecret + "&code=" + oAuthCredentials.Code + "&redirect_uri=" + returnURI + "&grant_type=authorization_code";
Line 2710:
Line 2711: using (WebClient wc = new WebClient())
Line 2712: {
Line 2713: wc.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
Line 2714: wc.Encoding = System.Text.Encoding.UTF8;
Line 2715: string result = wc.UploadString(oAuthCredentials.TokenUri.AbsoluteUri, "POST", querystring);
Line 2716:
Line 2717: OAuthToken token = Newtonsoft.Json.JsonConvert.DeserializeObject<OAuthToken>(result);
Line 2718: OAuthConfigs.Instance.SetOAuthToken(token);
Line 2719: }
Line 2720: }
Line 2721:
Line 2722: /// <summary>
Line 2723: /// Created by Redi 22.04.2022
Line 2724: /// Refreshing authorization token
Line 2725: /// </summary>
Line 2726: public bool RefreshAuthToken()
Line 2727: {
Line 2728: bool tokenRefreshed = false;
Line 2729: CredentialProperties oAuthCredentials = OAuthConfigs.Instance.GetCredentials();
Line 2730: OAuthToken oAuthToken = OAuthConfigs.Instance.GetOAuthToken();
Line 2731:
Line 2732: string querystring = "client_id=" + oAuthCredentials.ClientId + "&client_secret=" + oAuthCredentials.ClientSecret + "&grant_type=refresh_token&refresh_token=" + oAuthToken.RefreshToken;
Line 2733: try
Line 2734: {
Line 2735: using (WebClient wc = new WebClient())
Line 2736: {
Line 2737: wc.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
Line 2738: wc.Encoding = System.Text.Encoding.UTF8;
Line 2739: string result = wc.UploadString(oAuthCredentials.TokenUri.AbsoluteUri, "POST", querystring);
Line 2740:
Line 2741: OAuthToken token = Newtonsoft.Json.JsonConvert.DeserializeObject<OAuthToken>(result);
Line 2742: token.RefreshToken = oAuthToken.RefreshToken;
Line 2743: OAuthConfigs.Instance.SetOAuthToken(token);
Line 2744: tokenRefreshed = true;
Line 2745: }
Line 2746: }
Line 2747: catch (Exception e)
Line 2748: {
Line 2749: //RefreshToken has expired so auth needed again
Line 2750:
Line 2751: }
Line 2752: return tokenRefreshed;
Line 2753: }
Line 2754:
Line 2755: /// <summary>
Line 2756: /// Created by Redi 22.04.2022
Line 2757: /// add retry to try again
Line 2758: /// </summary>
Line 2759: /// <param name="retry"></param>
Line 2760: public void SendEmailViaApi(MailMessage message, bool retry)
Line 2761: {
Line 2762: try
Line 2763: {
Line 2764: MemoryStream msMessage = OAuthConfigs.Instance.ConvertMailMessageToMemoryStream(message);
Line 2765: string rawMessageBody = Convert.ToBase64String(msMessage.GetBuffer())
Line 2766: .TrimEnd('=')
Line 2767: .Replace('+', '-')
Line 2768: .Replace('/', '_');
Line 2769:
Line 2770: OAuthToken oAuthToken = OAuthConfigs.Instance.GetOAuthToken();
Line 2771: // Modifed by jemark 08-06-2023 START
Line 2772: //string path = Path.Combine(Path.GetDirectoryName(System.AppDomain.CurrentDomain.BaseDirectory), "/PIC/UserForGmailCloudMailServer.txt");
Line 2773: string path = @"~/PIC/UserForGmailCloudMailServer.txt";
Line 2774: // Modifed by jemark 08-06-2023 START
Line 2775: string senderEmail = getContentFromFile(path);
Line 2776: string endpoint = "https://gmail.googleapis.com/gmail/v1/users/" + senderEmail + "/messages/send";
Line 2777: string body = "{\"raw\":\"" + rawMessageBody + "\"}";
Line 2778:
Line 2779: using (WebClient wc = new WebClient())
Line 2780: {
Line 2781: wc.Headers.Add("Content-Type", "application/json");
Line 2782: wc.Headers.Add("Authorization", "Bearer " + oAuthToken.AccessToken);
Line 2783: string result = wc.UploadString(endpoint, "POST", body);
Line 2784: }
Line 2785: }
Line 2786: catch (Exception e)
Line 2787: {
Line 2788: //RefreshToken has expired so auth needed again
Line 2789: bool tokenRefreshed = RefreshAuthToken();
Line 2790: if (tokenRefreshed && retry)
Line 2791: {
Line 2792: SendEmailViaApi(message, false);
Line 2793: }
Line 2794: else
Line 2795: {
Line 2796: throw;
Line 2797: }
Line 2798: }
Line 2799: }
Line 2800:
Line 2801: #endregion
Line 2802:
Line 2803: //-------------------------END By Redi 22.04.2022 OAuth---------------------------------------------------------------------//
Line 2804: }
Line 2805:
Line 2806: public class TableColumnInformation
Line 2807: {
Line 2808: private string columnName;
Line 2809: public string ColumnName
Line 2810: {
Line 2811: get
Line 2812: {
Line 2813: return columnName;
Line 2814: }
Line 2815: set
Line 2816: {
Line 2817: columnName = value;
Line 2818: }
Line 2819: }
Line 2820:
Line 2821: private string columnValue;
Line 2822: public string ColumnValue
Line 2823: {
Line 2824: get
Line 2825: {
Line 2826: return columnValue;
Line 2827: }
Line 2828: set
Line 2829: {
Line 2830: columnValue = value;
Line 2831: }
Line 2832: }
Line 2833:
Line 2834: private string columnDataType;
Line 2835: public string ColumnDataType
Line 2836: {
Line 2837: get
Line 2838: {
Line 2839: return columnDataType;
Line 2840: }
Line 2841: set
Line 2842: {
Line 2843: columnDataType = value;
Line 2844: }
Line 2845: }
Line 2846: }
|