public static int Login_Save(Entity.Common.Auth auth)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Login_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", auth.UserId);
cmd.Parameters.AddWithValue("@IP", auth.IP);
cmd.Parameters.AddWithValue("@Status", Enum.GetName(typeof(Entity.Common.LoginStatus), auth.Status));
cmd.Parameters.AddWithValue("@Client", auth.Client);
cmd.Parameters.AddWithValue("@FailedUserName", auth.FailedUserName);
cmd.Parameters.AddWithValue("@FailedPassword", auth.FailedPassword);
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
public int Login_Save(Entity.Common.Auth auth)
{
return(DataAccess.HR.EmployeeMaster.Login_Save(auth));
}
