public DataTable PopulateFiscalYear(ComLogin objLogin) { Authentication(); LoginDAL objDal = new LoginDAL(); return(objDal.PopulateFiscalYear(objLogin)); }
public int ChangePassword(ComLogin objLogin) { Authentication(); LoginDAL objDal = new LoginDAL(); return(objDal.ChangePassword(objLogin)); }
private void PopulateFiscalYear() { objComLogin = new ComLogin(); objComLogin.Lang = Session["LanguageSetting"].ToString(); objWebService = new LoginService(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationLogin(); dtFiscalYear = objWebService.PopulateFiscalYear(objComLogin); if (dtFiscalYear != null && dtFiscalYear.Rows.Count > 0) { ddlBaseYear.DataSource = dtFiscalYear; ddlBaseYear.DataTextField = "FISCAL_YEAR"; ddlBaseYear.DataValueField = "FISCAL_YEAR_ID"; ddlBaseYear.DataBind(); ddlBaseYear.Items.Insert(0, "-- आ.व. छान्नुहोस्--"); ddlFirstYear.DataSource = dtFiscalYear; ddlFirstYear.DataTextField = "FISCAL_YEAR"; ddlFirstYear.DataValueField = "FISCAL_YEAR_ID"; ddlFirstYear.DataBind(); ddlFirstYear.Items.Insert(0, "-- आ.व. छान्नुहोस्--"); ddlSecondYear.DataSource = dtFiscalYear; ddlSecondYear.DataTextField = "FISCAL_YEAR"; ddlSecondYear.DataValueField = "FISCAL_YEAR_ID"; ddlSecondYear.DataBind(); ddlSecondYear.Items.Insert(0, "-- आ.व. छान्नुहोस्--"); ddlThirdYear.DataSource = dtFiscalYear; ddlThirdYear.DataTextField = "FISCAL_YEAR"; ddlThirdYear.DataValueField = "FISCAL_YEAR_ID"; ddlThirdYear.DataBind(); ddlThirdYear.Items.Insert(0, "-- आ.व. छान्नुहोस्--"); } }
public DataTable CheckUserExistence(ComLogin objLogin) { Authentication(); LoginDAL objDal = new LoginDAL(); return(objDal.CheckUserExistence(objLogin)); }
protected void rptParamarshaSankhya_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { DataTable dtFiscalYear = null; DropDownList dll = (DropDownList)e.Item.FindControl("ddlAaba"); ComLogin objComLogin = new ComLogin(); objComLogin.Lang = Session["LanguageSetting"].ToString(); LoginService objWebService = new LoginService(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationLogin(); dtFiscalYear = objWebService.PopulateFiscalYear(objComLogin); if (dtFiscalYear != null && dtFiscalYear.Rows.Count > 0) { dll.DataSource = dtFiscalYear; dll.DataTextField = "FISCAL_YEAR"; dll.DataValueField = "FISCAL_YEAR_ID"; dll.DataBind(); dll.Items.Insert(0, "-- आ.व. छान्नुहोस्--"); } DropDownList ddlFiscalYear = new DropDownList(); ddlFiscalYear = (DropDownList)e.Item.FindControl("ddlAaba"); ddlFiscalYear.SelectedValue = dtAPS.Rows[e.Item.ItemIndex]["FISCAL_YEAR_ID"].ToString(); } }
protected void btnChangePassword_Click(object sender, EventArgs e) { objComLogin = new ComLogin(); int i = 0; if (txtOldPassword.Text == Session["password"].ToString()) { if (txtNewPassword.Text == txtConfirmNewPassword.Text) { objComLogin.NewPassword = txtNewPassword.Text; objComLogin.UserId = Session["user_id"].ToInt32(); objWebService = new LoginService(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationLogin(); i = objWebService.ChangePassword(objComLogin); if (i > 0) { Session["password"] = txtNewPassword.Text; Response.Write("<script>alert('पासवर्ड परिवर्तन सफल भएको छ।')</script>"); Response.Redirect(Constants.ConstantAppPath + "/Home.aspx"); } } else { Response.Write( "<script>alert('नयाँ पासवर्ड मिलेन।')</script>"); } } else { Response.Write("<script>alert('पुरानो पासवर्ड मिलेन।')</script>"); } }
private void InitLoginList() { List <string> _li = new List <string>(); _li.Add(ERP.Resource.Languages.ResourceManager.GetString("ComLogin1")); _li.Add(ERP.Resource.Languages.ResourceManager.GetString("ComLogin2")); LoginList = ComLogin.LoginList(_li); this.LoginIndex = 0; }
public int ChangePassword(ComLogin objLogin) { DbCommand cmd = null; cmd = db.GetStoredProcCommand("PR_CHANGE_PASSWORD"); db.AddInParameter(cmd, "v_user_id", DbType.Int32, objLogin.UserId); db.AddInParameter(cmd, "v_new_password", DbType.String, objLogin.NewPassword); int i = 0; i = db.ExecuteNonQuery(cmd); return(i); }
public DataTable PopulateFiscalYear(ComLogin objLogin) { DbCommand cmd = db.GetStoredProcCommand("PR_POPULATE_FISCAL_YEAR_DETAIL", objLogin.Lang, OracleDbType.RefCursor); DataSet ds = null; DataTable dt = null; ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } return(dt); }
public DataTable CheckUserExistence(ComLogin objLogin) { DbCommand cmd = db.GetStoredProcCommand("PR_CHECK_USER_EXISTENCE", objLogin.Username, objLogin.Password, OracleDbType.RefCursor); DataSet ds = null; DataTable dt = null; ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } return(dt); }
protected void btnSignIn_Click(object sender, EventArgs e) { DataTable dt = null; objComLogin = new ComLogin(); objComLogin.Lang = Session["LanguageSetting"].ToString(); objComLogin.Username = txtUsername.Text; objComLogin.Password = txtPassword.Text; objWebService = new LoginService(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationLogin(); dt = objWebService.CheckUserExistence(objComLogin); if (dt != null && dt.Rows.Count > 0) { Session["username"] = dt.Rows[0]["LOGIN_ID"].ToString(); Session["password"] = dt.Rows[0]["LOGIN_PASSWORD"].ToString(); Session["user_id"] = dt.Rows[0]["user_id"].ToString(); Session["office_id"] = dt.Rows[0]["office_id"].ToString(); Session["role_id"] = dt.Rows[0]["role_id"].ToString(); Session["mobile_no"] = dt.Rows[0]["mobile_no"].ToString(); Session["email_id"] = dt.Rows[0]["email_id"].ToString(); Session["type_id"] = dt.Rows[0]["TYPE_ID"].ToString(); Session["fiscal_year_id"] = ddlFiscalYear.SelectedValue.ToInt32(); Session["fiscal_name"] = ddlFiscalYear.SelectedItem.Text; Session["office_type_id"] = dt.Rows[0]["OFFICE_TYPE_ID"].ToString(); Session["office_name"] = GetOfficeName(Session["office_id"].ToInt32()); ///// ministry_id is assigned 0 for NPC user if (Session["office_id"].ToInt32() != 2)// NPC office { int pId = Session["office_id"].ToInt32(); while (pId != 2) { pId = GetMinistryIdOfUser(pId); } DataTable dtParentOfficeTable = (DataTable)Session["dtParentOfficeTable"]; int ministryId = dtParentOfficeTable.Rows[0]["OFFICE_ID"].ToInt32(); Session["ministry_id"] = ministryId; } else { Session["ministry_id"] = 0; } Response.Redirect(Constants.ConstantAppPath + "/Home.aspx"); } else { lblMsg.Text = "Error! Invalid username or password"; } }