public ReturnClass.ReturnBool executeDeleteQuery(String _query, MySqlParameter [] sqlParameter, String ls)
{
ReturnClass.ReturnBool dt = new ReturnClass.ReturnBool();
try
{
string con_str1 = GetConnectionString(ls);
using (Adapter = new MySqlDataAdapter())
{
using (MySqlConnection con = new MySqlConnection(con_str1))
{
using (MySqlCommand cmd = new MySqlCommand())
{
con.Open();
cmd.Connection = con;
cmd.CommandText = _query;
cmd.Parameters.AddRange(sqlParameter);
Adapter.DeleteCommand = cmd;
cmd.ExecuteNonQuery();
dt.status = true;
}
}
}
}
catch (MySqlException exp)
{
Gen_Error_Rpt.Write_Error("executeUpdateQuery - Query: " + _query + "\n error - ", exp);
dt.status = false;
dt.message = exp.Message;
}
return(dt);
}
/// <summary>
/// Execute Update Query
/// </summary>
/// <param name="_query"></param>
/// <param name="sqlParameter"></param>
/// <returns></returns>
///
public ReturnClass.ReturnBool executeUpdateQuery(String _query)
{
ReturnClass.ReturnBool dt = new ReturnClass.ReturnBool();
try
{
using (Adapter = new MySqlDataAdapter())
{
using (MySqlConnection con = new MySqlConnection(con_str))
{
using (MySqlCommand cmd = new MySqlCommand())
{
con.Open();
cmd.Connection = con;
cmd.CommandText = _query;
Adapter.UpdateCommand = cmd;
cmd.ExecuteNonQuery();
dt.status = true;
}
}
}
}
catch (MySqlException exu)
{
Gen_Error_Rpt.Write_Error("executeUpdateQuery - Query: " + _query + "\n error - ", exu);
dt.status = false;
dt.message = exu.Message;
}
return(dt);
}
/// <summary>
/// Aim of method: The Method is used to update e-challan
/// Database Table :society_aims
/// bl layer use:bl_society_fee- (MEMORANDUM_OF_SOCIETY_From_1_Gridview3())
/// </summary>
/// <returns></returns>
public ReturnClass.ReturnBool update_echallan_status(bl_RTI_Fees reg)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
try
{
using (TransactionScope ts = new TransactionScope())
{
MySqlParameter[] pr = new MySqlParameter[]{
new MySqlParameter("RTI_provisional_no",reg.RTI_provisional_no)
};
string qrr = "UPDATE appli_parameter_complete_status SET complete_status='Y' where firm_RTI_provisional_no=@RTI_provisional_no and appli_parameter_code IN ('S12') ";
rb = db.executeUpdateQuery(qrr, pr);
if (rb.status == true)
{
ts.Complete();
rb.status = true;
}
}
}
catch (Exception Ex)
{
rb.status = false;
rb.message = Ex.Message;
}
return rb;
}
protected void submit_review_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
if (Session["CheckRefresh"] != null)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
if (Session["User_Id"] != null)
{
bl.User_id = Session["User_Id"].ToString();
}
else
{
if (Request.Cookies["User_Id"] != null)
{
Session["User_Id"] = Request.Cookies["User_Id"].Value;
bl.User_id = Request.Cookies["User_Id"].Value;
}
}
bl.Date_time = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
bl.Client_id = util.GetClientIpAddress(this.Page);
bl.Headline = txt_Heading.Text.Trim();
bl.Description = txt_review.Text.Trim();
bl.Subject_id = ddl_class.SelectedValue;
bl.Topic_id = INTSUB_ID_from();
rb = dl.Insert_topic(bl);
if (rb.status)
{
txt_Heading.Text = "";
txt_review.Text = "";
bind_topic();
bind_subject();
Utilities.MessageBox_UpdatePanel(updatepanel1, "Topic Added Successfully");
}
else
{
Utilities.MessageBox_UpdatePanel(updatepanel1, "Failed to save, Please try again");
}
}
else
{
Utilities.MessageBox_UpdatePanel(updatepanel1, "Page Refresh or Back button is now allowed");
}
}
else
{
Utilities.MessageBox_UpdatePanel(updatepanel1, "Page expired!!! Please re open this page in new window.");
}
}
catch (NullReferenceException ex)
{
Utilities.MessageBox_UpdatePanel_Redirect(updatepanel1, "Records could not be saved: Please Try Again", Request.Url.AbsoluteUri);
}
}
}
protected void btn_save_Click1(object sender, EventArgs e)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
//Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
bl.Ddl_id = Convert.ToString(ddl_id());
bl.Actionname = txt_action_name.Text;
bl.DDL_Name_Value = txtaction_id.Text;
bl.Remark = txtremark.Text;
bl.DisplayOrder = txtdisplay_order.Text;
bl.Category = "permission";
rb = dl.insertAction(bl);
if (rb.status == true)
{
txt_action_name.Text = "";
Utilities.MessageBoxShow("Action Enter Successfully");
bindgrd_Action();
}
else
{
Utilities.MessageBoxShow("Action Not Inserted");
}
}
}
//insert new action in table
public ReturnClass.ReturnBool insert_action(bl_employee_action bl1)
{
string str = @"insert into rti_action
(action_id,rti_id,officer_mapping_id,action_detail,action_date,IsUpload,IsMeeting,meeting_date,ipaddress,
dept_status,client_OS,client_browser,userAgent, RejectReason) values
(@action_id,@rti_id,@officer_mapping_id,@action_detail,@action_date,@Isupload,@IsMeeting,@meeting_date,
@ipaddress,@status,@client_os,@client_browser,@useragent, @RejectReason)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("action_id", bl1.Action_id),
new MySqlParameter("rti_id", bl1.Rti_id),
new MySqlParameter("officer_mapping_id", bl1.Office_mapping_id),
new MySqlParameter("action_detail", bl1.Action_discription),
new MySqlParameter("action_date", bl1.Action_date),
new MySqlParameter("Isupload", bl1.Is_file_upload),
new MySqlParameter("IsMeeting", bl1.IsMeeting),
new MySqlParameter("meeting_date", bl1.Meeting_date),
new MySqlParameter("ipaddress", bl1.Ipaddress),
new MySqlParameter("status", bl1.Dept_Status),
new MySqlParameter("client_os", bl1.Useros),
new MySqlParameter("client_browser", bl1.User_browser),
new MySqlParameter("useragent", bl1.Useragent),
new MySqlParameter("RejectReason", bl1.Reject),
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool Insert_empmap(bl_report bl)
{
db_maria_connection db = new db_maria_connection();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
string strQuery = @"INSERT INTO emp_office_mapping
(office_mapping_id,emp_code,office_id,designation_id,base_department_id,office_level_id,district_id_ofc,office_category,user_id,charge_type,Active,client_ip)
VALUES(@office_mapping_id,@emp_code,@office_id,@designation_id,@base_department_id,@office_level_id,@district_id_ofc,@office_category,@user_id,@charge_type,@Active,@client_ip)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("office_mapping_id", bl.Office_mapping_id),
new MySqlParameter("emp_code", bl.Emp_code),
new MySqlParameter("office_id", bl.Office_id),
new MySqlParameter("designation_id", bl.Designation_id),
new MySqlParameter("base_department_id", bl.Base_department_id),
new MySqlParameter("office_level_id", bl.Office_level_id),
new MySqlParameter("district_id_ofc", bl.District_id_ofc),
new MySqlParameter("office_category", bl.Office_category),
new MySqlParameter("user_id", bl.User_id),
new MySqlParameter("charge_type", bl.Charge_type),
new MySqlParameter("Active", bl.Active),
new MySqlParameter("client_ip", bl.Client_ip)
};
rb = db.executeInsertQuery(strQuery, pm);
return(rb);
}
public ReturnClass.ReturnBool approve_notice(Notice_Entry ne)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string qr1 = @"insert into notice_board_log select * from Notice_Board where Notice_Id=@NoticeID";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID)
};
rb = db.executeInsertQuery(qr1, pm);
if (rb.status == true)
{
string qr = " UPDATE Notice_Board SET status=@status where Notice_Id=@NoticeID ";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID),
new MySqlParameter("status", ne.status)
// new MySqlParameter("district_id",ne.district_id)
};
rb = db.executeUpdateQuery(qr, pm1);
ts.Complete();
}
}
return(rb);
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
bl.Video_id = GridView2.DataKeys[e.RowIndex].Values[0].ToString();
bl.Panjiyan_category_id = GridView2.DataKeys[e.RowIndex].Values[2].ToString();
FileInfo file = new FileInfo(Server.MapPath("~" + bl.Panjiyan_category_id));
if (file.Exists)//check file exsit or not
{
file.Delete();
rb = dl.delete_Video(bl);
if (rb.status)
{
Utilities.MessageBox_UpdatePanel(updatepanel1, "Video deleted Successfully");
this.bind_video();
}
else
{
Utilities.MessageBox_UpdatePanel(updatepanel1, "Failed to delete, Please try again");
}
}
else
{
Utilities.MessageBox_UpdatePanel(updatepanel1, "Failed to delete, Please try again");
}
}
public ReturnClass.ReturnBool insert_action(bl_RTIDataForApplicant bl1)
{
string str = @"insert into rti_data_for_applicant
(rti_data_id, rti_id, action_id, action_file_id, rti_prepared_emp, result_description, IsFileUpload, IsMeetingFix, MeetingDate,
IsAdditionalFees, FeesAmount, ClientOS, ClientIP, ClientBrowser, ClientAgent ) values
( @rti_data_id, @rti_id, @action_id, @action_file_id, @rti_prepared_emp, @result_description, @IsFileUpload, @IsMeetingFix, @MeetingDate,
@IsAdditionalFees, @FeesAmount, @client_os, @ipaddress, @client_browser,@useragent )";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("rti_data_id", bl1.RTI_data_id),
new MySqlParameter("rti_id", bl1.Rti_id),
new MySqlParameter("action_id", bl1.Action_id),
new MySqlParameter("action_file_id", bl1.RTI_fileID),
new MySqlParameter("rti_prepared_emp", bl1.Userid),
new MySqlParameter("result_description", bl1.Result_description),
new MySqlParameter("IsFileUpload", bl1.Is_file_upload),
new MySqlParameter("IsMeetingFix", bl1.IsMeeting),
new MySqlParameter("MeetingDate", bl1.Meeting_date),
new MySqlParameter("IsAdditionalFees", bl1.IsAdditionalFees),
new MySqlParameter("FeesAmount", bl1.Fees_amount),
new MySqlParameter("client_os", bl1.Useros),
new MySqlParameter("ipaddress", bl1.Ipaddress),
new MySqlParameter("client_browser", bl1.User_browser),
new MySqlParameter("useragent", bl1.Useragent)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
}//end
public ReturnClass.ReturnBool Insert_rti_status(bl_RTI_Request ur)
{
string strQuery = "INSERT INTO rti_status " +
"( rti_id, user_id, status, action_id, officer_maping_id, IPAddress, action_date, IsValid, IsNew , client_OS, useragent , client_browser)" +
" VALUES ( @rti_ID, @user_id, @status, @action_id, @officer_maping_id, @IPAddress, @action_date, @isValid, @isnew, @client_OS , @useragent, @client_browser )";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("rti_ID", ur.RTI_filed_user_id),
new MySqlParameter("user_id", ur.RTI_login_userName),
new MySqlParameter("status", ur.Rti_Status),
new MySqlParameter("action_id", ur.Action_id),
new MySqlParameter("officer_maping_id", ur.Office_mapping_id),
new MySqlParameter("IPAddress", ur.RTI_ipaddress),
new MySqlParameter("action_date", ur.Action_date),
new MySqlParameter("isValid", ur.IsValid),
new MySqlParameter("isnew", ur.IsNew),
new MySqlParameter("client_OS", ur.Client_os),
new MySqlParameter("useragent", ur.UserAgent),
new MySqlParameter("client_browser", ur.ClientBrowser)
};
ReturnClass.ReturnBool dt = null;
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return(dt);
}//end of Insert_rti_filed_user
protected void btn_submit_Click(object sender, EventArgs e)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
if (Page.IsValid)
{
Captcha1.ValidateCaptcha(txtCaptcha.Text.Trim());
if (Captcha1.UserValidated)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
bl_feedback bl = new bl_feedback();
dl_feedback dl = new dl_feedback();
bl.Feedback = txt_feedback.Text;
bl.Userid = Session["username"].ToString();
bl.Subject = ddl_subject.SelectedValue;
bl.Specify = txt_sub.Text;
rb = dl.insert_feedback(bl);
if (rb.status == true)
{
Utilities.MessageBox_UpdatePanel_Redirect(udp, "We Recieve Your FeedBack This Is Valuable For Us, We Will Response You Soon Thank You.", "../user/user_detail.aspx");
}
else
{
Utilities.MessageBox_UpdatePanel(udp, "Your Feed Back Is Not Registered");
}
}
else
{
Utilities.MessageBox_UpdatePanel(udp, "Please Enter Right Security code");
}
}
}
}
} // End
//ReturnClass.ReturnDataTable GetRtiStatus_detail(bl_RTI_Request bl)
//{
// ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
// db_maria_connection db = new db_maria_connection();
// string str = "select rti_id, Isvalid from rti_status where rti_id = @rti_id";
// MySqlParameter[] pm = new MySqlParameter[]
// {
// new MySqlParameter("rti_id",bl.RTI_Request_id)
// };
// dt = db.executeSelectQuery(str, pm);
// return dt;
//}
////end of Get Rti Status ISvalid
public ReturnClass.ReturnBool update_Rti_status(bl_RTI_Request bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string str = "insert into rti_status_log select * from rti_status WHERE rti_status.rti_id = @regid1";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("regid1", bl.RTI_Request_id)
};
rb = db.executeInsertQuery(str, pm);
if (rb.status == true)
{
string str1 = "Update rti_status set Isvalid=@isvalid where rti_id = @rtiid ";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("isvalid", bl.IsValid),
new MySqlParameter("rtiid", bl.RTI_Request_id)
};
rb = db.executeUpdateQuery(str1, pm1);
if (rb.status == true)
{
ts.Complete();
}
}
}
return(rb);
}
public ReturnClass.ReturnBool Insert_Login(bl_RTI_Registration ur)
{
string strQuery = "INSERT INTO login " +
"(LoginID, UserID, Password, RollID, PasswordChange, DisableTime, Active,Client_ip,ClientOS,ClientBrowser,user_agent) " +
" VALUES (@loginID, @userID, @password, @rollID, @passwordChange, @disableTime, @active, @Client_ip, @ClientOS, @ClientBrowser, @user_agent)";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("loginID", ur.RegistrationID),
new MySqlParameter("userID", ur.UserID),
new MySqlParameter("password", ur.Password),
new MySqlParameter("rollID", ur.RollID),
new MySqlParameter("passwordChange", ur.PasswordChange ),
new MySqlParameter("disableTime", ur.DisableTime),
new MySqlParameter("active", ur.Active),
new MySqlParameter("Client_ip", ur.UserIP),
new MySqlParameter("ClientOS", ur.UserOS ),
new MySqlParameter("ClientBrowser", ur.User_browser),
new MySqlParameter("user_agent", ur.UserAgent)
};
ReturnClass.ReturnBool dt = null;
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return dt;
}
public ReturnClass.ReturnBool update(bl_empMap bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
string str = @"update emp_office_mapping set Name_en= @Name_en,Active=@Active,
state_id=@state_id,base_department_id=@base_department_id,district_id=@district_id,
NewOfficeCode=@NewOfficeCode,user_id=@user_id
where emp_id=@emp_id ";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Name_en", bl.Emp_name),
new MySqlParameter("Active", bl.Active),
new MySqlParameter("base_department_id", bl.Base_department_id),
new MySqlParameter("district_id", bl.District_id_ofc),
new MySqlParameter("NewOfficeCode", bl.Office_id),
new MySqlParameter("emp_id", bl.Emp_code),
new MySqlParameter("user_id", bl.User_id)
};
rb = db.executeUpdateQuery(str, pm);
return(rb);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
HttpBrowserCapabilities browse = Request.Browser;
if (Page.IsValid)
{
if (btnSubmit.Text == "Submit")
{
string empCode = ddl_employee1.SelectedValue; //"201500001";// TBD
bl.Office_mapping_id = dl.GetMappingID(empCode); //dl.GetMaxValue();
bl.Emp_code = empCode;
bl.Office_id = ddl_office.SelectedValue;
bl.Designation_id = ddl_designation.SelectedValue;
bl.Base_department_id = ddl_department.SelectedValue;
bl.Office_level_id = ddl_office_level.SelectedValue;
bl.District_id_ofc = ddl_district.SelectedValue;
bl.Office_category = ddl_office_category.SelectedValue;
bl.User_id = Session["username"].ToString();
bl.Charge_type = ddl_charge.SelectedValue;
bl.Active = ddl_Active.SelectedValue;
bl.Role_id = Ddl_role.SelectedValue;
if (bl.Active == "Y")
{
bl.FromActive = DateTime.Now.ToString("yyyy-MM-dd"); //DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")
bl.ToActive = null;
}
else
{
bl.FromActive = DateTime.Now.ToString("yyyy-MM-dd");
bl.ToActive = DateTime.Now.ToString("yyyy-MM-dd");
}
bl.ClientOS = Utilities.System_Info(this.Page);
bl.ClientBrowser = browse.Browser;
bl.Useragent = Request.UserAgent.ToString();
bl.Client_ip = ul.GetClientIpAddress(this); // GetIPAddress();
foreach (ListItem sin in ddlcb_permission.Items)
{
if (sin.Selected)
{
bl.Permission.Add(sin.Value);
}
}
rb = dl.Insert_empOfficeMap(bl);
if (rb.status == true)
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Employee Mapping Successsful");
clear();
bind_GridView();
}
else
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Employee Mapping Failed");
}
}
} // if PageIsvalid
}
}
public ReturnClass.ReturnBool Insert_empOfficeMap(bl_empMap ur)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
using (TransactionScope ts = new TransactionScope())
{
string strQuery = @"INSERT INTO emp_office_mapping
(office_mapping_id,emp_code,office_id,designation_id,base_department_id,office_level_id,district_id_ofc,office_category,user_id,charge_type,Active,client_ip, FromActive, ToActive,role_id)
VALUES(@office_mapping_id,@emp_code,@office_id,@designation_id,@base_department_id,@office_level_id,@district_id_ofc,@office_category,@user_id,@charge_type,@Active,@client_ip, @fromActive, @toActive,@role_id)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("office_mapping_id", ur.Office_mapping_id),
new MySqlParameter("emp_code", ur.Emp_code),
new MySqlParameter("office_id", ur.Office_id),
new MySqlParameter("designation_id", ur.Designation_id),
new MySqlParameter("base_department_id", ur.Base_department_id),
new MySqlParameter("office_level_id", ur.Office_level_id),
new MySqlParameter("district_id_ofc", ur.District_id_ofc),
new MySqlParameter("office_category", ur.Office_category),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("charge_type", ur.Charge_type),
new MySqlParameter("Active", ur.Active),
new MySqlParameter("client_ip", ur.Client_ip),
new MySqlParameter("fromActive", ur.FromActive),
new MySqlParameter("toActive", ur.ToActive),
new MySqlParameter("role_id", ur.Role_id)
};
rb = db.executeInsertQuery(strQuery, pm);
if (rb.status == true)
{
foreach (string str12 in ur.Permission)
{
ur.Approve = str12;
if (rb.status == true)
{
string quert = @"insert into permission (emp_map_id,ActionPermission,userid,ipaddress,useragent,useros,clientbrowser)
Values(@emp_map_id,@ActionPermission,@userid,@ipaddress,@useragent,@useros,@clientbrowser)";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("emp_map_id", ur.Office_mapping_id),
new MySqlParameter("ActionPermission", ur.Approve),
new MySqlParameter("userid", ur.User_id),
new MySqlParameter("ipaddress", ur.Client_ip),
new MySqlParameter("useragent", ur.Useragent),
new MySqlParameter("useros", ur.ClientOS),
new MySqlParameter("clientbrowser", ur.ClientBrowser)
};
rb = db.executeInsertQuery(quert, pm1);
}
}
if (rb.status == true)
{
ts.Complete();
}
}
}
return(rb);
}
public ReturnClass.ReturnBool insert_office(bl_report bl)
{
string str = @"insert into office
(NewOfficeCode,DistrictCodeNew,officelevel,OfficeName,BaseDeptCode,countrycode,
Statecode,Officeaddress,contactno,email,fax,Officeurl,OfficeCategory)
values
(@NewOfficeCode,@DistrictCodeNew,@officelevel,@OfficeName,@BaseDeptCode,@countrycode,
@Statecode,@Officeaddress,@contactno,@email,@fax,@Officeurl,@OfficeCategory)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NewOfficeCode", bl.Officeid),
new MySqlParameter("DistrictCodeNew", bl.District),
new MySqlParameter("officelevel", bl.Office_level_id),
new MySqlParameter("OfficeName", bl.Office_id),
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_id),
new MySqlParameter("fax", bl.Fax),
new MySqlParameter("Officeurl", bl.Url),
new MySqlParameter("OfficeCategory", bl.Category)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool update_password(bl_login bl)
{
using (TransactionScope ts = new TransactionScope())
{
string str = @"insert into login_log select * from login WHERE login.UserID =@regid1";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("regid1", bl.RegistrationID)
};
rb = db.executeInsertQuery(str, pm);
if (rb.status == true)
{
string str2 = @"update login set Password=@Password , Client_ip=@Client_ip, ClientOS=@ClientOS,
ClientBrowser=@ClientBrowser, user_agent=@user_agent , PasswordChange=@PAssworchng where UserID=@regid and Password=@pass";
MySqlParameter[] pm2 = new MySqlParameter[] {
new MySqlParameter("Password", bl.NewPass),
new MySqlParameter("PAssworchng", bl.PasswordChange),
new MySqlParameter("regid", bl.RegistrationID),
new MySqlParameter("Client_ip", bl.UserIP),
new MySqlParameter("ClientOS", bl.UserOS),
new MySqlParameter("ClientBrowser", bl.User_browser),
new MySqlParameter("user_agent", bl.UserAgent),
new MySqlParameter("pass", bl.Password)
};
rb = db.executeUpdateQuery(str2, pm2);
if (rb.status == true)
{
ts.Complete();
}
}
}
return(rb);
}
public ReturnClass.ReturnBool update(bl_report bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
string str = @"update employee_table set Name_en= @Name_en,Active=@Active,
state_id=@state_id,base_department_id=@base_department_id,district_id=@district_id,
NewOfficeCode=@NewOfficeCode,mobile_no=@mobile_no,email_id=@email_id,user_id=@user_id
where emp_id=@emp_id ";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Name_en", bl.Name_en),
new MySqlParameter("Active", bl.Active),
new MySqlParameter("state_id", bl.State_id),
new MySqlParameter("base_department_id", bl.Department),
new MySqlParameter("district_id", bl.District_id),
new MySqlParameter("NewOfficeCode", bl.NewOfficeCode),
new MySqlParameter("mobile_no", bl.Mobile_no),
new MySqlParameter("email_id", bl.Email_id),
new MySqlParameter("emp_id", bl.Emp_id),
new MySqlParameter("user_id", bl.User_id)
};
rb = db.executeUpdateQuery(str, pm);
return(rb);
}
} // end of get GetGender
public ReturnClass.ReturnBool Update_registration(bl_RTI_Registration bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string str1 = "insert into user_registration_log select * from user_registration WHERE user_registration.RegistrationID = @regid1";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("regid1",bl.RegistrationID)
};
string str = "update user_registration us set us.IsValid=@isvalid where us.RegistrationID = @regid";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("isvalid",bl.IsValid),
new MySqlParameter("regid",bl.RegistrationID)
};
rb = db.executeInsertQuery(str1, pm1);
if (rb.status == true)
{
rb = db.executeUpdateQuery(str, pm);
}
if (rb.status == true)
{
ts.Complete();
}
};
return rb;
}
protected void btn_update_Click(object sender, EventArgs e)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
if (Page.IsValid)
{
Captcha1.ValidateCaptcha(txtCaptcha.Text.Trim());
if (Captcha1.UserValidated)
{
string OTP = Session["OTP"].ToString();
if (txt_otp.Text == OTP)
{
HttpBrowserCapabilities browse = Request.Browser;
if (txt_new_pass.Text == txt_repass.Text)
{
bl.UserID = Session["user"].ToString();
dt = dl.select_password_by_username(bl);
Session["pass"] = dt.table.Rows[0]["Password"].ToString();
bl.NewPass = ul.GenerateMd5Hash(txt_new_pass.Text);
dt = dl.select_password_log(bl);
if (dt.table.Rows.Count == 0)
{
bl.UserID = Session["user"].ToString();
bl.Password = Session["pass"].ToString();
bl.NewPass = ul.GenerateMd5Hash(txt_new_pass.Text);
bl.UserIP = ul.GetClientIpAddress(this.Page);
bl.UserAgent = Request.UserAgent.ToString();
bl.UserOS = Utilities.System_Info(this.Page);
bl.User_browser = browse.Browser;
bl.PasswordChange = "Y";
rb = dl.update_password(bl);
if (rb.status == true)
{
Utilities.MessageBoxShow_Redirect("Your Password Update Successful Please Login Again", "../LogOut.aspx");
}
else
{
Utilities.MessageBoxShow("Password Update Unsuccessful");
}
}
else
{
Utilities.MessageBoxShow("Your New Password Looks Like Your Old Password Please Create Unique Password");
}
}
else
{
Utilities.MessageBoxShow("Your New Password Does Not Match With Your Repeated Password Please Check");
}
}
else
{
Utilities.MessageBoxShow("You Entered Wrong OTP Please Enter Right OTP");
}
}
}
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
bl.State = "22";
bl.Active = "N";
bl.Country = "91";
bl.District = ddl_district.SelectedValue;
bl.Officelvl = ddl_Ofc_Lvl.SelectedValue;
bl.Base_department = ddl_department.SelectedValue;
bl.Category = ddl_category.SelectedValue;
bl.Office = txt_office.Text;
bl.Address = txt_address.Text;
bl.Contact = txt_contact.Text;
bl.Fax = txt_fax.Text;
bl.Email = txt_email.Text;
bl.Url = txt_url.Text;
bl.Officeid = dl.Max_office_code(bl);
bl.Ipaddress = ul.GetClientIpAddress(this.Page);
bl.Useragent = Request.UserAgent.ToString();
bl.Clientos = Utilities.System_Info(this.Page);
bl.Client_browser = Request.Browser.Browser;
if (fu_identity.PostedFile != null || fu_identity.PostedFile.FileName != "")
{
if (fu_identity.PostedFile.ContentLength < 209715)
{
if (fu_identity.PostedFile.ContentType == "image/jpeg" || fu_identity.PostedFile.ContentType == "image/pipeg")
{
blr.RTI_fileName = fu_identity.PostedFile.FileName;
blr.RTI_fileType = fu_identity.PostedFile.ContentType;
Stream fs = fu_identity.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
blr.RTI_fileData = bytes;
bl.Userid = "";
rb = dl.insert_ofc_new(bl, blr);
if (rb.status)
{
Utilities.MessageBox_UpdatePanel(udp, "Office request Has been Submitted. ");
}
else
{
Utilities.MessageBox_UpdatePanel(udp, "Office request failed due to some reason plaese try again later. ");
}
}
}
else
{
Utilities.MessageBox_UpdatePanel(udp, "provided Image is Big. Please provide Image Less than 200kb ");
}
}
// blr.RTI_fileID = fu_identity.PostedFile.FileName;
}
}
}
//-------------------------pending for approval page---------------------------------------------------------------------//
public ReturnClass.ReturnBool delete_notice_and_file(Notice_Entry ne)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope transScope = new TransactionScope())
{
string query = "insert into notice_board_log select * from Notice_Board where Notice_Id=@NoticeID";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID)
};
rb = db.executeInsertQuery(query, pm);
if (rb.status == true)
{
string query2 = @"delete from Notice_Board where Notice_Id=@NoticeID ";
MySqlParameter[] pm2 = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID)
// new MySqlParameter("district_id",ne.district_id)
};
rb = db.executeDeleteQuery(query2, pm2);
}
if (ne.file_id == null)
{
}
else
{
if (rb.status == true)
{
string query3 = "insert into notice_file_details_log select * from notice_file_details where file_id=@file_id";
MySqlParameter[] pm3 = new MySqlParameter[] {
new MySqlParameter("file_id", ne.file_id)
};
rb = db.executeInsertQuery(query3, pm3);
}
if (rb.status == true)
{
string query4 = "delete from notice_file_details where file_id=@file_id";
MySqlParameter[] pm4 = new MySqlParameter[] {
new MySqlParameter("file_id", ne.file_id)
};
rb = db.executeInsertQuery(query4, pm4);
}
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnClass.ReturnBool update_file_details(Upload_doc ud)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
//BA_layer ba = new BA_layer();
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("f_id", ud.file_ID),
//new MySqlParameter("file_id",ud.file_id),
new MySqlParameter("Header", ud.Filename),
new MySqlParameter("mime_type", ud.File_Extn),
new MySqlParameter("file_data", ud.File_Data),
new MySqlParameter("Client_Ip", ud.Client_ip),
new MySqlParameter("User_Id", ud.User_id),
new MySqlParameter("Date_Time", ud.Upload_Date)
};
try
{
using (TransactionScope ts = new TransactionScope())
{
string qur = "insert into notice_file_details_log select * from notice_file_details where file_id=@f_id";
rb = db.executeInsertQuery(qur, param);
if (rb.status == true)
{
if (ud.Status != "Y")
{
string delQUr = "delete from notice_file_details where file_id=@f_id";
rb = db.executeDeleteQuery(delQUr, param);
}
else if (ud.Status == "Y")
{
string upqur = "update notice_file_details set File_Header=@Header,mime_type=@mime_type,file_data=@file_data,"
+ "client_ip=@Client_Ip,user_code=@User_Id,upload_date=@Date_Time "
+ "where file_id=@f_id";
rb = db.executeUpdateQuery(upqur, param);
}
}
if (rb.status == true)
{
ts.Complete();
}
}
}
catch (Exception ex)
{
rb.status = false;
Gen_Error_Rpt.Write_Error("Notice Edit Form - Update Method() :- " + ex.Message.ToString());
}
return(rb);
}
protected void Resend_Click(object sender, EventArgs e)
{
bl.Cell_No = Session["Mobile_No"].ToString();
bl.Success = send_sms(Session["OTP"].ToString(), Session["Mobile_No"].ToString());
rb = dl.sms_log(bl);
if (rb.status)
{
Utilities.MessageBoxShow("otp resend successfully");
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
// string state = (GridView1.Rows[e.RowIndex].FindControl("ddl_state") as DropDownList).SelectedItem.Value;
//GridView1.DataKeys[e.RowIndex].Values["ofc_map_id"].ToString();
bl_employee_action bl_emp_action = new bl_employee_action();
dl_RTIReAssign dl_rti = new dl_RTIReAssign();
bl_emp_action.Rti_status = "PEN";
bl_emp_action.Dept_Status = (GridView1.Rows[e.RowIndex].FindControl("ddl_dept_status") as DropDownList).SelectedItem.Value;
bl_emp_action.R_office_map_id = (GridView1.Rows[e.RowIndex].FindControl("ddl_officer_grid") as DropDownList).SelectedItem.Value;
bl_emp_action.Ipaddress = ul.GetClientIpAddress(this.Page);
HttpBrowserCapabilities browse = Request.Browser;
bl_emp_action.User_browser = browse.Browser;
bl_emp_action.Useros = Utilities.System_Info(this.Page);
bl_emp_action.Useragent = Request.UserAgent.ToString();
bl_emp_action.Isnew = "Y";
bl_emp_action.Userid = Session["username"].ToString();
bl_emp_action.Rti_id = GridView1.DataKeys[e.RowIndex].Values["rti_id"].ToString();;
DateTime today = DateTime.Today;
bl_emp_action.Action_date = today.ToString("yyyy/MM/dd");
rb = dl_rti.Update_RTIstatus(bl_emp_action);
if (rb.status == true)
{
if (Session["language"].ToString() == "en-GB")
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update Successsfully");
}
else
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "अपडेट सफल हुआ");
}
// Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update Successsfully");
}
else
{
if (Session["language"].ToString() == "en-GB")
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update UnSuccesssfully");
}
else
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "अपडेट असफल हुआ");
}
//Utilities.MessageBox_UpdatePanel(UpdatePanel1, "update Unsuccessful");
}
GridView1.EditIndex = -1;
BindGridView();
bind_office();
bind_district_code();
bind_department_id();
}
protected void Btn_Password_Click(object sender, EventArgs e)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
if (Btn_Password.Text == "Change Password")
{
rfv_Password.Enabled = true;
Rfv_PAss.Enabled = true;
rfv_repass.Enabled = true;
comp_repass.Enabled = true;
Rev_password.Enabled = true;
lbl_password.Visible = true;
txt_Password.Visible = true;
div_Password.Visible = true;
Btn_Password.Text = "Update Password";
btn_update.Visible = false;
}
else if (Btn_Password.Text == "Update Password")
{
if (txt_new_pass.Text == txt_repass.Text)
{
bl.Password = ul.GenerateMd5Hash(txt_Password.Text);
bl.UserID = Session["username"].ToString();
dt = dl.select_user(bl);
if (dt.table.Rows.Count > 0)
{
bl.RegistrationID = dt.table.Rows[0]["LoginID"].ToString();
bl.Password = ul.GenerateMd5Hash(txt_new_pass.Text);
bl.UserID = Session["username"].ToString();
bl.PasswordChange = "Y";
rb = dl.update_password(bl);
if (rb.status == true)
{
comp_repass.Enabled = false;
Rev_password.Enabled = false;
rfv_Password.Enabled = false;
Rfv_PAss.Enabled = false;
rfv_repass.Enabled = false;
lbl_password.Visible = false;
txt_Password.Visible = false;
div_Password.Visible = false;
Btn_Password.Text = "Change Password";
btn_update.Visible = true;
Utilities.MessageBoxShow("Password Change Successfully");
}
else
{
Utilities.MessageBoxShow("Password Change UnSuccessful");
}
}
}
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
btn_update.Visible = true;
btn_submit.Visible = false;
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
TextBox txt_name = (TextBox)row.FindControl("txt_Emp_Name") as TextBox;
bl.Name_en = txt_name.Text;
TextBox txt_mobile = (TextBox)row.FindControl("txt_mob_num") as TextBox;
bl.Mobile_no = txt_mobile.Text;
TextBox txt_email = (TextBox)row.FindControl("txt_email") as TextBox;
bl.Email_id = txt_email.Text;
string state = (GridView1.Rows[e.RowIndex].FindControl("ddl_state") as DropDownList).SelectedItem.Value;
string district = (GridView1.Rows[e.RowIndex].FindControl("ddl_district") as DropDownList).SelectedItem.Value;
string department = (GridView1.Rows[e.RowIndex].FindControl("ddl_department_grid") as DropDownList).SelectedItem.Value;
string office = (GridView1.Rows[e.RowIndex].FindControl("ddl_office") as DropDownList).SelectedItem.Value;
bl.User_id = Session["username"].ToString();
bl.Name_hi = "";
bl.District_id = district;
bl.State_id = state;
bl.Department = department;
bl.NewOfficeCode = office;
bl.Emp_id = GridView1.DataKeys[e.RowIndex].Values["id"].ToString();
bl.Active = "Y";
rb = dl.update(bl);
if (rb.status == true)
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update Successsfully");
}
else
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "update Unsuccessful");
}
GridView1.EditIndex = -1;
BindGridView();
bind_office();
bind_district_code();
bind_department_id();
btn_update.Visible = false;
btn_submit.Visible = true;
}
public ReturnClass.ReturnBool insertroll(bl_report bl)
{
string str = "insert into role_table(Role_id,RoleName,WelcomePage) values(@Role_id,@RoleName,@WelcomePage)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("Role_id", bl.Role),
new MySqlParameter("RoleName", bl.RollName),
new MySqlParameter("WelcomePage", bl.Welcomepage)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
