public int DeleteUser(int User_ID)
{
Ent_User ent = new Ent_User();
ent.User_ID = User_ID;
//HttpCookie UserID = Request.Cookies["User_ID"];
//var UserId = UserID != null ? UserID.Value.Split('=')[1] : "";
//ent.Modified_By = Convert.ToInt32(UserId);
ent.Modified_By = 1;
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
ent.Modified_Date = indiTime;
SafeTransaction trans = new SafeTransaction();
int i = balMaster.DeleteUser(ent, trans);
if (i > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(i);
}
public List <Ent_User> SelectLogin(Ent_User entu)
{
List <Ent_User> result = new List <Ent_User>();
Ent_User ent = new Ent_User();
try
{
using (SqlCommand cmd = new SqlCommand("select User_ID,User_Name,User_Type from EC_Users where User_Username='******' and User_Password='******' and Is_Active=1", con))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ent = new Ent_User();
ent.User_ID = Convert.ToInt32(dr["User_ID"]);
ent.User_Name = Convert.ToString(dr["User_Name"]);
ent.User_Type = Convert.ToString(dr["User_Type"]);
result.Add(ent);
}
}
}
catch (Exception Ex)
{
InsertException(Ex.Message, "SelectLogin", ent.User_ID);
}
return(result);
}
public void Create(Ent_User ent_User)
{
Conexion.GDatos.Ejecutar(NamesProcedures.InsertUser, ent_User.USE_GUID_ID,
ent_User.PER_GUID_ID,
ent_User.STD_GUID_ID,
ent_User.USE_LOGIN,
ent_User.USE_PASS,
ent_User.USE_STATUS
);
}
public ActionResult AddUser()
{
int User_ID = Request.QueryString["UserID"] != null?Convert.ToInt32(Request.QueryString["UserID"]) : 0;
Ent_User ent = new Ent_User();
if (User_ID != 0)
{
ent = balMaster.SelectUser(User_ID);
}
return(View(ent));
}
public List <Ent_User> SelectLogin(Ent_User entu)
{
List <Ent_User> result = new List <Ent_User>();
try
{
Dal_Master dal = new Dal_Master();
result = dal.SelectLogin(entu);
return(result);
}
catch
{
return(result);
}
}
public int DeleteUser(Ent_User ent, SafeTransaction trans)
{
int dataResult;
try
{
Dal_Master dal = new Dal_Master();
dataResult = dal.DeleteUser(ent, trans);
return(dataResult);
}
catch
{
return(-1);
}
}
public Ent_User SelectUser(int user_id)
{
Ent_User list = new Ent_User();
try
{
Dal_Master dal = new Dal_Master();
list = dal.SelectUser(user_id);
return(list);
}
catch
{
return(list);
}
}
public int SaveUser(Ent_User entGuest, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Master dal = new Dal_Master();
dataResult = dal.SaveUser(entGuest, trans);
return(dataResult);
}
catch
{
return(0);
}
}
//Login
public int CreateLogin(string Username, string Password)
{
int i = 0;
if (Username != "" && Password != "")
{
List <Ent_User> result = new List <Ent_User>();
Ent_User entu = new Ent_User();
entu.User_Username = Username;
entu.User_Password = Password;
result = balMaster.SelectLogin(entu);
if (result.Count > 0)
{
if (result[0].User_ID > 0)
{
HttpCookie User_ID = new HttpCookie("User_ID");
User_ID.Values["User_ID"] = Convert.ToString(result[0].User_ID);
User_ID.Expires = DateTime.Now.AddMinutes(10);
Response.Cookies.Add(User_ID);
HttpCookie User_Name = new HttpCookie("User_Name");
User_Name.Values["User_Name"] = Convert.ToString(result[0].User_Name);
User_Name.Expires = DateTime.Now.AddMinutes(10);
Response.Cookies.Add(User_Name);
HttpCookie User_Type = new HttpCookie("User_Type");
User_Type.Values["User_Type"] = Convert.ToString(result[0].User_Type);
User_Type.Expires = DateTime.Now.AddMinutes(10);
Response.Cookies.Add(User_Type);
i = 1;
}
else
{
i = -1;
}
}
else
{
i = -1;
}
}
else
{
i = 0;
}
return(i);
}
public List <Ent_User> SelectUserList(int user_id)
{
List <Ent_User> list = new List <Ent_User>();
Ent_User ent = new Ent_User();
try
{
using (SqlCommand cmd = new SqlCommand("EC_SelectUser", con))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@User_ID", user_id));
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ent = new Ent_User();
ent.User_ID = Convert.ToInt32(dr["User_ID"]);
ent.User_Name = Convert.ToString(dr["User_Name"]);
ent.User_Type = Convert.ToString(dr["User_Type"]);
ent.User_Designation = Convert.ToString(dr["User_Designation"]);
ent.User_Username = Convert.ToString(dr["User_Username"]);
ent.User_Password = Convert.ToString(dr["User_Password"]);
ent.User_Email = Convert.ToString(dr["User_Email"]);
ent.User_Phone = Convert.ToString(dr["User_Phone"]);
list.Add(ent);
}
cmd.Dispose();
}
}
catch (Exception e)
{
InsertException(e.Message, "SelectUserList", user_id);
}
finally
{
con.Close();
}
return(list);
}
public int SaveUser(Ent_User model)
{
int result = 0;
SafeTransaction trans = new SafeTransaction();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
model.Created_Date = indiTime;
//HttpCookie User_ID = Request.Cookies["User_ID"];
//model.Created_By = Convert.ToInt32(User_ID.Value.Split('=')[1]);
model.Created_By = 1;
result = balMaster.SaveUser(model, trans);
if (result > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(result);
}
public int DeleteUser(Ent_User ent, SafeTransaction trans)
{
int dataResult = 0;
int dataresult1 = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_DeleteUser", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@User_ID", ent.User_ID));
cmd.Parameters.Add(new SqlParameter("@Modified_By", ent.Modified_By));
cmd.Parameters.Add(new SqlParameter("@Modified_Date", ent.Modified_Date));
try
{
dataResult = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
catch (Exception e)
{
InsertException(e.Message, "DeleteUser", ent.User_ID);
dataResult = -1;
}
}
if (dataResult > 0)
{
using (SqlCommand cmd = new SqlCommand("EC_InsertLog", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Modified_By));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Modified_Date));
cmd.Parameters.Add(new SqlParameter("@Primary_Id", ent.User_ID));
cmd.Parameters.Add(new SqlParameter("@Log_Action", "Delete User"));
cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin"));
try
{
dataresult1 = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult1 > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult1 = -2;
}
}
}
}
catch (Exception)
{
dataResult = -1;
}
finally
{
con.Close();
}
return(dataResult);
}
public int SaveUser(Ent_User ent, SafeTransaction trans)
{
int dataresult = 0;
int dataresult1 = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_InsertUser", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@User_ID", ent.User_ID));
cmd.Parameters.Add(new SqlParameter("@User_Name", ent.User_Name));
cmd.Parameters.Add(new SqlParameter("@User_Designation", ent.User_Designation));
cmd.Parameters.Add(new SqlParameter("@User_Address", ent.User_Address));
cmd.Parameters.Add(new SqlParameter("@User_Email", ent.User_Email));
cmd.Parameters.Add(new SqlParameter("@User_Phone", ent.User_Phone));
cmd.Parameters.Add(new SqlParameter("@User_Type", ent.User_Type));
cmd.Parameters.Add(new SqlParameter("@User_Username", ent.User_Username));
cmd.Parameters.Add(new SqlParameter("@User_Password", ent.User_Password));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Created_By));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult = -2;
InsertException(ex.Message, "SaveUser", ent.User_ID);
}
}
if (dataresult > 0)
{
using (SqlCommand cmd = new SqlCommand("EC_InsertLog", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Created_By));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@Primary_Id", dataresult));
if (ent.User_ID > 0)
{
cmd.Parameters.Add(new SqlParameter("@Log_Action", "Update User"));
}
else
{
cmd.Parameters.Add(new SqlParameter("@Log_Action", "Insert User"));
}
cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin"));
try
{
dataresult1 = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult1 > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult1 = -2;
}
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
