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();
}
