public ActionResult Edit_data_password_authenticate(Password_Authentication PA)
{
try
{
DataSet ds = _objwl.Edit_data_password_authenticate(PA);
List<Password_Authentication> Password_Authentication1 = new List<Password_Authentication>();
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.fname = ds.Tables[0];
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
Password_Authentication1.Add(new Password_Authentication
{
srno = dr["srno"].ToString(),
Corporate = dr["Corporate"].ToString(),
CapitalCharNumber = dr["CapitalCharNumber"].ToString(),
RequiredNumeric = dr["RequiredNumeric"].ToString(),
SpecialCharNumber = dr["SpecialCharNumber"].ToString(),
EncriptionKey = dr["EncriptionKey"].ToString(),
PasswordMinLength = dr["PasswordMinLength"].ToString(),
PasswordExpiryDays = dr["PasswordExpiryDays"].ToString(),
// UserLoginDay = dr["UserLoginDay"].ToString(),
NumberOfAttempts = dr["NumberOfAttempts"].ToString(),
// NumberOfAttemptsTime = dr["NumberOfAttemptsTime"].ToString(),
OTPExpiryTime = dr["OTPExpiryTime"].ToString(),
LastSamePassword = dr["LastSamePassword"].ToString(),
UnableCaptcha = dr["UnableCaptcha"].ToString(),
// AutoLockScreen = dr["AutoLockScreen"].ToString(),
UserUnlockMinut = dr["UserLockMinuts"].ToString(),
Continuenumber = dr["Continuenumber"].ToString()
});
}
}
var result = Password_Authentication1;
return Json(new { UserPreferancestep1js = result }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public DataSet Edit_data_password_authenticate(Password_Authentication PA)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Edit_PasswordConfiguration", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@tablename", "_PasswordConfiguration");
_cmd.Parameters.AddWithValue("@Corporate", PA.Corporate);
_cmd.Parameters.AddWithValue("@unit", "0");
_cmd.Parameters.AddWithValue("@Formcode", "0");
_cmd.Parameters.AddWithValue("@Formtabcode", "0");
_cmd.Parameters.AddWithValue("@srno", PA.srno);
_cmd.Parameters.AddWithValue("@Type", "EditMode");
_cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return _ds;
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
_cn.Dispose();
}
}
public ActionResult insert_PasswordAuth(Password_Authentication PA)
{
try
{
DataSet ds = _objwl.insert_PasswordAuth(PA);
if (ds.Tables[0].Rows.Count > 0)
{
ViewBag.srno = ds.Tables[0].Rows[0]["Srno"];
ViewBag.Message = ds.Tables[0].Rows[0]["msg"];
if (ds.Tables[0].Rows[0]["Help"].ToString() == "Save" || ds.Tables[0].Rows[0]["Help"].ToString() == "Update")
{ ViewBag.Event = "success"; }
else if (ds.Tables[0].Rows[0]["Help"].ToString() == "Duplicate")
{ ViewBag.Event = "error"; }
}
return Json(new { srno = ViewBag.srno, Event = ViewBag.Event, responseText = ViewBag.Message }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public DataSet insert_PasswordAuth(Password_Authentication PA)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_save_PasswordConfiguration", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@srno", PA.srno);
_cmd.Parameters.AddWithValue("@Corporate", PA.Corporate);
_cmd.Parameters.AddWithValue("@CapitalCharNumber", PA.CapitalCharNumber);
_cmd.Parameters.AddWithValue("@RequiredNumeric", PA.RequiredNumeric);
_cmd.Parameters.AddWithValue("@SpecialCharNumber", PA.SpecialCharNumber);
_cmd.Parameters.AddWithValue("@EncriptionKey", PA.EncriptionKey);
_cmd.Parameters.AddWithValue("@PasswordMinLength", PA.PasswordMinLength);
_cmd.Parameters.AddWithValue("@PasswordExpiryDays", PA.PasswordExpiryDays);
_cmd.Parameters.AddWithValue("@UserLoginDay", PA.UserLoginDay);
_cmd.Parameters.AddWithValue("@NumberOfAttempts", PA.NumberOfAttempts);
_cmd.Parameters.AddWithValue("@NumberOfAttemptsTime", PA.NumberOfAttemptsTime);
_cmd.Parameters.AddWithValue("@OTPExpiryTime", PA.OTPExpiryTime);
_cmd.Parameters.AddWithValue("@LastSamePassword", PA.LastSamePassword);
_cmd.Parameters.AddWithValue("@UnableCaptcha", PA.UnableCaptcha);
_cmd.Parameters.AddWithValue("@AutoLockScreen", PA.AutoLockScreen);
_cmd.Parameters.AddWithValue("@UserLockMinuts", PA.UserUnlockMinut);
_cmd.Parameters.AddWithValue("@Continuenumber", PA.Continuenumber);
_cmd.Parameters.AddWithValue("@Attribute1", PA.Attribute1);
_cmd.Parameters.AddWithValue("@Attribute2", PA.Attribute2);
_cmd.Parameters.AddWithValue("@Attribute3", PA.Attribute3);
_cmd.Parameters.AddWithValue("@Attribute4", PA.Attribute4);
_cmd.Parameters.AddWithValue("@Attribute5", PA.Attribute5);
_cmd.Parameters.AddWithValue("@Attribute6", PA.Attribute6);
_cmd.Parameters.AddWithValue("@Attribute7", PA.Attribute7);
_cmd.Parameters.AddWithValue("@Attribute8", PA.Attribute8);
_cmd.Parameters.AddWithValue("@Attribute9", PA.Attribute9);
_cmd.Parameters.AddWithValue("@Attribute10", PA.Attribute10);
_cmd.Parameters.AddWithValue("@CreatedBy", PA.CreatedBy);
_cmd.Parameters.AddWithValue("@CorpcentreBy", PA.CorpcentreBy);
_cmd.Parameters.AddWithValue("@UnitCorpBy", PA.UnitCorpBy);
_cmd.Parameters.AddWithValue("@TerminalBy", PA.TerminalBy);
_cmd.Parameters.AddWithValue("@BranchBy", PA.BranchBy);
SqlDataAdapter adp = new SqlDataAdapter(_cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
adp.Dispose();
_cmd.Dispose();
return ds;
}
catch
{
throw;
}
finally
{
_cn.Close();
_cn.Dispose();
}
}