protected void btnSave_Click(object sender, EventArgs e) { try { using (LinqToSqlDataContext db = new LinqToSqlDataContext()) { EM_ProductParam productParameters = new EM_ProductParam(); if (!chkAsNew.Checked) { int paramID = 0; int.TryParse(gvEMParams.SelectedValue.ToString(), out paramID); productParameters = db.EM_ProductParams.Where(x => x.EM_ProductParamID == paramID).FirstOrDefault(); if (productParameters == null) { lblErrorMsg.Text = "Record not found to update."; return; } } productParameters.EM_ProductBillingDesc = txtBillingDesc.Text; productParameters.EM_ProductBillingCommitment = Convert.ToInt32(txtBillingCommit.Text); productParameters.EM_CoreService = Convert.ToInt32(txtCoreService.Text); productParameters.EM_CoreType = Convert.ToInt32(txtCoreType.Text); productParameters.EM_InstType_Equivalent = txtInstTypeEquiv.Text; productParameters.EM_CorePrimaryCluster = Convert.ToInt32(txtPriCluster.Text); productParameters.EM_CorePrimarySubCluster = Convert.ToInt32(txtPriSubcluster.Text); productParameters.EM_CoreSecondaryCluster = Convert.ToInt32(txtSecondarycluster.Text); productParameters.EM_CoreSecondarySubCluster = Convert.ToInt32(txtSecondarySubCluster.Text); productParameters.EM_InstType_Type = Convert.ToInt32(txtTypeID.Text); string username = SiteUtility.GetUserName(); productParameters.EM_ModifiedBy = username; productParameters.EM_ModifiedOn = DateTime.Now; productParameters.Is_Deleted_Flag = chkDeleteFlag.Checked; if (chkAsNew.Checked) { productParameters.EM_CreatedBy = username; productParameters.EM_CreatedOn = DateTime.Now; db.EM_ProductParams.InsertOnSubmit(productParameters); } db.SubmitChanges(); ResetForm(); gvEMParams.DataBind(); divForm.Visible = false; } } catch (Exception exp) { lblErrorMsg.Text = exp.Message; } }
public static string GetOrderInfo(int orderid) { string orderData = ""; try { using (LinqToSqlDataContext db = new LinqToSqlDataContext()) { var orderItemsWithEM = db.USP_GetEmizonOrderItems(orderid); var data = orderItemsWithEM.Select(x => new { ProductCode = x.ProductCode, ProductDesc = x.ProductName, EMNO = string.IsNullOrEmpty(x.EM_No) ? "" : x.EM_No, InstallID = x.GPRSNo, //EMNo = "EMNo: " + x.EM_No + (string.IsNullOrEmpty(x.GPRSNo) ? "" : ", InstallID: " + x.GPRSNo), //only show installid if available as not all ARC's has this feature SerialNo = string.IsNullOrEmpty(x.EM_TCD_SerialNo) ? "N/A" : x.EM_TCD_SerialNo, EM_APIMsg = string.IsNullOrEmpty(x.EM_APIMsg) ? "" : x.EM_APIMsg, EM_APIStatusID = x.EM_APIStatusID.HasValue ? x.EM_APIStatusID.ToString() : "", OrderItemDetailId = x.OrderItemDetailId, } ).ToList(); Newtonsoft.Json.JsonSerializer jsr = new Newtonsoft.Json.JsonSerializer(); System.IO.StringWriter sw = new System.IO.StringWriter(); Newtonsoft.Json.JsonTextWriter jtw = new Newtonsoft.Json.JsonTextWriter(sw); jsr.Serialize(jtw, data.ToArray()); orderData = sw.ToString(); } } catch (Exception objException) { try { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails("OrderconfirmationEmizon", "LoadEmizonOrderData", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, SiteUtility.GetUserName()); } catch { } } return(orderData); }
private void LoadOrderData() { try { int orderid = 0; int.TryParse(hdnOrderID.Value, out orderid); using (LinqToSqlDataContext db = new LinqToSqlDataContext()) { var order = db.Orders.Where(x => x.OrderId == orderid).FirstOrDefault(); if (order != null) { lblOrderNumber.Text = "CSL" + order.OrderNo; lblOrderRef.Text = order.OrderRefNo; } //var orderItemsWithEM = db.USP_GetEmizonOrderItems(orderid); //var data = orderItemsWithEM.Select(x => // new // { // ProductCode = x.ProductCode, // ProductDesc = x.ProductName, // EMNO = "EMNo: " + x.EM_No + (string.IsNullOrEmpty(x.GPRSNo) ? "" : ", InstallID: " + x.GPRSNo), //only show installid if available as not all ARC's has this feature // SerialNo = string.IsNullOrEmpty(x.EM_TCD_SerialNo) ? "N/A" : x.EM_TCD_SerialNo, // } // ); //gvOrderItems.DataSource = data; //gvOrderItems.DataBind(); } } catch (Exception objException) { try { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadEmizonOrderData", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, SiteUtility.GetUserName()); } catch { } } }
public static int UpdateInstallID(string InstallID, string OrderItemDetailID, string OrderID) { try { using (LinqToSqlDataContext db = new LinqToSqlDataContext()) { string emizonQueuePath = ConfigurationManager.AppSettings["EmizonQueue"].ToString(); var OrderItemDetails = db.OrderItemDetails.Where(i => i.OrderItemDetailId == Convert.ToInt32(OrderItemDetailID)).SingleOrDefault(); OrderItemDetails.GPRSNo = InstallID; db.SubmitChanges(); EmizonOrderController.AddAPIRequestToQueue(emizonQueuePath, new Emizon.APIModels.MSMQTypes.QueueOrderMessage() { orderID = Convert.ToInt32(OrderID) }); return(0); } } catch (Exception objException) { try { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails("UpdateInstallID", "UpdateInstallID", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, SiteUtility.GetUserName()); return(-1); } catch { return(-1); } } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { try { Audit audit = new Audit(); string ctgCode = ""; if (!string.IsNullOrEmpty(txtctgCode.Text) && !string.IsNullOrEmpty(txtctgName.Text) && !string.IsNullOrEmpty(Txtlistorder.Text)) { int chkgprs = 0; string defaultimg = ""; string largeimg = ""; string dbdefaultimg = ""; string dblargeimg = ""; ctgCode = txtctgCode.Text.ToString(); db = new LinqToSqlDataContext(); try { //if updating category and delete all the mapped arc's and products of this category. #region existingCategory if (Session[enumSessions.CategoryId.ToString()] != null) { var CatInfo = (from cat in db.Categories where cat.CategoryId == Convert.ToInt32(Session[enumSessions.CategoryId.ToString()]) select cat).SingleOrDefault(); if (FileUpload1.HasFile) { string filenamewithoutext = System.IO.Path.GetFileNameWithoutExtension(FileUpload1.PostedFile.FileName); string ext = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName); string ff = filenamewithoutext + txtctgCode.Text.ToString() + ext; defaultimg = "../images/" + ff; FileUpload1.SaveAs(Server.MapPath(defaultimg)); dbdefaultimg = "images/" + ff; } else { dbdefaultimg = CatInfo.DefaultImage; } if (FileUpload2.HasFile) { string filenamewithoutext = System.IO.Path.GetFileNameWithoutExtension(FileUpload2.PostedFile.FileName); string ext = System.IO.Path.GetExtension(FileUpload2.PostedFile.FileName); string ff = filenamewithoutext + txtctgCode.Text.ToString() + ext; largeimg = "../images/" + ff; FileUpload2.SaveAs(Server.MapPath(largeimg)); dblargeimg = "images/" + ff; } else { dblargeimg = CatInfo.LargeImage; } if (CheckBoxgprschip.Checked == true) { chkgprs = 1; } else { chkgprs = 0; } var catg = db.CreateCategory(Convert.ToInt32(Session[enumSessions.CategoryId.ToString()].ToString()), txtctgCode.Text.ToString(), txtctgName.Text.ToString(), txtctgdesc.Text.ToString(), dbdefaultimg, dblargeimg, SiteUtility.GetUserName(), Convert.ToBoolean(chkgprs), Convert.ToInt32(Txtlistorder.Text.ToString()), chkIsDeleted.Checked, txtSalesType.Text).SingleOrDefault(); if (catg != null) { Session[enumSessions.CategoryId.ToString()] = catg.CategoryId; } if (catg.CategoryId == 0) { string script = "alertify.alert('" + ltrDuplCat.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); MaintainScrollPositionOnPostBack = false; } else { string script = "alertify.alert('Category [" + txtctgCode.Text + "] - " + txtctgName.Text + " updated successfully.');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); MaintainScrollPositionOnPostBack = false; } audit.Notes = "CategoryId: " + Convert.ToInt32(Session[enumSessions.CategoryId.ToString()].ToString()) + ", Code: " + txtctgCode.Text.ToString() + ", Name: " + txtctgName.Text.ToString() + ", Description: " + txtctgdesc.Text.ToString() + ", DefaultImg: " + dbdefaultimg + ", LargeImg: " + dblargeimg + ", Allow GPRS: " + Convert.ToBoolean(chkgprs) + ", List Order: " + Convert.ToInt32(Txtlistorder.Text.ToString()) + ", Is Deleted: " + chkIsDeleted.Checked + ", Sales Types: " + txtSalesType.Text; } #endregion #region newCategory else { string filenamewithoutext1 = System.IO.Path.GetFileNameWithoutExtension(FileUpload1.PostedFile.FileName); string ext1 = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName); string ff1 = filenamewithoutext1 + txtctgCode.Text.ToString() + ext1; string filenamewithoutext2 = System.IO.Path.GetFileNameWithoutExtension(FileUpload2.PostedFile.FileName); string ext2 = System.IO.Path.GetExtension(FileUpload2.PostedFile.FileName); string ff2 = filenamewithoutext2 + txtctgCode.Text.ToString() + ext2; defaultimg = ff1; largeimg = ff2; string defImgPath = "images/" + defaultimg; string LImgPath = "images/" + largeimg; if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("../images/" + defaultimg)); } if (FileUpload2.HasFile) { FileUpload2.SaveAs(Server.MapPath("../images/" + largeimg)); } if (CheckBoxgprschip.Checked == true) { chkgprs = 1; } else { chkgprs = 0; } var cats = db.CreateCategory(0, txtctgCode.Text.ToString().Trim(), txtctgName.Text.ToString().Trim(), txtctgdesc.Text.ToString().Trim(), defImgPath.ToString().Trim(), LImgPath.ToString().Trim(), SiteUtility.GetUserName(), Convert.ToBoolean(chkgprs), Convert.ToInt32(Txtlistorder.Text.ToString()), chkIsDeleted.Checked, txtSalesType.Text).Single(); if (cats != null) { Session[enumSessions.CategoryId.ToString()] = cats.CategoryId; } if (cats.CategoryId == 0) { string script = "alertify.alert('" + ltrDuplCat.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); MaintainScrollPositionOnPostBack = false; } else { string script = "alertify.alert('Category [" + txtctgCode.Text + "] - " + txtctgName.Text + " created successfully.');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); MaintainScrollPositionOnPostBack = false; } audit.Notes = "CategoryId: " + cats.CategoryId.ToString() + ", Code: " + txtctgCode.Text.ToString() + ", Name: " + txtctgName.Text.ToString() + ", Description: " + txtctgdesc.Text.ToString() + ", DefaultImg: " + dbdefaultimg + ", LargeImg: " + dblargeimg + ", Allow GPRS: " + Convert.ToBoolean(chkgprs) + ", List Order: " + Convert.ToInt32(Txtlistorder.Text.ToString()) + ", Is Deleted: " + chkIsDeleted.Checked + ", Sales Types: " + txtSalesType.Text; } #endregion } catch (Exception exp) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "btnSave_Click", Convert.ToString(exp.Message), Convert.ToString(exp.InnerException), Convert.ToString(exp.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, SiteUtility.GetUserName()); } //enter all the checked products of this category audit.Notes += "ProductID: "; List <Category_Product_Map> categoryProductDbRows = new List <Category_Product_Map>(); foreach (GridViewRow ctgrow in gvctg.Rows) { if (ctgrow.RowType == DataControlRowType.DataRow) { GridView innergrid = ctgrow.FindControl("gvinner") as GridView; foreach (GridViewRow prodrow in innergrid.Rows) { if (prodrow.RowType == DataControlRowType.DataRow) { CheckBox chkpro = prodrow.FindControl("chkprod") as CheckBox; Category_Product_Map cmp; if (chkpro.Checked == true) { int Prodid = int.Parse(innergrid.DataKeys[prodrow.RowIndex].Value.ToString()); cmp = new Category_Product_Map(); cmp.CategoryId = Convert.ToInt32(Session[enumSessions.CategoryId.ToString()]); cmp.ProductId = Convert.ToInt32(Prodid); var count = categoryProductDbRows.Where(x => x.CategoryId == cmp.CategoryId && x.ProductId == cmp.ProductId).Count(); if (count <= 0) { categoryProductDbRows.Add(cmp); } audit.Notes += Prodid + ", "; } } } } } db.Category_Product_Maps.InsertAllOnSubmit(categoryProductDbRows); db.SubmitChanges(); //enter all the checked Arc's of this category audit.Notes += "ARCId: "; var Checkedarc = (from ListItem item in CheckBoxARC.Items where item.Selected select item.Value).ToList(); if (Checkedarc.Any()) { ARC_Category_Map acm; int catid = Convert.ToInt32(Session[enumSessions.CategoryId.ToString()]); List <int> arcs = new List <int>(); foreach (String chkarc in Checkedarc) { if (chkarc != "Select All") { acm = new ARC_Category_Map(); acm.CategoryId = catid; acm.ARCId = Convert.ToInt32(chkarc); if (arcs.IndexOf(acm.ARCId) < 0) { db.ARC_Category_Maps.InsertOnSubmit(acm); db.SubmitChanges(); } arcs.Add(acm.ARCId); audit.Notes += chkarc + ","; } } } pnlcategorydetail.Visible = false; pnlcategorylist.Visible = true; LoadData(); } else { string script = "alertify.alert('" + ltrRequired.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } MaintainScrollPositionOnPostBack = false; audit.UserName = Session[enumSessions.User_Name.ToString()].ToString(); audit.ChangeID = Convert.ToInt32(enumAudit.Manage_Category); audit.CreatedOn = DateTime.Now; if (Request.ServerVariables["LOGON_USER"] != null) { audit.WindowsUser = Request.ServerVariables["LOGON_USER"]; } audit.IPAddress = Request.UserHostAddress; db.Audits.InsertOnSubmit(audit); db.SubmitChanges(); } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "btnSave_Click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); } } else { string script = "alertify.alert('" + ltrRequired.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); MaintainScrollPositionOnPostBack = false; } }
protected void btnSearch_Click(object sender, EventArgs e) { try { db = new LinqToSqlDataContext(); var searchbyname = (from cats in db.Categories where cats.IsDeleted == false && (cats.CategoryName.Contains(txtctgnamesrch.Text.Trim()) && cats.CategoryCode.Contains(txtctgcodesrch.Text.Trim())) select cats); if (searchbyname.Count() != 0) { gvCategories.DataSource = searchbyname; gvCategories.DataBind(); } else { LoadData(); } ClearAllInputs(); //uncheck arcs for (int i = 0; i <= CheckBoxARC.Items.Count - 1; i++) { CheckBoxARC.Items[i].Selected = false; } } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "btnSearch_Click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, SiteUtility.GetUserName()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { LoadData(); Session[enumSessions.CategoryId.ToString()] = null; } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "Page_Load", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, SiteUtility.GetUserName()); } } }