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";
}
}
