private void getAcademicYear(int OrgID)
{
try
{
EWA_Login objEWA = new EWA_Login();
BL_Login objBL = new BL_Login();
objEWA.OrgId = Convert.ToString(OrgID);
DataSet ds = objBL.BL_GetAcademicYear(objEWA);
if (ds.Tables[0].Rows.Count > 0)
{
CurrentAcademicYearId = ds.Tables[0].Rows[0]["AcademicYearId"].ToString();
CurrentAcademicYear = ds.Tables[0].Rows[0]["AcademicYear"].ToString();
Session["AcademicYearId"] = CurrentAcademicYearId;
Session["AcademicYear"] = CurrentAcademicYear;
}
if (OrgID == 0 && CurrentAcademicYear == "")
{
// Response.Redirect("~/CMSHome.aspx");
}
}
catch (Exception exp)
{
// GeneralErr(exp.Message.ToString());
}
}
public DataSet CheckUserLogin()
{
try
{
if (Session["OrgId"] == null)
{
Session["OrgId"] = Convert.ToInt32(DDL_SelectCollege.SelectedValue);
}
EWA_Login objEWA = new EWA_Login();
BL_Login objBL = new BL_Login();
string UserType = "0";// DDL_SelectAuthority.SelectedItem.ToString();
objEWA.UserType = UserType;
objEWA.UserName = txtUserName.Text.Trim().ToString();
objEWA.Password = txtPassword.Text.Trim().ToString();
objEWA.OrgId = Convert.ToString(DDL_SelectCollege.SelectedValue);
DataSet ds = objBL.CheckValidUser_BL(objEWA);
return(ds);
}
catch (Exception exp)
{
// GeneralErr(exp.Message.ToString());
return(null);
}
}
//Get Academic Year
#region [Get Academic Year]
public DataSet DL_GetAcademicYear(EWA_Login objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "FetchOrgAcademicYear";
prmList[2] = "@OrgID";
prmList[3] = objEWA.OrgId;
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_OrgDetails");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Get Academic Year
#region [Get Academic Year]
public DataSet BL_GetAcademicYear(EWA_Login objEWA)
{
try
{
DL_Login objDL = new DL_Login();
DataSet ds = objDL.DL_GetAcademicYear(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Insert Update Delete operaeion on User Information Table
#region [Action Performed For Login]
public int UserAction_BL(EWA_Login objEWA)
{
try
{
DL_Login objDL = new DL_Login();
int flag = objDL.UserAction_DL(objEWA);
return(flag);
}
catch (Exception exp)
{
throw exp;
}
}
//To CheckValidUser_DL
#region [Check Valid User]
public DataSet CheckValidUser_BL(EWA_Login objEWA)
{
try
{
DL_Login objDL = new DL_Login();
DataSet ds = objDL.CheckValidUser_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//To Perform Insert,Update,Delete and Search Actions On User Table
#region [Perform Actions On User]
public int UserAction_DL(EWA_Login objEWA)
{
try
{
cmd = new SqlCommand("SP_Staff", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
cmd.Parameters.AddWithValue("@UserType", objEWA.UserType);
cmd.Parameters.AddWithValue("@UserName", objEWA.UserName);
cmd.Parameters.AddWithValue("@Password", objEWA.Password);
cmd.Parameters.AddWithValue("@Role", objEWA.Role);
cmd.Parameters.AddWithValue("@UserTypeId", objEWA.UserTypeId);
cmd.Parameters.AddWithValue("@Status", objEWA.Status);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
finally
{
con.Close();
cmd.Dispose();
}
}
private DataSet CheckUserLogin()
{
DataSet ds = null;
try
{
EWA_Login objEWA = new EWA_Login();
BL_Login objBL = new BL_Login();
objEWA.UserName = txtUserName.Text.Trim().ToString();
objEWA.Password = TxtPassword.Text.Trim().ToString();
objEWA.UserType = "SuperAdmin";
ds = objBL.CheckValidUser_BL(objEWA);
}
catch (Exception exp)
{
// Response.Redirect("~/CMSHome.aspx");
//throw exp;
}
return(ds);
}
//Check Valid User
#region [Check Valid User]
public DataSet CheckValidUser_DL(EWA_Login objEWA)
{
try
{
if (objEWA.UserType == "0" || objEWA.UserType == "trustee" || objEWA.UserType == "Admin" || objEWA.UserType == "Staff" || objEWA.UserType == "Student" || objEWA.UserType == "HR" || objEWA.UserType == "Inventor" || objEWA.UserType == "Librarian")
{
prmList = new string[10];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@UserType";
prmList[3] = objEWA.UserType;
prmList[4] = "@UserName";
prmList[5] = objEWA.UserName;
prmList[6] = "@Password";
prmList[7] = objEWA.Password;
prmList[8] = "@OrgId";
prmList[9] = objEWA.OrgId;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_User");
return(dsData);
}
//else if(objEWA.UserType == "trustee" )
//{
// prmList = new string[10];
// prmList[0] = "@Action";
// prmList[1] = "CheckData";
// prmList[2] = "@UserType";
// prmList[3] = objEWA.UserType;
// prmList[4] = "@UserName";
// prmList[5] = objEWA.UserName;
// prmList[6] = "@Password";
// prmList[7] = objEWA.Password;
// prmList[8] = "@OrgId";
// prmList[9] = objEWA.OrgId;
// DataSet dsData = ObjHelper.FillControl(prmList, "SP_User");
// return dsData;
//}
else
{
prmList = new string[8];
prmList[0] = "@Action";
prmList[1] = "CheckSuperAdmin";
prmList[2] = "@UserName";
prmList[3] = objEWA.UserName;
prmList[4] = "@Password";
prmList[5] = objEWA.Password;
prmList[6] = "@UserType";
prmList[7] = objEWA.UserType;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_User");
return(dsData);
}
}
catch (Exception exp)
{
throw exp;
}
}
