private void FillCustomerDeatilGrid() { try { iUserCreationClient userClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); //GvAccount.DataSource = AccountClient.GetGetCustomerDetail(profile.Personal.UserID,profile.DBConnection._constr);//UserID added by vishal old GvAccount.DataSource = userClient.GWCSearchUserList(CompanyID, DeptId, profile.DBConnection._constr); //Change by Suresh For GCC Admin Invoiceing iCompanySetupClient Cmpny = new iCompanySetupClient(); // GvAccount.DataSource = Cmpny.GetInstituteDetails(profile.DBConnection._constr); if (GvAccount.DataSource != null) { GvAccount.DataBind(); } userClient.Close(); } catch (System.Exception ex) { // Login.Profile.ErrorHandling(ex, this, "AccountSearch.aspx", "FillCustomerDeatilGrid"); } finally { } }
public void fillEngine() { ChartProperty objclsChartProperty = new ChartProperty(); iUserCreationClient UserCreationClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); str = hfCount.Value; if (ddlSite.SelectedIndex == 0) { eng = str; } else { eng = str; } string p = eng; iEngineMasterClient EngineClient = new iEngineMasterClient(); iProductMasterClient productClient = new iProductMasterClient(); iPartRequisitionClient RequsitonClient = new iPartRequisitionClient(); if (p != "") { chkEngineList.DataSource = EngineClient.GetEngineOfSite(p, profile.DBConnection._constr); chkEngineList.DataBind(); } }
public void BindAccessDelgrid(string state, long UserId) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); CustomProfile profile = CustomProfile.GetProfile(); iUserCreationClient userClient = new iUserCreationClient(); try { ds = userClient.GetUserDelegationDetail(state, UserId, profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { grdaccessdele.DataSource = ds.Tables[0]; grdaccessdele.DataBind(); } else { grdaccessdele.DataSource = null; grdaccessdele.DataBind(); } } catch (Exception ex) { Login.Profile.ErrorHandling(ex, this, "Access Delegation", "BindAccessDelgrid"); } finally { userClient.Close(); } }
public static string PMSaveChangePassword(string loginname, string currentpassword, string newpassword) { try { CustomProfile profile = CustomProfile.GetProfile(); iUserCreationClient userClient = new iUserCreationClient(); MembershipUser u = Membership.GetUser(loginname); if (u.IsLockedOut == true) { u.UnlockUser(); } if (u.ChangePassword(currentpassword, newpassword) == true) { string Email = profile.Personal.EmailID; userClient.SavePasswordDetails(profile.Personal.UserID, Email, loginname, newpassword, profile.Personal.UserName, profile.DBConnection._constr); return("Saved"); } else { return(""); } } catch (Exception ex) { return(""); } finally { } }
public void BindDepartment(long UserID, string usertype) { iUserCreationClient userClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); DataSet ds; try { if (usertype != "Super Admin") { ds = userClient.GetDepartmentDelegate(UserID, profile.DBConnection._constr); } else { ds = userClient.GetDepartmentSSuperAdmin(profile.DBConnection._constr); } ddlDepartment.DataSource = ds; ddlDepartment.DataTextField = "Territory"; ddlDepartment.DataValueField = "ID"; ddlDepartment.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlDepartment.Items.Insert(0, lst); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Access Delegation", "BindDepartment"); } finally { userClient.Close(); } }
public static string PMCheckPassword(string ConfirmPassword) { CustomProfile profile = CustomProfile.GetProfile(); iUserCreationClient userClient = new iUserCreationClient(); DataSet ds = new DataSet(); string str = ""; try { ds = userClient.CheckPasswordHistory(profile.Personal.UserID, ConfirmPassword, profile.DBConnection._constr); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["Password"].ToString() == ConfirmPassword) { str = "PasswordFound"; } } if (str == "") { string OneDayValidation = userClient.CheckOneDayValidation(profile.Personal.UserID, profile.DBConnection._constr); str = OneDayValidation; } } catch (Exception ex) {} finally { } return(str); }
public void fillProduct() { ChartProperty objclsChartProperty = new ChartProperty(); objclsChartProperty.QueryParameter = ""; iUserCreationClient UserCreationClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); string abc = hfEng.Value; str = hfCount.Value; if (ddlSite.SelectedIndex == 0) { eng = str; } else { eng = str; } string p = eng; for (int y = 0; y <= chkEngineList.Items.Count - 1; y++) { if (prd == null) { if (chkEngineList.Items[y].Selected == true) { prd = prd + chkEngineList.Items[y].Value; } } else { if (chkEngineList.Items[y].Selected == true) { prd = prd + "," + chkEngineList.Items[y].Value; } } } string q = prd; string fdt = frmdate.Date.Value.ToString("yyyy-MM-dd"); string tdt = todate.Date.Value.ToString("yyyy-MM-dd"); iEngineMasterClient EngineClient = new iEngineMasterClient(); iProductMasterClient productClient = new iProductMasterClient(); //iPartRequisitionClient RequsitonClient = new iPartRequisitionClient(); if (q != null) { chkProductLst.DataSource = productClient.GetProductofEngine(fdt, tdt, p, q, profile.DBConnection._constr); chkProductLst.DataBind(); } }
protected void QueryBind() { ChartProperty objclsChartProperty = new ChartProperty(); objclsChartProperty.ConnectionString = sqlConn.ToString(); iUserCreationClient UserCreationClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); str = hfCount.Value; if (ddlSite.SelectedIndex == 0) { sit = str; } else { sit = str; } for (int y = 0; y <= chkEngineList.Items.Count - 1; y++) { if (eng == null) { if (chkEngineList.Items[y].Selected == true) { eng = eng + chkEngineList.Items[y].Value; } } else { if (chkEngineList.Items[y].Selected == true) { eng = eng + "," + chkEngineList.Items[y].Value; } } } for (int z = 0; z <= chkProductLst.Items.Count - 1; z++) { if (prd == null) { if (chkProductLst.Items[z].Selected == true) { prd = prd + chkProductLst.Items[z].Value; } } else { if (chkProductLst.Items[z].Selected == true) { prd = prd + "," + chkProductLst.Items[z].Value; } } } string frmd = FrmDate.Date.Value.ToString("yyyy-MM-dd"); string tod = ToDate.Date.Value.ToString("yyyy-MM-dd"); }
public void FillUserType() { iUserCreationClient userClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); ddlUserType.DataSource = userClient.GetUserType(profile.DBConnection._constr); ddlUserType.DataBind(); ListItem lst = new ListItem(); lst.Text = "--Select--"; lst.Value = "0"; ddlUserType.Items.Insert(0, lst); }
public static List <contact> Getdelegate(object objReq) { iUserCreationClient userClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); List <contact> LocList = new List <contact>(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objReq; //ds = ReceivableClient.GetProdLocations(ProdCode.Trim()); long ddlDepartment = long.Parse(dictionary["ddlDepartment"].ToString()); long UsrId = long.Parse(profile.Personal.UserID.ToString()); ds = userClient.getDelegateToList(ddlDepartment, UsrId, profile.DBConnection._constr); dt = ds.Tables[0]; contact Loc = new contact(); Loc.Name = "--Select--"; Loc.Id = "0"; LocList.Add(Loc); Loc = new contact(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Loc.Id = dt.Rows[i]["ID"].ToString(); Loc.Name = dt.Rows[i]["Name"].ToString(); LocList.Add(Loc); Loc = new contact(); } } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "Access Delegation", "Getdelegate"); } finally { userClient.Close(); } return(LocList); }
public void fillSite() { string sid; iUserCreationClient UserCreationClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); sid = UserCreationClient.GetTerritoryID_FromUserId(profile.Personal.UserID, profile.DBConnection._constr); ddlSite.DataSource = UserCreationClient.GetSiteNameFromId(sid, profile.DBConnection._constr); ddlSite.DataBind(); ListItem lst1 = new ListItem(); lst1.Text = "Select All"; lst1.Value = "0"; ddlSite.Items.Insert(0, lst1); }
public static void PMSaveLocation(string selectedIds, long userid) { iUserCreationClient userClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); string ids = selectedIds.ToString(); string[] words = ids.Split(','); for (int i = 1; i < words.Length; i++) { long locationid = long.Parse(words[i]); long count = userClient.GetDuplicatlocationUser(userid, locationid, profile.DBConnection._constr); if (count <= 0) { userClient.InsertIntoUserLocation(userid, locationid, profile.DBConnection._constr); } } }
public void GetDelegationDetail(long Delegateid) { iUserCreationClient userClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); try { DataSet ds; DataTable dt; //ds = productClient.GetBOMDetailById(BOMDetailId, profile.DBConnection._constr); ds = userClient.getUserDelegateDetail(Delegateid, profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { long deptId = long.Parse(dt.Rows[0]["DeptID"].ToString()); BindDepartment(UserID, UserType); ddlDepartment.SelectedIndex = ddlDepartment.Items.IndexOf(ddlDepartment.Items.FindByValue(dt.Rows[0]["DeptID"].ToString())); getDelegateToList(deptId); if (ddlUOM.Items.Count >= 1) { ddlUOM.SelectedIndex = 0; } ddlUOM.SelectedIndex = ddlUOM.Items.IndexOf(ddlUOM.Items.FindByValue(dt.Rows[0]["DeligateTo"].ToString())); ddlUOM.SelectedItem.Value = dt.Rows[0]["DeligateTo"].ToString(); //ddlUOM.SelectedItem.Text = dt.Rows[0]["Name"].ToString(); hdndegateId.Value = Delegateid.ToString(); txtPrincipalPrice.Text = dt.Rows[0]["Remark"].ToString(); UC_Date1.Date = Convert.ToDateTime(dt.Rows[0]["FromDate"].ToString()); UC_Date2.Date = Convert.ToDateTime(dt.Rows[0]["ToDate"].ToString()); hdndeligateeditstate.Value = "Edit"; hdnnewDelegateid.Value = dt.Rows[0]["ID"].ToString(); } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Access Delegation", "GetDelegationDetail"); } finally { userClient.Close(); } }
//protected void grdaccessdele_Select(object sender, Obout.Grid.GridRecordEventArgs e) //{ // try // { // Hashtable selectedrec = (Hashtable)grdaccessdele.SelectedRecords[0]; // hdndegateId.Value = selectedrec["ID"].ToString(); // hdnnewDelegateid.Value = selectedrec["ID"].ToString(); // hdndeligateeditstate.Value = "Edit"; // GetDelegationDetail(long.Parse(hdndegateId.Value)); // //string editsession = "Edit"; // Session["hdnedit"] = "Edit"; // Session.Add("hdnnewDelegateid", hdnnewDelegateid.Value); // } // catch (Exception ex) // { // Login.Profile.ErrorHandling(ex, this, "Access Delegation", "BindAccessDelgrid"); // } // finally {} //} //protected void imgBtnEditbom_OnClick(object sender, ImageClickEventArgs e) //{ // ImageButton imgbtn = (ImageButton)sender; // hdnnewDelegateid.Value = imgbtn.ToolTip.ToString(); // hdndegateId.Value = imgbtn.ToolTip.ToString(); // hdndeligateeditstate.Value = "Edit"; // GetDelegationDetail(long.Parse(hdndegateId.Value)); // //string editsession = "Edit"; // Session["hdnedit"] = "Edit"; // Session.Add("hdnnewDelegateid", hdnnewDelegateid.Value); //} public void getDelegateToList(long DeptId) { CustomProfile profile = CustomProfile.GetProfile(); iUserCreationClient userClient = new iUserCreationClient(); long UserID = long.Parse(profile.Personal.UserID.ToString()); DataSet ds; ds = userClient.getDelegateToList(DeptId, UserID, profile.DBConnection._constr); // ds = userClient.getDelegateToListMultipleDept(hdnSelectedLocation.Value, profile.DBConnection._constr); ddlUOM.DataSource = ds; ddlUOM.DataTextField = "Name"; ddlUOM.DataValueField = "ID"; ddlUOM.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlUOM.Items.Insert(0, lst); }
public static string RemoveSku(object objReq) { string result = ""; iUserCreationClient userClient = new iUserCreationClient(); try{ CustomProfile profile = CustomProfile.GetProfile(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objReq; long Delegateid = long.Parse(dictionary["Delegateid"].ToString()); userClient.Deletedelegate(Delegateid, profile.DBConnection._constr); result = "success"; } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "Access Delegation", "RemoveSku"); } finally { userClient.Close(); } return(result); }
public static string SaveAccessDelegation(object objReq) { string result = ""; iUserCreationClient userClient = new iUserCreationClient(); try { string hiddneedit = ""; CustomProfile profile = CustomProfile.GetProfile(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objReq; long department = long.Parse(dictionary["department"].ToString()); long Delegateto = long.Parse(dictionary["Delegateto"].ToString()); string Remark = dictionary["Remark"].ToString(); string hndstate = dictionary["hndstate"].ToString(); long UserId = long.Parse(dictionary["UserId"].ToString()); DateTime FromDate = Convert.ToDateTime(dictionary["FromDate"].ToString()); DateTime ToDate = Convert.ToDateTime(dictionary["ToDate"].ToString()); // long newdelegate = long.Parse(dictionary["newDelegate"].ToString()); long DelegateId = 0; long delegatefrom = UserId; if (HttpContext.Current.Session["hdnedit"].ToString() != "" || HttpContext.Current.Session["hdnedit"].ToString() != null) { hndstate = HttpContext.Current.Session["hdnedit"].ToString(); } string hdndelegatestateedit = dictionary["hdndeligateeditstate"].ToString(); if (hndstate == "Edit") { string hdndeligateeditstate = hiddneedit.ToString(); hndstate = hdndeligateeditstate.ToString(); string delid = HttpContext.Current.Session["hdnnewDelegateid"].ToString(); DelegateId = long.Parse(delid.ToString()); HttpContext.Current.Session["hdnnewDelegateid"] = ""; HttpContext.Current.Session["hdnedit"] = ""; userClient.SaveEditUserDelegation(DelegateId, delegatefrom, FromDate, ToDate, Delegateto, Remark, hndstate, profile.Personal.UserID, DateTime.Now, department, profile.DBConnection._constr); } else { long valuecount = 0; valuecount = userClient.GetDuplicateDelegate(FromDate, ToDate, Delegateto, department, delegatefrom, profile.DBConnection._constr); if (valuecount == 0) { string hdndeligateeditstate = hiddneedit.ToString(); hndstate = hdndeligateeditstate.ToString(); hndstate = "Add"; //string delid = HttpContext.Current.Session["hdnnewDelegateid"].ToString(); // DelegateId = long.Parse(delid.ToString()); HttpContext.Current.Session["hdnnewDelegateid"] = ""; HttpContext.Current.Session["hdnedit"] = ""; userClient.SaveEditUserDelegation(DelegateId, delegatefrom, FromDate, ToDate, Delegateto, Remark, hndstate, profile.Personal.UserID, DateTime.Now, department, profile.DBConnection._constr); } else { result = "Exist"; } } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "Access Delegation", "SaveAccessDelegation"); } finally { userClient.Close(); } return(result); }
private void ChartBind() { ChartProperty objclsChartProperty = new ChartProperty(); objclsChartProperty.ConnectionString = sqlConn.ToString(); objclsChartProperty.ReportID = 48; objclsChartProperty.QueryParameter = ""; iUserCreationClient UserCreationClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); str = hfCount.Value; //if (ddlSite.SelectedIndex == 0) { sit = UserCreationClient.GetTerritoryID_FromUserId(profile.Personal.UserID, profile.DBConnection._constr); } //else { sit = Convert.ToString(ddlSite.SelectedValue); } if (ddlSite.SelectedIndex == 0) { sit = str; } else { sit = str; } for (int y = 0; y <= chkEngineList.Items.Count - 1; y++) { if (eng == null) { if (chkEngineList.Items[y].Selected == true) { eng = eng + chkEngineList.Items[y].Value; } } else { if (chkEngineList.Items[y].Selected == true) { eng = eng + "," + chkEngineList.Items[y].Value; } } } for (int z = 0; z <= chkProductLst.Items.Count - 1; z++) { if (prd == null) { if (chkProductLst.Items[z].Selected == true) { prd = prd + chkProductLst.Items[z].Value; } } else { if (chkProductLst.Items[z].Selected == true) { prd = prd + "," + chkProductLst.Items[z].Value; } } } string frmd = frmdate.Date.Value.ToString("yyyy-MM-dd"); string tod = todate.Date.Value.ToString("yyyy-MM-dd"); objclsChartProperty.QueryParameter = "declare @Snm varchar(5000);declare @Eng varchar (5000);declare @Pid varchar (5000);declare @sdt datetime;declare @edt datetime;set @Snm='" + sit + "' set @Eng='" + eng + "' set @Pid='" + prd + "' set @sdt='" + frmd + "' set @edt='" + tod + "' "; Dashboard1.BindChart(objclsChartProperty); Chart chart1 = new Chart(); chart1 = (Chart)Dashboard1.FindControl("chart1"); if (chart1.Series.Count == 0) { Dashboard1.Visible = false; } }