public static void WMUpdRequestPartPrice(object objRequest, int ProdID) { iPartRequestClient objService = new iPartRequestClient(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objRequest; CustomProfile profile = CustomProfile.GetProfile(); string uom = objService.GetUOMName(Convert.ToInt64(dictionary["UOMID"]), profile.DBConnection._constr); POR_SP_GetPartDetail_ForRequest_Result PartRequest = new POR_SP_GetPartDetail_ForRequest_Result(); PartRequest.Sequence = Convert.ToInt64(dictionary["Sequence"]); PartRequest.RequestQty = Convert.ToDecimal(dictionary["RequestQty"]); PartRequest.UOM = uom; PartRequest.UOMID = Convert.ToInt64(dictionary["UOMID"]); PartRequest.Total = Convert.ToDecimal(dictionary["Total"]); PartRequest.Price = Convert.ToDecimal(dictionary["Price"]); // PartRequest.IsPriceChange = Convert.ToInt16(dictionary["IsPriceChange"]); decimal price = Convert.ToDecimal(dictionary["Price"]); int ISPriceChangedYN = objService.IsPriceChanged(ProdID, price, profile.DBConnection._constr); if (ISPriceChangedYN == 0) { PartRequest.IsPriceChange = 0; } else { PartRequest.IsPriceChange = 1; } objService.UpdatePartRequest_TempData12(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), PartRequest, profile.DBConnection._constr); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "PartRequestEntry.aspx", "WMUpdRequestPart"); } finally { objService.Close(); } }
protected void GetRequestHeadByRequestID() { iPartRequestClient objService = new iPartRequestClient(); try { CustomProfile profile = CustomProfile.GetProfile(); POR_SP_GetRequestByRequestIDs_Result RequestHead = new POR_SP_GetRequestByRequestIDs_Result(); RequestHead = objService.GetRequestSummayByRequestIDs(Session["PORRequestID"].ToString(), profile.DBConnection._constr).FirstOrDefault(); if (RequestHead != null) { lblRequestNo.Text = RequestHead.PRH_ID.ToString(); lblRequestNo2.Text = RequestHead.PRH_ID.ToString(); hdnRequestID.Value = RequestHead.PRH_ID.ToString(); lblRequestDate.Text = RequestHead.RequestDate.Value.ToString("dd-MMM-yyyy"); lblRequestStatus.Text = RequestHead.RequestStatus.ToString(); lblSites.Text = RequestHead.SiteName.ToString(); hdnSiteID.Value = RequestHead.SiteID.ToString(); lblRequestType.Text = RequestHead.RequestType.ToString(); lblRequestedBy.Text = RequestHead.RequestByUserName.ToString(); GetReceiptHistoryByRequestID(); } } catch { } finally { objService.Close(); } }
public static string WMSaveApproval(long RequestID, string ApprovalStatus, long APL, string ApprovalRemark, string InvoiceNo) { iPartRequestClient objService = new iPartRequestClient(); string result = ""; try { CustomProfile profile = CustomProfile.GetProfile(); if (ApprovalStatus == "3") { objService.UpdatetApprovalTransAfterApproval(APL, RequestID, 3, ApprovalRemark, profile.Personal.UserID, InvoiceNo, profile.DBConnection._constr); result = "true"; } else if (ApprovalStatus == "4") { objService.UpdatetApprovalTransAfterReject(APL, RequestID, 4, ApprovalRemark, profile.Personal.UserID, profile.DBConnection._constr); result = "true"; } else if (ApprovalStatus == "24") { objService.UpdatetApprovalTransAfterApproval(0, RequestID, 24, ApprovalRemark, profile.Personal.UserID, "0", profile.DBConnection._constr); result = "truerev"; } } catch { } finally { objService.Close(); } return(result); }
protected void FillGVRequest(string FillBy, string Invoker) { iPartRequestClient objServie = new iPartRequestClient(); try { CustomProfile profile = CustomProfile.GetProfile(); GVRequest.DataSource = null; GVRequest.DataBind(); //New Added By Suresh for GWC string UserType = profile.Personal.UserType.ToString(); //New Added By Suresh for GWC if (FillBy == "UserID") { if (Invoker == "Request") { if (UserType == "User" || UserType == "Requester" || UserType == "Requestor") { GVRequest.DataSource = objServie.GetRequestSummayOfUser(profile.Personal.UserID, profile.DBConnection._constr); } else { GVRequest.DataSource = objServie.GetRequestSummayByUserID(profile.Personal.UserID, profile.DBConnection._constr); } GVRequest.Columns[12].Visible = false; GVRequest.AllowMultiRecordSelection = true; GVRequest.AllowRecordSelection = true; } else if (Invoker == "Issue") { if (UserType == "User" || UserType == "Requester" || UserType == "Requestor") { GVRequest.DataSource = objServie.GetRequestSummayOfUserIssue(profile.Personal.UserID, profile.DBConnection._constr); } else { GVRequest.DataSource = objServie.GetRequestSummayByUserIDIssue(profile.Personal.UserID, profile.DBConnection._constr); } GVRequest.Columns[12].Visible = true; GVRequest.AllowMultiRecordSelection = true; GVRequest.AllowRecordSelection = true; } } else if (FillBy == "SiteIDs") { GVRequest.DataSource = objServie.GetRequestSummayBySiteIDs(Session["SiteIDs"].ToString(), profile.DBConnection._constr); } GVRequest.DataBind(); } catch { } finally { objServie.Close(); } }
public static List <POR_SP_GetRequestByRequestIDs_Result> WMGetRequestHead(string RequestIDs) { iPartRequestClient objService = new iPartRequestClient(); List <POR_SP_GetRequestByRequestIDs_Result> RequestHead = new List <POR_SP_GetRequestByRequestIDs_Result>(); try { CustomProfile profile = CustomProfile.GetProfile(); RequestHead = objService.GetRequestSummayByRequestIDs(RequestIDs, profile.DBConnection._constr).ToList(); } catch { } finally { objService.Close(); } return(RequestHead); }
public static decimal WMGetTotalQty() { iPartRequestClient objService = new iPartRequestClient(); decimal tot = 0; try { CustomProfile profile = CustomProfile.GetProfile(); POR_SP_GetPartDetail_ForRequest_Result PartRequest = new POR_SP_GetPartDetail_ForRequest_Result(); tot = objService.GetTotalQTYFromTempData(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), profile.DBConnection._constr); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "PartRequestEntry.aspx", "WMGetTotalQty"); } finally { objService.Close(); } return(tot); }
public static void WMRemovePartFromRequest(Int32 Sequence) { iPartRequestClient objService = new iPartRequestClient(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); CustomProfile profile = CustomProfile.GetProfile(); objService.RemovePartFromRequest_TempData(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, Sequence, profile.DBConnection._constr); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "Request Template", "WMRemovePartFromRequest"); } finally { objService.Close(); } }
protected void Grid1_OnRebind(object sender, EventArgs e) { iPartRequestClient objService = new iPartRequestClient(); try { Grid1.DataSource = null; Grid1.DataBind(); CustomProfile profile = CustomProfile.GetProfile(); HiddenField hdn = (HiddenField)UCProductSearch1.FindControl("hdnProductSearchSelectedRec"); List <POR_SP_GetPartDetail_ForRequest_Result> RequestPartList = new List <POR_SP_GetPartDetail_ForRequest_Result>(); if (hdn.Value == "") { RequestPartList = objService.GetExistingTempDataBySessionIDObjectName(Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } else if (hdn.Value != "") { RequestPartList = objService.AddPartIntoRequest_TempData(hdn.Value, Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, 0, profile.DBConnection._constr).ToList(); } ////Add by Suresh //if (hdnprodID.Value != "") //{ // RequestPartList = objService.AddPartIntoRequest_TempData(hdnprodID.Value, Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, Convert.ToInt32(ddlSites.SelectedItem.Value), profile.DBConnection._constr).ToList(); // hdnprodID.Value = ""; //} if (hdnChngDept.Value == "0x00x0") { objService.ClearTempDataFromDBNEW(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); RequestPartList = null; } hdnChngDept.Value = ""; var chngdpt = "1x1"; hdnChngDept.Value = chngdpt; Grid1.DataSource = RequestPartList; Grid1.DataBind(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Request Template", "Grid1_OnRebind"); } finally { objService.Close(); } }
protected void Grid1_RowCommand(object sender, Obout.Grid.GridRowEventArgs e) { iPartRequestClient objService = new iPartRequestClient(); CustomProfile profile = CustomProfile.GetProfile(); try { Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[6] as Obout.Grid.GridDataControlFieldCell; DropDownList ddl = cell.FindControl("ddlUOM") as DropDownList; ddl.Attributes.Add("onchange", "javascript:GetIndex('" + ddl.SelectedIndex + "'," + e.Row.RowIndex + ")"); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Request Template", "Grid1_RowCommand"); } finally { objService.Close(); } }
public static void WMUpdateRequestQty(object objRequest) { iPartRequestClient objService = new iPartRequestClient(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objRequest; CustomProfile profile = CustomProfile.GetProfile(); POR_SP_GetPartDetail_ForRequest_Result PartRequest = new POR_SP_GetPartDetail_ForRequest_Result(); PartRequest.Sequence = Convert.ToInt64(dictionary["Sequence"]); PartRequest.RequestQty = Convert.ToDecimal(dictionary["RequestQty"]); objService.UpdatePartRequest_TempData(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), PartRequest, profile.DBConnection._constr); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "Request Template", "WMUpdateRequestQty"); } finally { objService.Close(); } }
protected void Grid1_OnRowDataBound(object sender, Obout.Grid.GridRowEventArgs e) { iPartRequestClient objService = new iPartRequestClient(); CustomProfile profile = CustomProfile.GetProfile(); try { if (e.Row.RowType == Obout.Grid.GridRowType.DataRow) { //Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[6] as Obout.Grid.GridDataControlFieldCell; //Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[7] as Obout.Grid.GridDataControlFieldCell; Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[8] as Obout.Grid.GridDataControlFieldCell; DropDownList ddl = cell.FindControl("ddlUOM") as DropDownList; HiddenField hdnUOM = cell.FindControl("hdnMyUOM") as HiddenField; //Label rowQtySpn = e.Row.Cells[9].FindControl("rowQtyTotal") as Label; Label rowQtySpn = e.Row.Cells[10].FindControl("rowQtyTotal") as Label; //TextBox txtUsrQty = e.Row.Cells[6].FindControl("txtUsrQty") as TextBox; TextBox txtUsrQty = e.Row.Cells[7].FindControl("txtUsrQty") as TextBox; int ProdID = Convert.ToInt32(e.Row.Cells[0].Text); decimal moq = Convert.ToDecimal(e.Row.Cells[6].Text); TextBox txtUsrPrice = e.Row.Cells[11].FindControl("txtUsrPrice") as TextBox; Label rowPriceTotal = e.Row.Cells[12].FindControl("rowPriceTotal") as Label; DataSet dsUOM = new DataSet(); dsUOM = objService.GetUOMofSelectedProduct(ProdID, profile.DBConnection._constr); ddl.DataSource = dsUOM; ddl.DataTextField = "Description"; ddl.DataValueField = "UMOGroup"; ddl.DataBind(); decimal SelectedQty = 0, SelectedUOM = 0; decimal Price = decimal.Parse(txtUsrPrice.Text.ToString()); //ddl.SelectedValue = e.Row.Cells[6].Text; if (hdnTemplateID.Value != "") { long TemplID = Convert.ToInt64(hdnTemplateID.Value); string selectedUom = objService.GetSelectedUomTemplate(TemplID, ProdID, profile.DBConnection._constr); ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByValue(selectedUom.ToString())); rowQtySpn.Text = txtUsrQty.Text; rowPriceTotal.Text = e.Row.Cells[12].Text; } else { ddl.SelectedIndex = 2; SelectedQty = decimal.Parse(dsUOM.Tables[0].Rows[2]["Quantity"].ToString()); SelectedUOM = decimal.Parse(dsUOM.Tables[0].Rows[2]["UOMID"].ToString()); decimal rowQty = decimal.Parse(txtUsrQty.Text.ToString()); decimal UsrQty = SelectedQty * rowQty; hdnSelectedQty.Value = SelectedQty.ToString(); rowQtySpn.Text = UsrQty.ToString(); } ddl.Attributes.Add("onchange", "javascript:GetIndex(this,'" + hdnUOM.ClientID.ToString() + "','" + rowQtySpn.ClientID.ToString() + "','" + txtUsrQty.ClientID.ToString() + "'," + e.Row.RowIndex + "," + Price + ",'" + rowPriceTotal.ClientID.ToString() + "'," + moq + ")"); txtUsrQty.Attributes.Add("onblur", "javascript:GetIndexQty(this," + SelectedQty + "," + SelectedUOM + ",'" + rowQtySpn.ClientID.ToString() + "','" + txtUsrQty.ClientID.ToString() + "'," + e.Row.RowIndex + "," + Price + ",'" + rowPriceTotal.ClientID.ToString() + "'," + moq + ")"); txtUsrPrice.Attributes.Add("onblur", "javascript:GetChangedPrice(this," + SelectedQty + "," + SelectedUOM + ",'" + rowQtySpn.ClientID.ToString() + "','" + txtUsrQty.ClientID.ToString() + "'," + e.Row.RowIndex + ",'" + rowPriceTotal.ClientID.ToString() + "'," + ProdID + ")"); //} } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Request Template", "Grid1_OnRowDataBound"); } finally { objService.Close(); } }
protected void GetTemplateDetails() { iPartRequestClient objService = new iPartRequestClient(); mRequestTemplateHead ReqTmpHead = new mRequestTemplateHead(); try { CustomProfile profile = CustomProfile.GetProfile(); ReqTmpHead = objService.GetTemplateOrderHead(Convert.ToInt64(hdnTemplateID.Value), profile.DBConnection._constr); long SiteID = Convert.ToInt64(ReqTmpHead.Department); hdnselectedDept.Value = SiteID.ToString(); Session["DeptID"] = SiteID.ToString(); iUCCommonFilterClient objCommon = new iUCCommonFilterClient(); long CompanyID = objCommon.GetCompanyIDFromSiteID(SiteID, profile.DBConnection._constr); txtTitle.Text = ReqTmpHead.TemplateTitle.ToString(); ddlAccessType.SelectedValue = ReqTmpHead.Accesstype.ToString(); //ddlCompany.SelectedIndex = ddlCompany.Items.IndexOf(ddlCompany.Items.FindByValue(ReqTmpHead.Customer.ToString())); //cmp = long.Parse(ReqTmpHead.Customer.ToString()); List <mCompany> CompanyLst = new List <mCompany>(); string UserType = profile.Personal.UserType.ToString(); long UID = profile.Personal.UserID; if (UserType == "Admin") { // CompanyLst = objService.GetCompanyName(profile.DBConnection._constr).ToList(); // CompanyLst = objService.GetUserCompanyName(UID, profile.DBConnection._constr).ToList(); CompanyLst = objCommon.GetUserCompanyNameNEW(UID, profile.DBConnection._constr).ToList(); } else if (UserType == "User" || UserType == "Requester And Approver" || UserType == "Requester" || profile.Personal.UserType == "Requestor" || profile.Personal.UserType == "Requestor And Approver") { CompanyLst = objCommon.GetUserCompanyName(UID, profile.DBConnection._constr).ToList(); } else { CompanyLst = objCommon.GetCompanyName(profile.DBConnection._constr).ToList(); } ddlCompany.DataSource = CompanyLst; ddlCompany.DataBind(); ddlCompany.SelectedIndex = ddlCompany.Items.IndexOf(ddlCompany.Items.FindByValue(CompanyID.ToString())); //ddlCompany.Items.IndexOf(ddlCompany.Items.FindByValue(ReqTmpHead.Customer.ToString())); cmp = CompanyID; int Cmpny = int.Parse(CompanyID.ToString()); //Convert.ToInt16(ReqTmpHead.Customer.ToString()); ddlSites.DataSource = WMGetDept(Cmpny); ddlSites.DataBind(); ddlSites.SelectedIndex = ddlSites.Items.IndexOf(ddlSites.Items.FindByValue(ReqTmpHead.Department.ToString())); dpt = long.Parse(ReqTmpHead.Department.ToString()); txtRemark.Text = ReqTmpHead.Remark.ToString(); //ddlAddress.DataSource = WMGetDeptAddress(CompanyID); //WMGetDeptAddress(SiteID); //ddlAddress.DataBind(); //ddlAddress.SelectedIndex = ddlAddress.Items.IndexOf(ddlAddress.Items.FindByValue(ReqTmpHead.Address.ToString())); //adrs = long.Parse(ReqTmpHead.Address.ToString()); //ddlContact1.DataSource = WMGetContactPersonLst(CompanyID); //WMGetContactPersonLst(SiteID); //ddlContact1.DataBind(); //ddlContact1.SelectedIndex = ddlContact1.Items.IndexOf(ddlContact1.Items.FindByValue(ReqTmpHead.Contact1.ToString())); //c1 = long.Parse(ReqTmpHead.Contact1.ToString()); ////ddlContact2.DataSource = WMGetContactPerson2Lst(Convert.ToInt64(ReqTmpHead.Department), Convert.ToInt64(ddlContact1.SelectedIndex)); //ddlContact2.DataSource = WMGetContactPerson2Lst(CompanyID, Convert.ToInt64(ddlContact1.SelectedIndex)); //ddlContact2.DataBind(); //ddlContact2.SelectedIndex = ddlContact2.Items.IndexOf(ddlContact2.Items.FindByValue(ReqTmpHead.Contact2.ToString())); //c2 = long.Parse(ReqTmpHead.Contact2.ToString()); //lblAddress.Text = ddlAddress.SelectedItem.ToString(); DataSet dsTemplatePartLst = new DataSet(); dsTemplatePartLst = objService.GetTemplatePartLstByTemplateID(Convert.ToInt64(hdnTemplateID.Value), profile.DBConnection._constr); List <POR_SP_GetPartDetail_ForRequest_Result> TemplatePartList = new List <POR_SP_GetPartDetail_ForRequest_Result>(); if (dsTemplatePartLst.Tables[0].Rows.Count > 0) { for (int i = 0; i <= dsTemplatePartLst.Tables[0].Rows.Count - 1; i++) { TemplatePartList = objService.AddPartIntoRequest_TempData(dsTemplatePartLst.Tables[0].Rows[i]["PrdID"].ToString(), Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, SiteID, profile.DBConnection._constr).ToList(); string uom = objService.GetUOMName(Convert.ToInt64(dsTemplatePartLst.Tables[0].Rows[i]["UOMID"].ToString()), profile.DBConnection._constr); POR_SP_GetPartDetail_ForRequest_Result PartRequest = new POR_SP_GetPartDetail_ForRequest_Result(); PartRequest.Sequence = i + 1; PartRequest.RequestQty = Convert.ToDecimal(dsTemplatePartLst.Tables[0].Rows[i]["Qty"].ToString()); // Convert.ToDecimal(dictionary["RequestQty"]); PartRequest.Price = Convert.ToDecimal(dsTemplatePartLst.Tables[0].Rows[i]["Price"].ToString()); PartRequest.Total = Convert.ToDecimal(dsTemplatePartLst.Tables[0].Rows[i]["Total"].ToString()); PartRequest.IsPriceChange = Convert.ToInt16(dsTemplatePartLst.Tables[0].Rows[i]["IsPriceChange"].ToString()); PartRequest.UOMID = Convert.ToInt64(dsTemplatePartLst.Tables[0].Rows[i]["UOMID"].ToString()); PartRequest.UOM = uom; objService.UpdatePartRequest_TempData12(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), PartRequest, profile.DBConnection._constr); // objService.UpdatePartRequest_TempData(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), PartRequest, profile.DBConnection._constr); TemplatePartList = objService.GetExistingTempDataBySessionIDObjectName(Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } } Grid1.DataSource = TemplatePartList; Grid1.DataBind(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Request Template", "GetTemplateDetails"); } finally { objService.Close(); } }
protected void pageSave(object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e) { iPartRequestClient objService = new iPartRequestClient(); try { CustomProfile profile = CustomProfile.GetProfile(); mRequestTemplateHead ReqTempHead = new mRequestTemplateHead(); int cnt; cnt = objService.GridRowCount(Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), profile.DBConnection._constr); if (cnt == 0) { WebMsgBox.MsgBox.Show("Add atleast one part into the Request Part List"); } else { List <POR_SP_GetPartDetail_ForRequest_Result> GetGridRowsTemplate = new List <POR_SP_GetPartDetail_ForRequest_Result>(); GetGridRowsTemplate = objService.GridRowsTemplate(Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), profile.DBConnection._constr).ToList(); //var ReqQty = GetGridRowsTemplate.Where(r => r.RequestQty == 0).ToList(); //long RQty = Convert.ToInt64(ReqQty.Count); //if (RQty >=1) //{ // ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "showAlert('One or more request quantity is zero','Error','#')", true); //} //else //{ if (hdnTemplateID.Value == "") { ReqTempHead.CreatedBy = profile.Personal.UserID; ReqTempHead.CreatedDate = DateTime.Now; } else { ReqTempHead = objService.GetTemplateOrderHead(Convert.ToInt64(hdnTemplateID.Value), profile.DBConnection._constr); ReqTempHead.CreatedBy = ReqTempHead.CreatedBy; ReqTempHead.CreatedDate = ReqTempHead.CreatedDate; ReqTempHead.ModifiedBy = profile.Personal.UserID; ReqTempHead.ModifiedDate = DateTime.Now; ReqTempHead.ID = Convert.ToInt64(hdnTemplateID.Value); } ReqTempHead.TemplateTitle = txtTitle.Text; ReqTempHead.Accesstype = ddlAccessType.SelectedValue.ToString(); if (hdnselectedDept.Value == "") { ReqTempHead.Department = dpt; } else { ReqTempHead.Department = Convert.ToInt64(hdnselectedDept.Value); } if (hdnselectedCompany.Value == "") { ReqTempHead.Customer = cmp; } else { ReqTempHead.Customer = Convert.ToInt64(hdnselectedCompany.Value); } ReqTempHead.Active = "Yes"; ReqTempHead.Remark = txtRemark.Text; if (hdnSelAddress.Value == "") { ReqTempHead.Address = adrs; } else { ReqTempHead.Address = Convert.ToInt64(hdnSelAddress.Value); } if (hdnselectedCont1.Value == "") { ReqTempHead.Contact1 = c1; } else { ReqTempHead.Contact1 = Convert.ToInt64(hdnselectedCont1.Value); } if (hdnselectedCont2.Value == "") { ReqTempHead.Contact2 = c2; } else { ReqTempHead.Contact2 = Convert.ToInt64(hdnselectedCont2.Value); } long RequestTemplateID = objService.InsertIntomRequestTemplateHead(ReqTempHead, profile.DBConnection._constr); if (RequestTemplateID > 0) { objService.FinalSavemRequestTemplateDetailTemplate(HttpContext.Current.Session.SessionID, ObjectName, RequestTemplateID, profile.Personal.UserID.ToString(), profile.DBConnection._constr); WebMsgBox.MsgBox.Show("Template Saved Successfully"); clearfields(); //tbTemplateLst.Visible = true; //tbTemplateDetail.Visible = false; //tabContainerReqTemplate.ActiveTabIndex = 0; //GetTemplateList(); //Response.Redirect("../PowerOnRent/RequestTemplate.aspx"); } //} } //} } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Request Template", "pageSave"); } finally { objService.Close(); } }
protected void DisplayRequestData() { iPartRequestClient objService = new iPartRequestClient(); iPartIssueClient objServiceIssue = new iPartIssueClient(); POR_SP_GetRequestByRequestIDs_Result RequestHead = new POR_SP_GetRequestByRequestIDs_Result(); try { CustomProfile profile = CustomProfile.GetProfile(); RequestHead = objService.GetRequestSummayByRequestIDs(Session["PORRequestID"].ToString(), profile.DBConnection._constr).FirstOrDefault(); hdnRequestID.Value = RequestHead.PRH_ID.ToString(); hdnSiteID.Value = RequestHead.SiteID.ToString(); lblRequestNo2.Text = RequestHead.PRH_ID.ToString(); lblRequestNo3.Text = RequestHead.PRH_ID.ToString(); lblSites.Text = RequestHead.SiteName; lblRequestStatus.Text = RequestHead.RequestStatus; lblRequestDate.Text = RequestHead.RequestDate.Value.ToString("dd-MMM-yyyy"); lblRequestType.Text = RequestHead.RequestType; lblRequestedBy.Text = RequestHead.RequestByUserName; if (WMGetIssueSummaryByRequestID() == 0) { FillGrid1ByRequestID(Convert.ToInt64(Session["PORRequestID"].ToString())); HttpContext.Current.Session["PORstate"] = "Add"; HttpContext.Current.Session["PORIssueID"] = "0"; lblIssueNo.Text = "Generate when Save"; ddlStatus.DataSource = WMFillStatus(); ddlStatus.DataBind(); if (ddlStatus.Items.Count > 1) { ddlStatus.SelectedIndex = 1; } FillUserList(1); ddlIssuedBy.SelectedIndex = ddlIssuedBy.Items.IndexOf(ddlIssuedBy.Items.FindByValue(profile.Personal.UserID.ToString())); UC_IssueDate.Date = DateTime.Now; UC_ShippingDate.Date = DateTime.Now; UC_ExpDeliveryDate.Date = DateTime.Now; } else { FillUserList(1); ddlIssuedBy.SelectedIndex = ddlIssuedBy.Items.IndexOf(ddlIssuedBy.Items.FindByValue(profile.Personal.UserID.ToString())); //add by suresh ddlStatus.DataSource = WMFillStatus(); ddlStatus.DataBind(); UC_IssueDate.Date = DateTime.Now; UC_ShippingDate.Date = DateTime.Now; UC_ExpDeliveryDate.Date = DateTime.Now; } bool AddNewAccess = false; AddNewAccess = objServiceIssue.CheckPendingIssueListToDecideAddNewAccess(RequestHead.PRH_ID, profile.DBConnection._constr); if (Toolbar1.GetUserRightsByObjectName("MaterialIssue", "", "").Add == true) { if (AddNewAccess == false) { Toolbar1.SetAddNewRight(false, "Here is no pending issue against current request", "#"); } } } catch { } finally { objService.Close(); } }
public void GetDefaultConsumptionfromRequestHead() { iPartRequestClient objRequestService = new iPartRequestClient(); iPartIssueClient objIssueService = new iPartIssueClient(); iPartReceiptClient objReceiptService = new iPartReceiptClient(); iPartConsumptionClient objConsumptionService = new iPartConsumptionClient(); try { HttpContext.Current.Session["PORConsumptionID"] = "0"; CustomProfile profile = CustomProfile.GetProfile(); if (Session["PORReceiptID"] != null) { if (Session["PORReceiptID"].ToString() != "0") { PORtGRNHead ReceiptHead = new PORtGRNHead(); PORtMINHead IssueHead = new PORtMINHead(); PORtPartRequestHead RequestHead = new PORtPartRequestHead(); ReceiptHead = objReceiptService.GetReceiptHeadByReceiptID(Convert.ToInt64(Session["PORReceiptID"].ToString()), profile.DBConnection._constr); if (ReceiptHead != null) { IssueHead = objIssueService.GetIssueHeadByIssueID(Convert.ToInt64(ReceiptHead.ReferenceID), profile.DBConnection._constr); } if (IssueHead != null) { RequestHead = objRequestService.GetRequestHeadByRequestID(Convert.ToInt64(IssueHead.PRH_ID), profile.DBConnection._constr); } if (RequestHead != null) { ddlSites.SelectedIndex = ddlSites.Items.IndexOf(ddlSites.Items.FindByValue(RequestHead.SiteID.ToString())); UC_DateConsumption.Date = DateTime.Now; ddlStatus.SelectedIndex = 1; ddlConsumedBy.DataSource = null; ddlConsumedBy.DataBind(); ddlConsumedBy.DataSource = WMFillUserList(Convert.ToInt64(RequestHead.SiteID)); ddlConsumedBy.DataBind(); ddlConsumedBy.SelectedIndex = ddlConsumedBy.Items.IndexOf(ddlConsumedBy.Items.FindByValue(profile.Personal.UserID.ToString())); ddlContainer.DataSource = null; ddlContainer.DataBind(); ddlContainer.DataSource = WMFillEnginList(Convert.ToInt64(RequestHead.SiteID)); ddlContainer.DataBind(); ddlContainer.SelectedIndex = ddlContainer.Items.IndexOf(ddlContainer.Items.FindByText(RequestHead.Container.ToString())); lblEngineModel.Text = RequestHead.EngineModel.ToString(); lblEngineSerial.Text = RequestHead.EngineSerial.ToString(); txtFailureHours.Text = RequestHead.FailureHours.ToString(); txtFailureCause.Text = RequestHead.FailureCause.ToString(); txtFailureNature.Text = RequestHead.FailureNature.ToString(); FillPartDetailByReceiptID(Convert.ToInt64(Session["PORReceiptID"].ToString())); } } } } catch { } finally { objRequestService.Close(); objIssueService.Close(); objReceiptService.Close(); } }