public void InsertForm() { Guid TicketID = new Guid(Request.QueryString["TicketID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { TicketResponse t = new TicketResponse(); t.TicketResponseID = Guid.NewGuid(); t.fk_TicketID = TicketID; t.ResponseText = reResponseText.Content; t.ResponseDate = DateTime.Now; //t.fk_UserID = new Guid(HttpContext.Current.User.Identity.Name); t.fk_UserID = new Guid("ee4edaf0-aad0-4140-a9fe-8b9bcaab6bd3"); t.IsDelete = false; db.TicketResponse.Add(t); db.SaveChanges(); var m = (from u in db.Tickets where u.TicketID == TicketID select u).FirstOrDefault(); m.Status = 2; db.SaveChanges(); //SendMail(t.TicketResponseID); } }
protected void btnYes_Click(object sender, EventArgs e) { Guid DiscountID = new Guid(ViewState["DiscountID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Discounts where u.DiscountID == DiscountID select u).FirstOrDefault(); n.IsDelete = true; n.DeleteDate = DateTime.Now; db.SaveChanges(); var nn = (from a in db.Rel_Discounts_Sizes where a.fk_DiscountID == DiscountID select a).ToList(); foreach (var NItem in nn) { db.Rel_Discounts_Sizes.Remove(NItem); db.SaveChanges(); } } LoadForm(); pnlSuccess.Visible = true; }
public void UpdateForm() { Guid userid = new Guid(HttpContext.Current.User.Identity.Name); Guid DiscountID = new Guid(ViewState["DiscountID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var p = (from u in db.Discounts where u.DiscountID == DiscountID select u).FirstOrDefault(); p.DiscountPercent = Convert.ToDouble(txtPercent.Text); p.fk_UserID = userid; p.IsActive = chbActive.Checked; p.Title = txtTitle.Text; var nn = (from a in db.Rel_Discounts_Sizes where a.fk_DiscountID == DiscountID select a).ToList(); foreach (var NItem in nn) { db.Rel_Discounts_Sizes.Remove(NItem); db.SaveChanges(); } foreach (ListItem chk in chlSizes.Items) { if (chk.Selected) { int size = Convert.ToInt32(chk.Value); Rel_Discounts_Sizes RelEnter = new Rel_Discounts_Sizes(); RelEnter.Rel_Discount_SizesID = Guid.NewGuid(); RelEnter.fk_DiscountID = DiscountID; RelEnter.fk_SizeID = size; db.Rel_Discounts_Sizes.Add(RelEnter); db.SaveChanges(); } } db.SaveChanges(); } }
//protected void btnIsFinilzed_Click(object sender, EventArgs e) //{ // if (HttpContext.Current.User.Identity.IsAuthenticated) // { // Guid UserID = new Guid(HttpContext.Current.User.Identity.Name); // using (MashadCarpetEntities db = new MashadCarpetEntities()) // { // var n = (from a in db.Orders // where a.fk_UserID == UserID && a.IsFinalized == false && a.IsDelete == false // select a).FirstOrDefault(); // n.IsFinalized = true; // n.OrderDesc = txtOrderDesc.Text; // n.FinalPrice = Convert.ToDecimal(OrderInfo.returnFinalPrice(n.OrderID)); // db.SaveChanges(); // //lblTrackingCode.Text = n.CustomerOrderID; // Response.Redirect("~/FinlizingFactor.aspx?Code=" + n.CustomerOrderID); // } // pnlOrderDetails.Visible = false; // // pnlIsFinilized.Visible = true; // //SendMail(UserID); // } //} protected void btnpay_Click(object sender, EventArgs e) { if (HttpContext.Current.User.Identity.IsAuthenticated) { Guid UserID = new Guid(HttpContext.Current.User.Identity.Name); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.Orders where a.fk_UserID == UserID && a.IsFinalized == false && a.IsDelete == false select a).FirstOrDefault(); n.OrderDesc = txtOrderDesc.Text; //int finalPrice = Convert.ToInt32(n.FinalPrice); //int newProductPrice=0 ; //List<OrderDetails> orderDetails = db.OrderDetails.Where(current => current.fk_OrderID == n.OrderID && current.IsDelete==false).ToList(); //foreach(var detail in orderDetails) //{ // ProductColorSizes productColorSizes = db.ProductColorSizes.Where(current => current.IsDelete == false && current.ProductColorSizeID == detail.fk_ProductColorSizeID).FirstOrDefault(); // newProductPrice = newProductPrice + (Convert.ToInt32(productColorSizes.ProductPrice)*detail.Count.Value); //} //if(finalPrice!=newProductPrice) //{ // n.FinalPrice = newProductPrice; //} db.SaveChanges(); Response.Redirect("~/bank.aspx?OID=" + n.OrderID.ToString() + "&&UID=" + UserID.ToString()); } } }
protected void btnUpdateBasket_Click(object sender, EventArgs e) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { foreach (RepeaterItem item in rptOrders.Items) { HiddenField hfOrderDetailID = (HiddenField)item.FindControl("hfOrderDetailID"); TextBox txtCount = (TextBox)item.FindControl("txtCount"); Guid OrderDetailID = new Guid(hfOrderDetailID.Value); var n = (from a in db.OrderDetails where a.OrderDetailID == OrderDetailID select a).FirstOrDefault(); n.Count = Convert.ToInt32(txtCount.Text); var m = (from u in db.Orders where u.OrderID == n.fk_OrderID select u).FirstOrDefault(); m.OrderDesc = txtOrderDesc.Text; } db.SaveChanges(); RptOrdersBind(); } }
public void InsertForm() { string new_filename = string.Empty; Guid ID = new Guid(ViewState["ID"].ToString()); if (fuImage.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename); fuImage.PostedFile.SaveAs(new_filepath); ViewState["GImage"] = new_filename; } string new_filename_Slider = string.Empty; if (fuImage_Slider.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage_Slider.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename); fuImage_Slider.PostedFile.SaveAs(new_filepath); ViewState["GImage_Slider"] = new_filename; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { ProductGroup pg = new ProductGroup(); pg.ProductGroupID = Guid.NewGuid(); pg.ProductGroupTitle = txtTitle.Text; pg.ProductGroupName = txtName.Text; pg.ProductGroupImage = new_filename; pg.imgSliderImage = new_filename_Slider; pg.ProductGroupDesc = reDesc.Content; pg.IsDelete = false; pg.EN_ProductGroupTitle = txtEN_Title.Text; pg.EN_ProductGroupDesc = reEN_Desc.Content; pg.fk_ProductGroupID = ID; pg.Rus_ProductGroupDesc = reRus_Desc.Content; pg.Rus_ProductGroupTitle = txtRus_Title.Text; pg.China_ProductGroupDesc = reChina_Desc.Content; pg.China_ProductGroupTitle = txtChina_Title.Text; // if (ddlProductGroups.SelectedValue != "-1") // pg.fk_ProductGroupID = new Guid(ddlProductGroups.SelectedValue); db.ProductGroup.Add(pg); db.SaveChanges(); } }
protected void btnRegister_Click(object sender, EventArgs e) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { if (HttpContext.Current.User.Identity.IsAuthenticated) { Guid UserID = new Guid(HttpContext.Current.User.Identity.Name); var u = (from i in db.Users where i.UserID == UserID select i).FirstOrDefault(); u.UserName = txtUserName.Text; u.UserFamily = txtFamily.Text; u.Address1 = txtAddress1.Text; u.Address2 = txtAddress2.Text; u.CityID = int.Parse(ddlCity.SelectedValue.ToString()); u.ProvinceID = int.Parse(ddlProvince.SelectedValue.ToString()); u.PostalCode = txtPostalCode.Text; u.Phone = txtPhone.Text; u.Mobile = txtMobile.Text; u.Email = txtEmail.Text; //u.Password = txtPass.Text; db.SaveChanges(); } } }
public void Update() { Guid UserID = new Guid(ViewState["UserID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var u = (from n in db.Users where n.UserID == UserID select n).FirstOrDefault(); if (u.fk_RoleID == 2) { u.Password = txtpass.Text; } u.UserName = txtFirstName.Text; u.Email = txtEmail.Text; u.Phone = txtPhone.Text; u.Address1 = txtAddress1.Text; u.fk_RoleID = Convert.ToInt32(ddlRoles.SelectedValue); u.Address2 = txtAddress2.Text; u.CityID = int.Parse(ddlCity.SelectedValue); u.ProvinceID = int.Parse(ddlProvince.SelectedValue); u.PostalCode = txtPostalCode.Text; u.Mobile = txtMobile.Text; u.UserFamily = txtFamily.Text; db.SaveChanges(); } }
protected void btnSave_Click(object sender, EventArgs e) { Guid UserID = new Guid(HttpContext.Current.User.Identity.Name); //Guid UserID = new Guid("ee4edaf0-aad0-4140-a9fe-8b9bcaab6bd3"); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var u = (from n in db.Users where n.UserID == UserID select n).FirstOrDefault(); u.UserName = txtFirstName.Text; u.Email = txtEmail.Text; u.Phone = txtPhone.Text; u.Password = txtpass.Text; u.Address1 = txtAddress1.Text; u.Address2 = txtAddress2.Text; u.CityID = int.Parse(ddlCity.SelectedValue); u.ProvinceID = int.Parse(ddlProvince.SelectedValue); u.PostalCode = txtPostalCode.Text; u.Mobile = txtMobile.Text; u.UserFamily = txtFamily.Text; db.SaveChanges(); } LoadForm(); }
protected void Button1_Click(object sender, EventArgs e) { ExcelPackage package = new ExcelPackage(FileUpload1.FileContent); DataTable datasource = package.ToDataTable(); // List<string> newproList = new List<string>(); foreach (DataRow dr in datasource.Rows) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { string city = dr["شهر"].ToString(); string address = dr["آدرس"].ToString(); string phone = dr["تلفن"].ToString(); Stores sss = new Stores(); sss.StoreID = Guid.NewGuid(); sss.StorePhone = phone; sss.StoreAddress = address; sss.IsDelete = false; sss.StoreCity = city; sss.IsStore = true; db.Stores.Add(sss); db.SaveChanges(); } } }
public void Insert() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { Users u = new Users(); u.UserID = Guid.NewGuid(); u.UserName = txtFirstName.Text; u.Email = txtEmail.Text; u.Phone = txtPhone.Text; u.RegisterDate = DateTime.Now; u.Password = txtpass.Text; u.fk_RoleID = Convert.ToInt32(ddlRoles.SelectedValue); u.RegisterIP = Request.UserHostAddress; u.Address1 = txtAddress1.Text; u.Address2 = txtAddress2.Text; u.CityID = int.Parse(ddlCity.SelectedValue); u.ProvinceID = int.Parse(ddlProvince.SelectedValue); u.PostalCode = txtPostalCode.Text; u.Mobile = txtMobile.Text; u.IsDelete = false; u.UserFamily = txtFamily.Text; db.Users.Add(u); db.SaveChanges(); } }
protected void btnSend_Click(object sender, EventArgs e) { if (HttpContext.Current.User.Identity.IsAuthenticated) { Guid UserID = new Guid(HttpContext.Current.User.Identity.Name.ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { Tickets t = new Tickets(); t.TicketID = Guid.NewGuid(); t.fk_UserID = UserID; t.TicketSubject = txtTicketSubject.Text; t.TicketMessage = txtTicketMessage.Text; t.TicketDate = DateTime.Now; t.IsDelete = false; t.IsValid = false; t.Status = 1; db.Tickets.Add(t); db.SaveChanges(); txtTicketMessage.Text = string.Empty; txtTicketSubject.Text = string.Empty; } pnlSuccess.Visible = true; } }
public void Insert_Log_LoginAttemp(Boolean IsSuccess) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { Log_LoginAttemps lmEnter = new Log_LoginAttemps(); lmEnter.IP = Request.UserHostAddress; lmEnter.VisitDate = DateTime.Now; if (Request.UrlReferrer != null) { lmEnter.RefrallPage = Request.UrlReferrer.ToString(); } else { lmEnter.RefrallPage = "ورود مستقیم"; } System.Web.HttpBrowserCapabilities browser = Request.Browser; lmEnter.Browser = browser.Type; lmEnter.OS = OSIdentify.OSName(); lmEnter.Username = txtEmail.Text; lmEnter.Password = txtPass.Text; lmEnter.IsSuccess = IsSuccess; db.Log_LoginAttemps.Add(lmEnter); db.SaveChanges(); } }
public void InserForm() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { Tickets p = new Tickets(); p.TicketID = Guid.NewGuid(); //p.fk_TicketGroupID = new Guid(ddlTicketGroup.SelectedValue); p.TicketSubject = txtSubject.Text; //p.TicketPriority = int.Parse(ddlPriority.SelectedValue); p.TicketMessage = txtMessage.Text; p.TicketDate = DateTime.Now; p.IsDelete = false; p.fk_UserID = new Guid(ddlUser.SelectedValue); if (Request.QueryString["StatusID"] != null) { int StatusID = int.Parse(Request.QueryString["StatusID"].ToString()); p.Status = Convert.ToByte(StatusID); } else { p.Status = 1; } db.Tickets.Add(p); db.SaveChanges(); } }
public void Insert() { string new_filename = string.Empty; if (fuImg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImg.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/Sliders/" + new_filename); fuImg.PostedFile.SaveAs(new_filepath); ViewState["NewImg"] = new_filename; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { Slider s = new Slider(); s.SliderTitle = txtTitle.Text; s.SliderImage = new_filename; db.Slider.Add(s); db.SaveChanges(); } }
public void InsertForm() { string new_filename = string.Empty; if (fuImg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImg.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/Blogs/" + new_filename); fuImg.PostedFile.SaveAs(new_filepath); ViewState["NewImg"] = new_filename; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { Links p = new Links(); p.id = Guid.NewGuid(); p.IsDelete = false; p.title = txtTitle.Text; p.LinkAddres = txtLink.Text; p.imgFile = ViewState["NewImg"].ToString(); p.title_En = txtEN_Title.Text; p.title_Ru = txtRus_Title.Text; p.title_Ch = txtChina_Title.Text; db.Links.Add(p); db.SaveChanges(); } }
public void UpdateForm() { string new_filename = string.Empty; if (fuImg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImg.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/Blogs/" + new_filename); fuImg.PostedFile.SaveAs(new_filepath); ViewState["NewImg"] = new_filename; } Guid id = new Guid(ViewState["id"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var p = (from u in db.Links where u.id == id select u).FirstOrDefault(); p.title = txtTitle.Text; p.LinkAddres = txtLink.Text; p.imgFile = ViewState["NewImg"].ToString(); p.title_En = txtEN_Title.Text; p.title_Ru = txtRus_Title.Text; p.title_Ch = txtChina_Title.Text; db.SaveChanges(); } }
public void Update() { Guid id = new Guid(ViewState["StoreID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Stores where u.StoreID == id select u).FirstOrDefault(); // n.StoreName = txtName.Text; n.StorePhone = txtPhone.Text; n.StoreCity = txtCity.Text; n.StoreAddress = txtAddress.Text; // n.Prov = txtPov.Text; // n.StoreDesc = txtDesc.Text; db.SaveChanges(); Loadgrd(); mvStores.SetActiveView(vwlist); } }
// public Nullable<Boolean> ReturnThumb() // { // if (ddlThumbImg.SelectedValue == "0") // return null; // else if (ddlThumbImg.SelectedValue == "1") // return true; // else // return false; // } public void InsertForm() { Guid ProductID = new Guid(ViewState["ID"].ToString()); string new_filename = string.Empty; if (fuImg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImg.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/Products/" + new_filename); fuImg.PostedFile.SaveAs(new_filepath); ViewState["NewImg"] = new_filename; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { ProductColors p = new ProductColors(); p.ProductColorID = Guid.NewGuid(); p.IsDelete = false; p.ProductImage = new_filename; p.fk_ColorID = int.Parse(ddlColors.SelectedValue); p.fk_ProductID = ProductID; db.ProductColors.Add(p); db.SaveChanges(); } }
public void UpdateForm() { string new_filename = string.Empty; if (fuImg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImg.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/Products/" + new_filename); fuImg.PostedFile.SaveAs(new_filepath); ViewState["NewImg"] = new_filename; } Guid ID = new Guid(ViewState["ProductColorID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var p = (from u in db.ProductColors where u.ProductColorID == ID select u).FirstOrDefault(); p.ProductImage = ViewState["NewImg"].ToString(); p.fk_ColorID = int.Parse(ddlColors.SelectedValue); db.SaveChanges(); } }
protected void grdTable_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Details") { Guid ProductID = new Guid(e.CommandArgument.ToString()); ViewState["ProductID"] = ProductID; ViewState["btn"] = "Update"; DropDownBind(); FillViewEdit(ProductID); } else if (e.CommandName == "Restore") { Guid ProductID = new Guid(e.CommandArgument.ToString()); ViewState["ProductID"] = ProductID; using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Products where u.ProductID == ProductID select u).FirstOrDefault(); n.IsDelete = false; n.DeleteDate = null; db.SaveChanges(); LoadForm(); } } }
public void InsertIntoPaymentLogs(string RefID, Guid OrderID, long?SaleRefrenceID, int ResCode_Request, Nullable <int> ResCode_Payment, Nullable <int> ResCode_Verify, Nullable <int> ResCode_Settle, string ErrorrText, Boolean IsSiccess) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { PaymentLogs a = new PaymentLogs(); a.PaymentLogID = Guid.NewGuid(); a.fk_OrderID = OrderID; a.RefID = RefID; a.SaleReferenceId = SaleRefrenceID; a.ResCode_Request = ResCode_Request; a.ResCode_Payment = ResCode_Payment; a.ResCode_Settle = ResCode_Settle; a.ResCode_Verify = ResCode_Verify; a.ErrorMessage = ErrorrText; a.PaymentDate = DateTime.Now; a.PaymentIP = Request.UserHostName; a.IsSuccess = false; db.PaymentLogs.Add(a); db.SaveChanges(); } }
protected void btnSend_Click(object sender, EventArgs e) { Guid TicketID = new Guid(ViewState["TicketID"].ToString()); if (HttpContext.Current.User.Identity.IsAuthenticated) { Guid UserID = new Guid(HttpContext.Current.User.Identity.Name); using (MashadCarpetEntities db = new MashadCarpetEntities()) { TicketResponse t = new TicketResponse(); t.TicketResponseID = Guid.NewGuid(); t.fk_TicketID = TicketID; t.fk_UserID = UserID; t.ResponseText = txtAnswerText.Text; t.ResponseDate = DateTime.Now; t.IsDelete = false; db.TicketResponse.Add(t); db.SaveChanges(); } rptAnswersBind(TicketID); txtAnswerText.Text = string.Empty; } }
public List <string> ReturnPaymentLogID(Guid OrderID) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { List <string> returnList = new List <string>(); PaymentUniqeCodes puc = new PaymentUniqeCodes(); puc.fk_OrderID = OrderID; db.PaymentUniqeCodes.Add(puc); db.SaveChanges(); returnList.Add(puc.PayementUniqeCodeID.ToString()); //var m = (from a in db.Orders // where a.IsDelete == false && a.OrderID == OrderID // select a).FirstOrDefault(); Nullable <double> Price = 0; var od = (from a in db.OrderDetails where a.IsDelete == false && a.fk_OrderID == OrderID select a).ToList(); foreach (var item in od) { var n = (from a in db.ProductColorSizes where a.ProductColorSizeID == item.fk_ProductColorSizeID && a.IsDelete == false select a).FirstOrDefault(); Price = Price + Convert.ToDouble(n.ProductPrice) * item.Count; } returnList.Add(Price.ToString()); return(returnList); } }
public void Update() { string new_filename = string.Empty; if (fuImg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImg.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/Sliders/" + new_filename); fuImg.PostedFile.SaveAs(new_filepath); ViewState["NewImg"] = new_filename; } int SLiderID = int.Parse(ViewState["SliderID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Slider where u.SliderID == SLiderID select u).FirstOrDefault(); n.SliderTitle = txtTitle.Text; n.SliderImage = ViewState["NewImg"].ToString(); db.SaveChanges(); } }
public void FindRefrall(int TodayTotal) { using (MashadCarpetEntities db = new MashadCarpetEntities()) { VisitCounter c = new VisitCounter(); TodayTotal = TodayTotal + 1; c.ClientIP = Request.UserHostAddress; c.VisitDate = DateTime.Now; c.VisitCount = 1; c.TotalVisit = TodayTotal; if (Request.UrlReferrer != null) { c.RefrallPage = Request.UrlReferrer.ToString(); } else { c.RefrallPage = "ورود مستقیم"; } System.Web.HttpBrowserCapabilities browser = Request.Browser; c.Browser = browser.Type; c.OS = ReturnOS(); db.VisitCounter.Add(c); db.SaveChanges(); } }
protected void rptAnswers_ItemCommand(object source, RepeaterCommandEventArgs e) { Guid TicketResponseID = new Guid(e.CommandArgument.ToString()); ViewState["TicketResponseID"] = TicketResponseID; switch (e.CommandName) { case "DoEdit": { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.TicketResponse where u.TicketResponseID == TicketResponseID select u).FirstOrDefault(); reResponseText.Content = n.ResponseText; } mvSetting.SetActiveView(vwEdit); ViewState["btn"] = "Update"; pnlSubmitAnswer.Visible = true; break; } case "DoDelete": { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.TicketResponse where u.TicketResponseID == TicketResponseID select u).FirstOrDefault(); n.IsDelete = true; n.DeleteDate = DateTime.Now; db.SaveChanges(); } RptAnswersBind(); break; } case "Show": { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.TicketResponse join i in db.Users.AsEnumerable() on u.fk_UserID equals i.UserID where u.TicketResponseID == TicketResponseID select new { u.ResponseText, Name = i.UserName + " " + i.UserFamily, u.ResponseDate }).FirstOrDefault(); lblAnswer.Text = n.ResponseText; lblUserAnswerName.Text = n.Name; lblAnswerDate.Text = string.Format("{0:d}", n.ResponseDate); } mvSetting.SetActiveView(vwShow); break; } } }
public void UpdateForm() { Guid ProductGroupID = new Guid(ViewState["ProductGroupID"].ToString()); string new_filename = string.Empty; if (fuImage.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename); fuImage.PostedFile.SaveAs(new_filepath); ViewState["GImage"] = new_filename; } string new_filename_Slider = string.Empty; Boolean temp = false; if (fuImage_Slider.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage_Slider.PostedFile.FileName); new_filename_Slider = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename_Slider); fuImage_Slider.PostedFile.SaveAs(new_filepath); ViewState["GImage_Slider"] = new_filename_Slider; temp = true; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.ProductGroup where u.ProductGroupID == ProductGroupID select u).FirstOrDefault(); n.ProductGroupTitle = txtTitle.Text; n.ProductGroupName = txtName.Text; n.ProductGroupImage = ViewState["GImage"].ToString(); n.ProductGroupDesc = reDesc.Content; n.EN_ProductGroupTitle = txtEN_Title.Text; n.EN_ProductGroupDesc = reEN_Desc.Content; if (temp == true) { n.imgSliderImage = ViewState["GImage_Slider"].ToString(); } n.Rus_ProductGroupDesc = reRus_Desc.Content; n.Rus_ProductGroupTitle = txtRus_Title.Text; n.Priority = Convert.ToInt32(txtPrio.Text); n.China_ProductGroupDesc = reChina_Desc.Content; n.China_ProductGroupTitle = txtChina_Title.Text; n.IsAlienCulture = chkAlienPro.Checked; db.SaveChanges(); } }
public void UpdateForm() { Guid ProductGroupID = new Guid(ViewState["ProductGroupID"].ToString()); string new_filename = string.Empty; if (fuImage.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename); fuImage.PostedFile.SaveAs(new_filepath); ViewState["GImage"] = new_filename; } string new_filename_Slider = string.Empty; if (fuImage_Slider.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage_Slider.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename); fuImage_Slider.PostedFile.SaveAs(new_filepath); ViewState["GImage_Slider"] = new_filename; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.ProductGroup where u.ProductGroupID == ProductGroupID select u).FirstOrDefault(); n.ProductGroupTitle = txtTitle.Text; n.ProductGroupName = txtName.Text; n.ProductGroupImage = ViewState["GImage"].ToString(); n.imgSliderImage = ViewState["GImage_Slider"].ToString(); n.ProductGroupDesc = reDesc.Content; n.EN_ProductGroupTitle = txtEN_Title.Text; n.EN_ProductGroupDesc = reEN_Desc.Content; n.Rus_ProductGroupDesc = reRus_Desc.Content; n.Rus_ProductGroupTitle = txtRus_Title.Text; n.China_ProductGroupDesc = reChina_Desc.Content; n.China_ProductGroupTitle = txtChina_Title.Text; //n.fk_ProductGroupID = new Guid(ddlProductGroup.SelectedValue); // n.fk_ProductGroupID = new Guid(ddlProductGroups.SelectedValue); db.SaveChanges(); } }
public void InsertForm() { string new_filename = string.Empty; if (fuImage.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage.PostedFile.FileName); new_filename = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename); fuImage.PostedFile.SaveAs(new_filepath); ViewState["GImage"] = new_filename; } string new_filename_Slider = string.Empty; if (fuImage_Slider.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuImage_Slider.PostedFile.FileName); new_filename_Slider = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Uploads/ProductGroup/" + new_filename_Slider); fuImage_Slider.PostedFile.SaveAs(new_filepath); ViewState["GImage_Slider"] = new_filename_Slider; } using (MashadCarpetEntities db = new MashadCarpetEntities()) { ProductGroup pg = new ProductGroup(); pg.ProductGroupID = Guid.NewGuid(); pg.ProductGroupTitle = txtTitle.Text; pg.ProductGroupName = txtName.Text; pg.ProductGroupImage = new_filename; pg.ProductGroupDesc = reDesc.Content; pg.IsDelete = false; pg.EN_ProductGroupTitle = txtEN_Title.Text; pg.EN_ProductGroupDesc = reEN_Desc.Content; pg.imgSliderImage = new_filename_Slider; pg.Priority = Convert.ToInt32(txtPrio.Text); pg.Rus_ProductGroupDesc = reRus_Desc.Content; pg.Rus_ProductGroupTitle = txtRus_Title.Text; pg.China_ProductGroupDesc = reChina_Desc.Content; pg.China_ProductGroupTitle = txtChina_Title.Text; pg.IsAlienCulture = chkAlienPro.Checked; db.ProductGroup.Add(pg); db.SaveChanges(); } }