//public void BindGrid(string sz_company_id) //{ // try // { // grd_User_List.DataSource = getCompanyWise_Users(sz_company_id); // grd_User_List.DataBind(); // } // catch (Exception ex) // { // } //} protected void btn_save_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { User_Login_With_IP_Validation obj = new User_Login_With_IP_Validation(); ArrayList arr_Check = new ArrayList(); string Company_ID = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; string sz_ip_address = Request.QueryString["sz_ip_address"].ToString(); ArrayList arr_User = new ArrayList(); for (int i = 0; i < grd_User_List.Rows.Count; i++) { CheckBox chk = (CheckBox)grd_User_List.Rows[i].FindControl("chkVisit"); if (chk.Checked) { Bill_Sys_IP_Objects objIP = new Bill_Sys_IP_Objects(); string sz_Company_ID = Company_ID; string ip_address = sz_ip_address; string SZ_USER_ID = grd_User_List.DataKeys[i][0].ToString(); string SZ_USER_NAME = grd_User_List.DataKeys[i][1].ToString(); objIP.SZ_COMPANY_ID = sz_Company_ID; objIP.SZ_IP_ADDRESS = ip_address; objIP.SZ_USER_ID = SZ_USER_ID; objIP.SZ_USER_NAME = SZ_USER_NAME; arr_User.Add(objIP); } } log.Debug("Before save_IP_With_Multiple()"); string str_success = obj.save_IP_With_Multiple(arr_User, Company_ID, sz_ip_address); //objIP = (Bill_Sys_IP_Objects)arr_Check[arr_Check.Count - 1]; string message = ""; if (str_success == "1") { message = "User added successfully "; lblMessage.Text = message; } else { lblMessage.Text = "User not added"; } lblMessage.Visible = true; ScriptManager.RegisterStartupScript(this, GetType(), "fncLocal", "fncLocal();", true); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
public string save_IP_With_Multiple(ArrayList p_objArrayList, string sz_company_id, string sz_ip_address) { log.Debug("In save_IP_With_Multiple"); SqlTransaction tr; comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandTimeout = 0; conn = new SqlConnection(strsqlCon); conn.Open(); tr = conn.BeginTransaction(); ArrayList arr_Validate_IP = new ArrayList(); string str_success = "0"; Bill_Sys_IP_Objects obj = new Bill_Sys_IP_Objects(); try { //Bill_Sys_IP_Objects objBill = (Bill_Sys_IP_Objects)p_objArrayList[0]; log.Debug("Before SP_SAVE_IP_WITH_MULTIPLE_USERS(Delete)"); SqlCommand cmd = new SqlCommand("SP_SAVE_IP_WITH_MULTIPLE_USERS", conn); cmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); log.Debug("SqlCommand cmd"); cmd.CommandTimeout = 0; log.Debug("cmd.CommandTimeout = 0;"); cmd.Transaction = tr; log.Debug("cmd.Transaction = tr;"); cmd.Parameters.AddWithValue("@SZ_COMPANY_ID", sz_company_id); log.Debug("sz_company_id " + sz_company_id); cmd.Parameters.AddWithValue("@SZ_IP_ADDRESS", sz_ip_address); log.Debug("sz_ip_address " + sz_ip_address); cmd.Parameters.AddWithValue("@FLAG", "DELETE"); log.Debug("cmd.Parameters.AddWithValue(@FLAG, DELETE)"); cmd.CommandType = CommandType.StoredProcedure; log.Debug("cmd.CommandType"); cmd.ExecuteNonQuery(); log.Debug("cmd.ExecuteNonQuery"); //string squery = "delete from tbl_insert_ip_address where sz_company_id='" + sz_company_id + "' and sz_ip_address='" + sz_ip_address + "'"; //SqlCommand cmd = new SqlCommand(squery, conn); //cmd.CommandTimeout = 0; //cmd.Transaction = tr; //cmd.ExecuteNonQuery(); for (int i = 0; i < p_objArrayList.Count; i++) { log.Debug("In the for loop"); obj = (Bill_Sys_IP_Objects)p_objArrayList[i]; DataSet ds = new DataSet(); //string squery_insert = "insert into tbl_insert_ip_address (sz_company_id,sz_ip_address,sz_user_id,dt_created) values ('" + obj.SZ_COMPANY_ID + "','" + obj.SZ_IP_ADDRESS + "','" + obj.SZ_USER_ID + "','"+DateTime.Now.ToString()+"')"; //cmd = new SqlCommand(squery_insert, conn); cmd = new SqlCommand("SP_SAVE_IP_WITH_MULTIPLE_USERS", conn); cmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); log.Debug("cmd"); cmd.CommandTimeout = 0; log.Debug("cmd.CommandTimeout = 0;"); cmd.Transaction = tr; log.Debug("cmd.Transaction = tr;"); log.Debug("obj.SZ_USER_ID " + obj.SZ_USER_ID); log.Debug("obj.SZ_COMPANY_ID " + obj.SZ_COMPANY_ID); log.Debug("obj.SZ_IP_ADDRESS" + obj.SZ_IP_ADDRESS); cmd.Parameters.AddWithValue("@SZ_USER_ID", obj.SZ_USER_ID); cmd.Parameters.AddWithValue("@SZ_COMPANY_ID", obj.SZ_COMPANY_ID); cmd.Parameters.AddWithValue("@SZ_IP_ADDRESS", obj.SZ_IP_ADDRESS); cmd.Parameters.AddWithValue("@FLAG", "ADD"); cmd.CommandType = CommandType.StoredProcedure; log.Debug("cmd.CommandType"); cmd.ExecuteNonQuery(); log.Debug("cmd.ExecuteNonQuery"); str_success = "1"; log.Debug("str_success : " + str_success); } log.Debug("Before tr.Commit();"); tr.Commit(); log.Debug("After tr.Commit();"); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); tr.Rollback(); } finally { conn.Close(); } obj.SZ_PRINT_SUCCESS_MESSAGE = str_success; //obj.SZ_PRINT_ERROR_MESSAGE = str_error; arr_Validate_IP.Add(obj); return(str_success); }