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