public ReturnClass.ReturnDataTable select_admin_info(blApprove bl)
{
string str = @"select lo.UserID, emp.Name_en, emp.state_id,emp.base_department_id, emp.NewOfficeCode, emp.district_id,lo.RollID from login lo
inner join employee_table emp on emp.emp_id=lo.LoginID
where lo.UserID=@user";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("user", bl.Userid)
};
rd = db.executeSelectQuery(str, pm);
return(rd);
}
public ReturnClass.ReturnDataTable district_code(blApprove bl)
{
ReturnClass.ReturnDataTable rt = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
string st = "select District_ID,District_Name from districts where StateCode=@statecode order by District_Name ";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("statecode", bl.State)
};
rt = db.executeSelectQuery(st, pm);
return(rt);
}
public ReturnClass.ReturnDataTable Bind_grid(blApprove bl)
{
string str = "", where = " where 1 = 1 ";
try
{
List <MySqlParameter> pm = new List <MySqlParameter>();
if (bl.State != "" && bl.State != null && bl.State != "0" && bl.State != "Select")
{
MySqlParameter da = new MySqlParameter("state", bl.State);
pm.Add(da);
where += " and ofc.StateCode= @state ";
}
if (bl.District != "0" && bl.District != null && bl.District != "" && bl.District != "Select")
{
MySqlParameter ba = new MySqlParameter("dstrict", bl.District);
pm.Add(ba);
where += " and ofc.DistrictCodeNew = @dstrict ";
}
if (bl.Base_department != "" && bl.Base_department != null && bl.Base_department != "0" && bl.Base_department != "Select")
{
MySqlParameter ca = new MySqlParameter("bs_dept", bl.Base_department);
pm.Add(ca);
where += " and ofc.BaseDeptCode = @bs_dept ";
}
if (bl.Officelvl != "0" && bl.Officelvl != null && bl.Officelvl != "" && bl.Officelvl != "Select")
{
MySqlParameter da = new MySqlParameter("ofc_lvl", bl.Officelvl);
pm.Add(da);
where += " and ofc.OfficeLevel = @ofc_lvl ";
}
if (bl.Role == "4")
{
MySqlParameter ea = new MySqlParameter("level", bl.Officelevelcode);
pm.Add(ea);
where += " and ol.OfficeLevelType=@level ";
}
if (bl.Category != "0" && bl.Category != null && bl.Category != "" && bl.Category != "Select")
{
MySqlParameter fa = new MySqlParameter("category", bl.Category);
pm.Add(fa);
where += " and ofc.OfficeCategory=@category ";
}
str = @" select ofc.NewOfficeCode , dic.District_Name_En as district, bd.dept_name as basedept, ol.OfficeLevelName as ofclvl,
ofc.OfficeName as ofice,ofc.OfficeCategory , ofc.OfficeAddress as address, ofc.ContactNo as mobile,ofc.Fax as Fax, ofc.Email as email, ofc.OfficeURL as ofc_url
from office ofc
inner join districts dic on dic.StateCode=ofc.StateCode and dic.district_id = ofc.DistrictCodeNew
inner join basedepartment bd on bd.dept_id = ofc.BaseDeptCode
inner join officecategory oc on oc.OfficeCategoryCode=ofc.OfficeCategory
inner join officelevel ol on ol.OfficeLevelCode = ofc.OfficeLevel and ol.StateCode= ofc.StateCode
and ol.BaseDeptCode=ofc.BaseDeptCode and Status='n'" + where + " order by ofc.NewOfficeCode asc";
rd = db.executeSelectQuery(str, pm.ToArray());
}
catch (Exception ex)
{
Gen_Error_Rpt.Write_Error("../dio/dl_Dio/Bind_Grid log.txt");
}
return(rd);
}
public ReturnClass.ReturnBool Update_status1(blApprove bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope transScope = new TransactionScope())
{
string query = @" SELECT * from office where NewOfficeCode=@NewOfficeCode";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NewOfficeCode", bl.Officeid)
};
rb = db.executeInsertQuery(query, pm);
if (rb.status == true)
{
string str = @"Insert into office_temp (NewOfficeCode,DistrictCodeNew,OfficeLevel,OfficeName,BaseDeptCode,
countrycode,
Statecode,Officeaddress,contactno,email,fax,Officeurl,OfficeCategory,isvalid,Ip_address,
user_os,User_browser,useragent,userid,form)
values
(@NewOfficeCode,@DistrictCodeNew,@officelevel,@OfficeName,@BaseDeptCode,@countrycode,
@Statecode,@Officeaddress,@contactno,@email,@fax,@Officeurl,@OfficeCategory,@isvalid,@Ip_address,
@user_os,@User_browser,@useragent,@userid,@form)";
MySqlParameter[] pm2 = new MySqlParameter[] {
new MySqlParameter("NewOfficeCode", bl.Officeid),
new MySqlParameter("DistrictCodeNew", bl.District),
new MySqlParameter("officelevel", bl.Officelvl),
new MySqlParameter("OfficeName", bl.Office),
new MySqlParameter("BaseDeptCode", bl.Base_department),
new MySqlParameter("countrycode", bl.Country),
new MySqlParameter("Statecode", bl.State),
new MySqlParameter("Officeaddress", bl.Address),
new MySqlParameter("contactno", bl.Contact),
new MySqlParameter("email", bl.Email),
new MySqlParameter("fax", bl.Fax),
new MySqlParameter("Officeurl", bl.Url),
new MySqlParameter("isvalid", bl.Isvalid),
new MySqlParameter("Ip_address", bl.Ipaddress),
new MySqlParameter("user_os", bl.Operating_system),
new MySqlParameter("User_browser", bl.Browser),
new MySqlParameter("useragent", bl.Useragent),
new MySqlParameter("OfficeCategory", bl.OfficeCategory),
new MySqlParameter("userid", bl.Userid),
new MySqlParameter("form", bl.Form),
};
rb = db.executeInsertQuery(str, pm2);
}
if (rb.status == true)
{
string str1 = @"update office set Status=@status where NewOfficeCode=@NewOfficeCode";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("NewOfficeCode", bl.Officeid),
new MySqlParameter("status", bl.Status)
};
rb = db.executeUpdateQuery(str1, pm1);
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
