public static string DeleteAddress(string id) { try { dbConnection dbc = new dbConnection(); string AddressId = id; string QUESTATE = "select CustomerAddress.Id as addrid,FirstName,LastName,MobileNo,(select TagName from TagMaster where TagMaster.Id=CustomerAddress.TagId and TagMaster.IsActive=1)as tagName,Address,(select CityName from CityMaster where CityMaster.IsActive=1 and CityMaster.id=CustomerAddress.CityId) as City,(select statename from StateMaster where StateMaster.id=CustomerAddress.StateId and StateMaster.IsActive=1)as statename,PinCode from CustomerAddress where CustomerAddress.IsActive=1 and CustomerAddress.IsDeleted=0 and len(PinCode)>=6 and CustomerAddress.Id=" + AddressId + ""; DataTable dt = dbc.GetDataTable(QUESTATE); string response = ""; if (dt.Rows.Count > 0) { string updae = "update CustomerAddress set IsActive=0 where CustomerAddress.id=" + AddressId + ""; int i = dbc.ExecuteQuery(updae); i = 1; if (i > 0) { response = "1"; } } return(response); } catch { return(null); } }
public static string GetMainCourse(string id) { try { dbConnection dbc = new dbConnection(); string cid = id; string QUESTATE = "SELECT Id,statename from StateMaster where IsActive=1 and CountryId='" + id + "' order by id asc"; DataTable dt = dbc.GetDataTable(QUESTATE); string response = ""; if (dt.Rows.Count > 0) { DataView dv = dt.DefaultView; dv.Sort = "Id asc"; dt = dv.ToTable(); for (int i = 0; i < dt.Rows.Count; i++) { response = response + dt.Rows[i]["id"].ToString() + ","; response = response + dt.Rows[i]["StateName"].ToString() + "###"; } response = response.TrimEnd('#'); return(response); } return(response); } catch { return(null); } }
public static string GetCityList(string id) { try { dbConnection dbc = new dbConnection(); string cid = id; string quecity = "SELECT Id,CityName from CityMaster where IsActive=1 AND StateId='" + id + "' order by id asc"; DataTable dt = dbc.GetDataTable(quecity); string response = ""; if (dt.Rows.Count > 0) { DataView dv = dt.DefaultView; dv.Sort = "ID asc"; dt = dv.ToTable(); for (int i = 0; i < dt.Rows.Count; i++) { response = response + dt.Rows[i]["id"].ToString() + ","; response = response + dt.Rows[i]["Cityname"].ToString() + "###"; } response = response.TrimEnd('#'); return(response); } return(response); } catch { return(null); } }
protected void search_Click(object sender, EventArgs e) { dbConnection db1 = new dbConnection(); if (searchlabel.Text == "") { Response.Redirect("index.aspx"); } string search = searchlabel.Text; Search sc = new Search(); db1.dt = sc.searchFranchise(search); if (db1.dt.Rows.Count > 0) { //Session["search"] = search; string value = search.ToString(); //Response.Redirect("search.aspx"); Response.Redirect("search.aspx?search=" + value); db1.closeConnection(); } else { Response.Redirect("search.aspx"); } }
public static List <string> GetProductName(string prefixText) { dbConnection dbc = new dbConnection(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = dbc.consString; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "select Name, Id from Product where Name like @SearchText + '%'"; cmd.Parameters.AddWithValue("@SearchText", prefixText); cmd.Connection = conn; conn.Open(); List <string> products = new List <string>(); using (SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { products.Add(sdr["Name"].ToString()); //products.Add(string.Format("{0}-{1}", sdr["Name"], sdr["Id"])); } } conn.Close(); return(products); } } }
public static bool CheckCustomerCode(string codeText) { dbConnection dbc = new dbConnection(); bool flag = true; DataTable dtFdata = dbc.GetDataTable("select * FROM Franchisee WHERE ISActive = 1 AND [FranchiseeCustomerCode] = '" + codeText + "'"); if (dtFdata.Rows.Count > 0) { flag = false; return(flag); } DataTable dtMFdata = dbc.GetDataTable("select * FROM MasterFranchisee WHERE ISActive = 1 AND [MasterFranchiseeCustomerCode] = '" + codeText + "'"); if (dtMFdata.Rows.Count > 0) { flag = false; return(flag); } DataTable dtSFdata = dbc.GetDataTable("select * FROM SuperFranchisee WHERE ISActive = 1 AND [SuperFranchiseeCustomerCode] = '" + codeText + "'"); if (dtSFdata.Rows.Count > 0) { flag = false; return(flag); } return(flag); }
public static bool SendEmailForFranchies(string sTo, string sFrom, string sSubject, string sBody) { bool functionReturnValue = false; dbConnection dbCon = new dbConnection(); try { var settingData = " SELECT TOP 1 * FROM tblGeneralSettings "; DataTable dtsettingData = dbCon.GetDataTable(settingData); if (dtsettingData != null && dtsettingData.Rows.Count > 0) { var mail = new System.Net.Mail.MailMessage(dtsettingData.Rows[0]["SMTPUsername"].ToString(), sTo); mail.Subject = sSubject; mail.Body = sBody; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = dtsettingData.Rows[0]["SMTPServer"].ToString(); smtp.EnableSsl = false; NetworkCredential networkCredential = new NetworkCredential(dtsettingData.Rows[0]["SMTPUsername"].ToString(), dtsettingData.Rows[0]["SMTPPassword"].ToString()); smtp.UseDefaultCredentials = true; smtp.Credentials = networkCredential; smtp.Port = Convert.ToInt32(dtsettingData.Rows[0]["portNum"]); smtp.Send(mail); } functionReturnValue = true; } catch (Exception Ex) { throw Ex; } return(functionReturnValue); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { int WorkshopId = 0; int.TryParse(Request.Cookies["TUser"]["WorkshopId"], out WorkshopId); dbConnection dbcon = new dbConnection(); clsDataSourse db = new clsDataSourse(); startdate.Value = dbcon.getindiantime().ToString("dd-MMM-yyyy"); enddate.Value = dbcon.getindiantime().ToString("dd-MMM-yyyy"); if (Request.QueryString["sdate"] != null) { startdate.Value = Request.QueryString["sdate"]; } if (Request.QueryString["edate"] != null) { enddate.Value = Request.QueryString["edate"]; } DataTable dt = db.CarInList(startdate.Value, enddate.Value, false, WorkshopId.ToString()); GridView1.DataSource = dt; GridView1.DataBind(); } } catch (Exception aa) { } }
public static string SavePaymentStatusHistory(string OrderId, string ReceiveAmount) { dbConnection dbc1 = new dbConnection(); int IsUserId = Convert.ToInt32(loginuserId); int statusId = 40;//Payment Received-Sosho if (IsUserType == "3") { statusId = 20;//Payment Received-Delivery } else if (IsUserType == "2") { statusId = 30;//Payment Received-Frenchies } DateTime dt = DateTime.Now; DataTable dtchkExists = dbc1.GetDataTable("SELECT Top 1 PHistoryid FROM [dbo].[tblPaymentHistory] WHERE orderId = " + OrderId + " AND userid = " + IsUserId + " AND UserType = " + IsUserType + " Order by PHistoryid desc"); if (dtchkExists.Rows.Count > 0) { string historyId = dtchkExists.Rows[0]["PHistoryid"].ToString(); string updateQry = " UPDATE tblPaymentHistory SET OrderId = " + OrderId + " , ReceiveAmount = " + ReceiveAmount + " UserId = " + IsUserId + " , UserType = " + IsUserType + ", ReceiveDate = '" + dt.ToString() + "',StatusId = " + statusId + ",ModifiedOn = '" + dt.ToString() + "',ModifiedBy = " + IsUserId + " Where PHistoryId = " + historyId; dbc1.ExecuteQuery(updateQry); } else { string query = "INSERT INTO [dbo].[tblPaymentHistory] ([OrderId] ,[ReceiveAmount],[UserId],[UserType],[ReceiveDate],[StatusId],[IsActive],[IsDeleted],[CreatedOn],[CreatedBy]) " + " VALUES ('" + OrderId + "','" + ReceiveAmount + "','" + IsUserId + "','" + IsUserType + "','" + dt.ToString() + "'," + statusId + ",1,0,'" + dt.ToString() + "'," + IsUserId + ")"; int VAL = dbc1.ExecuteQuery(query); } return("1"); }
static public bool verifyZip(string zipcode) { dbConnection dbc = new dbConnection(); SqlConnection baglanti = new SqlConnection(@"Data Source=BRAHIMPC;Database=ETARIM;User ID=sa;Password=12345;Connect Timeout=200; pooling='true'; Max Pool Size=200;"); baglanti.Open(); SqlDataAdapter adapter = new SqlDataAdapter("select * from tbl_zip where zip = '" + zipcode + "'", baglanti); DataTable dt = new DataTable(); try { adapter.Fill(dt); DataTableReader dtr = dt.CreateDataReader(); if (dtr.Read()) { return(true); } } catch (SqlException ex) { throw new Exception(ex.Message + " (select * from tbl_zip where zip ="); } finally { adapter.Dispose(); baglanti.Close(); } return(false); }
public static string SaveData(string Id) { dbConnection dbc1 = new dbConnection(); try { if (dbc1.ExecuteQuery("Update [order] set OrderStatusId=70 where id=" + Id) > 0) { string qry = "SELECT Customer.Mobile, [Order].Id From [Order] INNER JOIN Customer ON [Order].CustomerId = Customer.Id where [Order].Id=" + Id; DataTable dt = dbc1.GetDataTable(qry); string mono = ""; string sms = ""; if (dt != null && dt.Rows.Count > 0) { string oid = dt.Rows[0]["Id"].ToString(); mono = dt.Rows[0]["Mobile"].ToString(); sms = "Your SoSho order ID " + oid + " has been successfully delivered. We hope that you like our product. To get more discounted offers, stay updated on SoSho.in"; } dbc1.SendSMS(mono, sms); } return("1"); } catch (Exception ex) { } return("0"); }
public static string SaveData1(string Id) { dbConnection dbc1 = new dbConnection(); try { if (dbc1.ExecuteQuery("Update [order] set OrderStatusId=90 where id=" + Id) > 0) { string qry = "SELECT Customer.Mobile, [Order].Id From [Order] INNER JOIN Customer ON [Order].CustomerId = Customer.Id where [Order].Id=" + Id; DataTable dt = dbc1.GetDataTable(qry); string mono = ""; string sms = ""; if (dt != null && dt.Rows.Count > 0) { string oid = dt.Rows[0]["Id"].ToString(); mono = dt.Rows[0]["Mobile"].ToString(); sms = "Your SoSho order number " + oid + " has been cancelled. We would like to see you around again. Get more discounts and offers only on https://sosho.in."; } dbc1.SendSMS(mono, sms); } return("1"); } catch (Exception ex) { } return("0"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { msg.Visible = false; if (Request.QueryString["id"] != null) { dbConnection db = new dbConnection(); string data = "SELECT * FROM categories WHERE id=" + Request.QueryString["id"]; SqlDataAdapter da = new SqlDataAdapter(data, db.con); DataSet ds = new DataSet(); da.Fill(ds, "categories"); DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; name.Text = dr["name"].ToString(); if (dr["image"] != null) { string str = image.FileName; lblimage.Text = "<img id='id' src='../uploads/" + dr["image"] + "' width='100' height='100' />"; hiddenimage.Value = dr["image"].ToString(); } } } }
public static void InsertLogs(InvoiceLOGS.InvoiceLogLevel Logtype, string tranid = "", int paymentmethod = 0, bool issuccess = false, String ShortMsg = "", String detailmsg = "") { dbConnection dbc = new dbConnection(); try { DateTime curr_time = dbc.getindiantime(); int logtypeid = 0; logtypeid = (int)Logtype; if (InvoiceLOGS.InvoiceLogLevel.Success.CompareTo(Logtype) == 1) { //logtypeid = InvoiceLOGS.InvoiceLogLevel.Success; } //InvoiceLOGS.InvoiceLogLevel.TryParse(Logtype.ToString(), out logtypeid); //InvoiceLOGS.InvoiceLogLevel myval = (InvoiceLOGS.InvoiceLogLevel)Enum.Parse(typeof(TestEnum), Logtype.ToString()); string[] insert = { logtypeid.ToString(), tranid, paymentmethod.ToString(), issuccess.ToString(), detailmsg, ShortMsg }; string cmd = "INSERT INTO [dbo].[PaymentTransactionLogs] ([LogLevel],[TrnId],[PaymentMethod],[IsSuccess],[ResponseString],[DOC],[ShortMsg]) VALUES (@1,@2,@3,@4,@5,DATEADD(MINUTE, 330, GETUTCDATE()),@6)"; int value = dbc.ExecuteQueryWithParams(cmd, insert); } catch (Exception ex) { } finally { dbc.closeConnection(); } }
private void Enter_Click(object sender, RoutedEventArgs e) { dbConnection conn = new dbConnection(); Button b = sender as Button; SQLiteDataReader reader = conn.ViewTable("Employee"); bool key = false; bool admin = false; while (reader.Read()) { ADMINID = (reader["ID"]).ToString(); ADMINNAME = ((string)reader["name"]); if (EmployeeID.Password.Equals(ADMINID) && EmployeeName.Text.Equals(ADMINNAME)) { //var foodDB = new FoodDBTestWindow(); //foodDB.Closed += Window_Closed; //foodDB.Show(); key = true; admin = ((bool)reader["privilege"]); break; } } conn.Close(); if (key) { if (admin) { this.NavigationService.Navigate(new ManagerOptions_Page()); } else { this.NavigationService.Navigate(new FoodDBWindow_Page()); } } }
public string Notification(string CustomerId) { dbConnection dbc = new dbConnection(); string responce = ""; try { string custdetail = "select Id,FirstName +' ' + LastName as Name,Mobile from Customer where Customer.Id=" + CustomerId; DataTable dtCust = dbc.GetDataTable(custdetail); if (dtCust != null && dtCust.Rows.Count > 0) { string mobileno = dtCust.Rows[0]["Mobile"].ToString(); bool restult = SendCustomerNotificatio(mobileno, "New Product Available Now! ", "", dtCust.Rows[0]["Id"].ToString(), ""); if (restult == true) { return(responce = "Success"); } else { return(responce = "Fail"); } } else { return(responce = "Fail"); } } catch (Exception) { return(responce = "Fail"); } }
public AvalilableBalance AvailableBal(String Custid) { AvalilableBalance objredeem = new AvalilableBalance(); try { dbConnection dbc = new dbConnection(); DataTable dtWallet = dbc.GetDataTable("select CustomerId,(sum(Cr_Amount)-sum(Dr_Amount)) as avlbal,SUM(Dr_Amount)as Usedamt from Customer_Wallet_History where CustomerId=" + Custid + " group by customerid"); if (dtWallet.Rows.Count > 0) { objredeem.UsedBalance = dtWallet.Rows[0]["Usedamt"].ToString(); objredeem.AvalilableBal = dtWallet.Rows[0]["avlbal"].ToString(); objredeem.resultflag = "1"; objredeem.Message = "Success"; } else { objredeem.UsedBalance = "0.00"; objredeem.AvalilableBal = "0.00"; objredeem.resultflag = "1"; objredeem.Message = "Success"; } } catch (Exception ex) { objredeem.resultflag = "0"; objredeem.Message = "Service is not available"; } return(objredeem); }
public static void SendFranchiesEmail(string Email, string Name, string Mobile, string Address, string PinCode) { dbConnection dbCon = new dbConnection(); StringBuilder sContent = new StringBuilder(); string sEmailBody = ""; var settingData = " SELECT TOP 1 * FROM tblGeneralSettings "; DataTable dtsettingData = dbCon.GetDataTable(settingData); if (dtsettingData != null && dtsettingData.Rows.Count > 0) { sContent.Append("<tr><td> </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\">Hello,</td></tr>"); sContent.Append("<tr><td> </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\"> Inquiry For Franchisee </td></tr>"); sContent.Append("<tr><td> </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\"> Name: " + Name + "</td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\"> Mobile No: " + Mobile + " </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\"> Email: " + Email + " </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\"> Address: " + Address + ", " + PinCode + " </td></tr>"); sContent.Append("<tr><td> </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\">Thank You!!</td></tr>"); sContent.Append("<tr><td> </td></tr>"); sContent.Append("<tr><td> </td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\">Regards,</td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\">" + dtsettingData.Rows[0]["ContactPerson"].ToString() + "</td></tr>"); sContent.Append("<tr><td style=\"color:cornflowerblue;\">" + dtsettingData.Rows[0]["Designation"].ToString() + "</td></tr>"); sEmailBody = GetEmailBody("", sContent.ToString()); SendEmailForFranchies(dtsettingData.Rows[0]["EmailAddress"].ToString(), "", "Inquiry For Franchisee", sEmailBody); } }
public static string HomepageMsg(string Msg, string Key) { dbConnection dbc = new dbConnection(); try { string responce = ""; string Message = Msg; string KeyVal = Key; if (Key != "" && Key != null) { string Update = "UPDATE [dbo].[WhatsAppMsg] SET [Value] = '" + Message + "' WHERE [Key] ='" + KeyVal + "'"; int res = dbc.ExecuteQuery(Update); if (res > 0) { return(responce = "Success"); } else { return(responce = "Fail"); } } return(responce = "Fail"); } catch (Exception) { return(null); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { dbConnection dbcon = new dbConnection(); clsDataSourse db = new clsDataSourse(); startdate.Value = dbcon.getindiantime().AddDays(-3).ToString("dd-MMM-yyyy"); enddate.Value = dbcon.getindiantime().AddDays(-3).ToString("dd-MMM-yyyy"); //if (Request.QueryString["sdate"] != null) //{ // startdate.Value = Request.QueryString["sdate"]; //} //if (Request.QueryString["edate"] != null) //{ // enddate.Value = Request.QueryString["edate"]; //} DataTable dt = db.JobCardPaymentV6(false, false, false, false, false, false, startdate.Value, enddate.Value, false, false, false, false, false, false, false, false, false, false); GridView1.DataSource = dt; GridView1.DataBind(); } } catch (Exception aa) { } }
private void LoadList(string strSQL, string myString) { dbConnection ReportDB = new dbConnection(); dt = dp.getDataTable(strSQL, myString); lvUser.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow drow = dt.Rows[i]; if (drow.RowState != DataRowState.Deleted) { ListViewItem lvi = new ListViewItem(drow["userId"].ToString().Trim()); lvi.SubItems.Add(drow["fullName"].ToString().Trim()); lvi.SubItems.Add(drow["userDesignation"].ToString().Trim()); lvi.SubItems.Add(drow["userMobile"].ToString().Trim()); lvi.SubItems.Add(drow["userEmail"].ToString().Trim()); lvi.SubItems.Add(drow["userName"].ToString().Trim()); lvUser.Items.Add(lvi); } } }
public int InsertIsOffer(int bid, string img, string msg) { try { dbConnection dbc = new dbConnection(); int display = 0; if (img.Trim().Equals("")) { display = 0; } else { display = 1; } string[] ins = { img.Trim(), display.ToString(), msg.Trim(), bid.ToString() }; int i = dbc.ExecuteQueryWithParams("insert into Taaza_Offer_Notification (Imageurl,ImageDisplay,OfferStatus,OfferMessage,StartDate,Notification_Id) Values (@1,@2,1,@3,DATEADD(MINUTE, 330, GETUTCDATE()),@4 )", ins); if (i > 0) { return(1); } else { return(0); } } catch (Exception ex) { return(0); } }
protected void addOrder() { string allTitles = null; int lastID = 0; string price = getPrice(movies); string emailCustomer = c.Email; for (int i = 0; i < movies.Count; i++) { allTitles = allTitles + movies[i].Title + "; "; } dbConnection dbc = dbConnection.Instance(); queryStr = "insert into bookings (totalPrice,bookingdate,user_email) values ('" + price + "',now(),'" + emailCustomer + "');SELECT LAST_INSERT_ID();"; reader = dbc.Select(queryStr); System.Diagnostics.Debug.WriteLine("read reader"); while (reader.Read()) { lastID = reader.GetInt32(reader.GetOrdinal("LAST_INSERT_ID()")); System.Diagnostics.Debug.WriteLine("got last index id " + lastID); } dbc.close(); System.Diagnostics.Debug.WriteLine("Last id: " + lastID); System.Diagnostics.Debug.WriteLine("number in movies: " + movies.Count); for (int j = 0; j < movies.Count; j++) { insertMoviesIntoBooking(lastID, Convert.ToInt32(movies[j].Id)); System.Diagnostics.Debug.WriteLine("Last id: " + lastID); insertNewRateRow(Convert.ToInt32(movies[j].Id), emailCustomer); } }
public static string getProductExpiredOnDate(string prodid) { dbConnection dbc = new dbConnection(); string where = ""; if (prodid == "") { where = "where Product.StartDate<='" + dbc.getindiantime().ToString("dd-MMM-yyyy") + " 00:00:00' AND EndDate>='" + dbc.getindiantime().ToString("dd-MMM-yyyy") + " 23:59:59'"; } else { where = "where Product.Id=" + prodid + ""; } string date = "select CONVERT(varchar,EndDate,106) as dateprod, CONVERT(varchar,EndDate,100)as timeprod from Product " + where + " "; DataTable dt = dbc.GetDataTable(date); string edate = ""; if (dt != null && dt.Rows.Count > 0) { edate = dt.Rows[0]["dateprod"].ToString(); string timeeeee = ""; string timeee = dt.Rows[0]["timeprod"].ToString(); string[] time = timeee.Split(' '); int t1 = time.Length; timeeeee = time[t1 - 1]; edate = edate + ' ' + timeeeee; } return(edate); }
public static dbConnection Instance() { if (_instance == null) { _instance = new dbConnection(); } return(_instance); }
protected void Page_Load(object sender, EventArgs e) { dbConnection db = new dbConnection(); if (!Page.IsPostBack) { msg.Visible = false; if (Request.QueryString["id"] != null) { int id = int.Parse(Request.QueryString["id"]); string query1 = "select * from franchise where catid=" + Request.QueryString["id"]; db.da = new SqlDataAdapter(query1, db.con); db.ds = new DataSet(); db.da.Fill(db.ds, "franchise"); if (db.ds.Tables[0].Rows.Count > 0) { msg.Visible = true; msg.Text = "Cannot Delete"; } else { string query = "DELETE FROM categories WHERE id=" + Request.QueryString["id"]; SqlCommand cmd = new SqlCommand(query, db.con); db.openConnection(); cmd.ExecuteNonQuery(); msg.Visible = true; msg.Text = "Record Deleted"; } } int counter = 0; Categories cat = new Categories(); DataTable dt = cat.showCategories(); StringBuilder html = new StringBuilder(); html.Append("<table class='infotable'"); html.Append("<tr>"); html.Append("<th>S.No</th>"); html.Append("<th>Category</th>"); html.Append("<th>Image</th>"); html.Append("<th class='th'>Actions  </th>"); html.Append("</tr>"); foreach (DataRow rows in dt.Rows) { html.Append("<tr>"); html.Append("<td>" + (++counter) + "</td>"); html.Append("<td>" + rows["name"] + "</td>"); string image = ("../uploads/") + rows["image"]; html.Append("<td><img src='" + image + "' width='60' height='60' /></td>"); html.Append("<td><a style='color:black' href='editcategories.aspx?id=" + rows["id"] + "'>Edit| <a style='color:black' onClick='return confirm(\"Are you sure you want to delete this item ?\")' href='categories.aspx?id=" + rows["id"] + "'> Delete </a></td>"); html.Append("</tr>"); } html.Append("</table>"); PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() }); } }
private DataTable loadDataTable() { // create a dbConnection object and pass the database name dbConnection dbConn = new dbConnection("ChocoMambo.accdb"); // create a DataTable to store the table tblCustomers DataTable dtb = dbConn.GetDataTable("Products"); return(dtb); }
protected void insertMoviesIntoBooking(int idB, int idM) { System.Diagnostics.Debug.WriteLine("Added movieID: " + idB + " to bookingid: " + idM); dbConnection dbc = dbConnection.Instance(); queryStr = "insert into bookings_has_movies (Bookings_id,movies_id) values (" + idB + " , " + idM + " )"; dbc.insert(queryStr); dbc.close(); }
//store in varible and passs below function public static object custdetails(string Custid) { dbConnection dbc = new dbConnection(); try { string currentproduct = "select top 1 Product.id from Product where StartDate<=GETDATE()AND EndDate>=GETDATE() order by Product.id desc"; DataTable dt = dbc.GetDataTable(currentproduct); if (dt != null && dt.Rows.Count > 0) { string productidd = dt.Rows[0]["Id"].ToString(); string querydata = "select (select top 1 startdate from Product where Product.id=OrderItem.ProductId) as Productstarttime,(select top 1 startdate from Product where Product.id=OrderItem.ProductId) as Productendtime,OrderItem.Id as Orderitemid,OrderItem.ProductId as Productid,convert(varchar,[Order].CreatedOnUtc,108) as Ordertime ,convert(varchar,[Order].CreatedOnUtc,103) as Orderdate ,[Order].id as OrderId,[Order].BuyWith,ISNULL([Order].CustOfferCode,0) as CustOfferCode ,ISNULL([Order].RefferedOfferCode,0) as RefferedOfferCode from [Order] inner join OrderItem on [Order].Id=OrderItem.OrderId where CustomerId=" + Custid + " and ProductId='" + productidd + "' and [Order].IsPaymentDone=1"; DataTable dtorderdata = dbc.GetDataTable(querydata); if (dtorderdata != null && dtorderdata.Rows.Count > 0) { clsModals.custorderdetails objcustdataa = new clsModals.custorderdetails(); { objcustdataa.Response = "1"; objcustdataa.Message = "Successfully Done"; objcustdataa.Orderid = dtorderdata.Rows[0]["OrderId"].ToString(); objcustdataa.OrderItemId = dtorderdata.Rows[0]["Orderitemid"].ToString(); objcustdataa.ProductId = dtorderdata.Rows[0]["Productid"].ToString(); objcustdataa.Buywith = dtorderdata.Rows[0]["BuyWith"].ToString(); objcustdataa.OrderDate = dtorderdata.Rows[0]["Orderdate"].ToString(); objcustdataa.OrderTime = dtorderdata.Rows[0]["Ordertime"].ToString(); objcustdataa.Custoffercode = dtorderdata.Rows[0]["CustOfferCode"].ToString(); objcustdataa.ReferCode = dtorderdata.Rows[0]["RefferedOfferCode"].ToString(); objcustdataa.ProductEnddate = dtorderdata.Rows[0]["Productendtime"].ToString(); objcustdataa.ProductStartDate = dtorderdata.Rows[0]["Productstarttime"].ToString(); return(objcustdataa); } } else { clsModals.custorderdetails objcust1 = new clsModals.custorderdetails(); objcust1.Response = "0"; objcust1.Message = "No Data Found"; } } clsModals.custorderdetails objcust = new clsModals.custorderdetails(); objcust.Response = "0"; objcust.Message = "No Data Found"; } catch (Exception ee) { } return(""); }
public OrderPage_Page() { InitializeComponent(); List <Food> categories = new List <Food>(); dbConnection conn = new dbConnection(); itemCart.ItemsSource = items; categories.Add(new Food() { SubCtgr = Sub_Category.Drink }); categories.Add(new Food() { SubCtgr = Sub_Category.Appetizer }); categories.Add(new Food() { SubCtgr = Sub_Category.Main }); categories.Add(new Food() { SubCtgr = Sub_Category.Dessert }); SQLiteDataReader reader = conn.ViewTable("Food"); while (reader.Read()) { foods.Add(new Food() { Name = ((string)reader["name"]), Price = ((double)reader["price"]), Description = ((string)reader["desc"]), Img = ((string)reader["img"]), SubCtgr = categories[int.Parse(reader["subctgr"].ToString())].SubCtgr }); } this.totalTBox.Text = total.ToString(); this.taxTBox.Text = string.Format("{0:F2}", total * tax); this.subtotalTBox.Text = string.Format("{0:F2}", (total + Double.Parse(taxTBox.Text))); foreach (Food f in foods) { ChangeMenu(f); } conn.Close(); }