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