public ActionResult Edit(AdminUserPartial objAdminUserPartial)
{
bool status = false;
if (ModelState.IsValid)
{
AdminUserPartialBLL objAdminUserPartialBll = new AdminUserPartialBLL();
objAdminUserPartialBll.UpdateAdminUser(objAdminUserPartial);
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public AdminUserPartial GetAdminUser(int id)
{
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted);
DbDataReader objDbDataReader = null;
AdminUserPartial objAdminUserPartial = new AdminUserPartial();
List <AdminUserPartial> objAdminUserList = new List <AdminUserPartial>();
try
{
objDbCommand.AddInParameter("AdminUserId", id);
objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[dbo].[uspGetAdminUser]", CommandType.StoredProcedure);
if (objDbDataReader.HasRows)
{
while (objDbDataReader.Read())
{
objAdminUserPartial = new AdminUserPartial();
this.BuildModelForAdminUser(objDbDataReader, objAdminUserPartial);
objAdminUserList.Add(objAdminUserPartial);
}
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
if (objDbDataReader != null)
{
objDbDataReader.Close();
}
objDataAccess.Dispose(objDbCommand);
}
return(objAdminUserPartial);
}
//Edit Admin User Information
public string UpdateAdminUser(AdminUserPartial objAdminUserPartial)
{
int noRowCount = 0;
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
objDbCommand.AddInParameter("AdminUserId", objAdminUserPartial.AdminUserId);
objDbCommand.AddInParameter("UserRole", objAdminUserPartial.UserRole);
objDbCommand.AddInParameter("EmailAddress", objAdminUserPartial.EmailAddress);
objDbCommand.AddInParameter("MaxCompany", objAdminUserPartial.MaxCompany);
objDbCommand.AddInParameter("MaxBranch", objAdminUserPartial.MaxBranch);
//objDbCommand.AddInParameter("CreatedBy", objAdminUser.CreatedBy);
try
{
noRowCount = objDataAccess.ExecuteNonQuery(objDbCommand, "[dbo].uspUpdateAdminUser", CommandType.StoredProcedure);
if (noRowCount > 0)
{
objDbCommand.Transaction.Commit();
return("Save Successfully");
}
else
{
objDbCommand.Transaction.Rollback();
return("Save Failed");
}
}
catch (Exception ex)
{
objDbCommand.Transaction.Rollback();
throw new Exception("Database Error Occured", ex);
}
finally
{
objDataAccess.Dispose(objDbCommand);
}
}
private void BuildModelForAdminUser(DbDataReader objDataReader, AdminUserPartial objAdminUserPartial)
{
DataTable objDataTable = objDataReader.GetSchemaTable();
foreach (DataRow dr in objDataTable.Rows)
{
String column = dr.ItemArray[0].ToString();
switch (column)
{
case "AdminUserId":
if (!Convert.IsDBNull(objDataReader["AdminUserId"]))
{
objAdminUserPartial.AdminUserId = Convert.ToByte(objDataReader["AdminUserId"]);
}
break;
case "AdminUsername":
if (!Convert.IsDBNull(objDataReader["AdminUsername"]))
{
objAdminUserPartial.AdminUsername = objDataReader["AdminUsername"].ToString();
}
break;
case "UserRole":
if (!Convert.IsDBNull(objDataReader["UserRole"]))
{
objAdminUserPartial.UserRole = Convert.ToByte(objDataReader["UserRole"].ToString());
}
break;
case "UserRoleName":
if (!Convert.IsDBNull(objDataReader["UserRoleName"]))
{
objAdminUserPartial.UserRoleName = objDataReader["UserRoleName"].ToString();
}
break;
case "EmailAddress":
if (!Convert.IsDBNull(objDataReader["EmailAddress"]))
{
objAdminUserPartial.EmailAddress = objDataReader["EmailAddress"].ToString();
}
break;
case "MaxCompany":
if (!Convert.IsDBNull(objDataReader["MaxCompany"]))
{
objAdminUserPartial.MaxCompany = Convert.ToByte(objDataReader["MaxCompany"].ToString());
}
break;
case "MaxBranch":
if (!Convert.IsDBNull(objDataReader["MaxBranch"]))
{
objAdminUserPartial.MaxBranch = Convert.ToByte(objDataReader["MaxBranch"].ToString());
}
break;
case "IsActive":
if (!Convert.IsDBNull(objDataReader["IsActive"]))
{
objAdminUserPartial.IsActive = Convert.ToBoolean(objDataReader["IsActive"].ToString());
}
break;
case "CreatedBy":
if (!Convert.IsDBNull(objDataReader["CreatedBy"]))
{
objAdminUserPartial.CreatedBy = Convert.ToInt16(objDataReader["CreatedBy"]);
}
break;
case "CreatedDate":
if (!Convert.IsDBNull(objDataReader["CreatedDate"]))
{
objAdminUserPartial.CreatedDate = Convert.ToDateTime(objDataReader["CreatedDate"].ToString());
}
break;
case "UpdatedBy":
if (!Convert.IsDBNull(objDataReader["UpdatedBy"]))
{
objAdminUserPartial.UpdatedBy = Convert.ToInt16(objDataReader["UpdatedBy"].ToString());
}
break;
case "UpdatedDate":
if (!Convert.IsDBNull(objDataReader["UpdatedDate"]))
{
objAdminUserPartial.UpdatedDate = Convert.ToDateTime(objDataReader["UpdatedDate"].ToString());
}
break;
case "SortedBy":
if (!Convert.IsDBNull(objDataReader["SortedBy"]))
{
objAdminUserPartial.SortedBy = Convert.ToByte(objDataReader["SortedBy"].ToString());
}
break;
case "Remarks":
if (!Convert.IsDBNull(objDataReader["Remarks"]))
{
objAdminUserPartial.Remarks = objDataReader["Remarks"].ToString();
}
break;
default:
break;
}
}
}
