public ActionResult Edit(UserInfoPartial objUserInfoPartial) { bool status = false; if (ModelState.IsValid) { UserInfoPartialBLL objUserInfoPartialBll = new UserInfoPartialBLL(); objUserInfoPartialBll.UpdateUserInfo(objUserInfoPartial); status = true; } return(new JsonResult { Data = new { status = status } }); }
//Get UserInfo by UserId for Edit public UserInfoPartial GetUserInfo(int id) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; UserInfoPartial objUserInfoPartial = new UserInfoPartial(); List <UserInfoPartial> objUserInfoPartialList = new List <UserInfoPartial>(); try { objDbCommand.AddInParameter("UserId", id); objDbCommand.AddInParameter("AdminUserId", SessionUtility.TBSessionContainer.UserID); objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[dbo].[uspGetUserInfo]", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { objUserInfoPartial = new UserInfoPartial(); this.BuildModelForUserInfoPartial(objDbDataReader, objUserInfoPartial); objUserInfoPartialList.Add(objUserInfoPartial); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objUserInfoPartial); }
// Update Specific UserInfo public string UpdateUserInfo(UserInfoPartial objUserInfoPartial) { int noRowCount = 0; objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable); objDbCommand.AddInParameter("UserId", objUserInfoPartial.UserId); objDbCommand.AddInParameter("Username", objUserInfoPartial.Username); objDbCommand.AddInParameter("BranchId", objUserInfoPartial.BranchId); objDbCommand.AddInParameter("IsActive", objUserInfoPartial.IsActive); //updated by which Admin! objDbCommand.AddInParameter("UpdatedByAdminUserId", SessionUtility.TBSessionContainer.UserID); try { noRowCount = objDataAccess.ExecuteNonQuery(objDbCommand, "[dbo].uspUpdateUserInfo", 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 BuildModelForUserInfoPartial(DbDataReader objDataReader, UserInfoPartial objUserInfoPartial) { DataTable objDataTable = objDataReader.GetSchemaTable(); foreach (DataRow dr in objDataTable.Rows) { String column = dr.ItemArray[0].ToString(); switch (column) { case "UserId": if (!Convert.IsDBNull(objDataReader["UserId"])) { objUserInfoPartial.UserId = Convert.ToByte(objDataReader["UserId"]); } break; case "Username": if (!Convert.IsDBNull(objDataReader["Username"])) { objUserInfoPartial.Username = objDataReader["Username"].ToString(); } break; case "BranchId": if (!Convert.IsDBNull(objDataReader["BranchId"])) { objUserInfoPartial.BranchId = Convert.ToByte(objDataReader["BranchId"].ToString()); } break; case "BranchName": if (!Convert.IsDBNull(objDataReader["BranchName"])) { objUserInfoPartial.BranchName = objDataReader["BranchName"].ToString(); } break; case "IsActive": if (!Convert.IsDBNull(objDataReader["IsActive"])) { objUserInfoPartial.IsActive = Convert.ToBoolean(objDataReader["IsActive"].ToString()); } break; case "CreatedBy": if (!Convert.IsDBNull(objDataReader["CreatedBy"])) { objUserInfoPartial.CreatedBy = Convert.ToInt16(objDataReader["CreatedBy"]); } break; case "CreatedDate": if (!Convert.IsDBNull(objDataReader["CreatedDate"])) { objUserInfoPartial.CreatedDate = Convert.ToDateTime(objDataReader["CreatedDate"].ToString()); } break; case "UpdatedBy": if (!Convert.IsDBNull(objDataReader["UpdatedBy"])) { objUserInfoPartial.UpdatedBy = Convert.ToInt16(objDataReader["UpdatedBy"].ToString()); } break; case "UpdatedDate": if (!Convert.IsDBNull(objDataReader["UpdatedDate"])) { objUserInfoPartial.UpdatedDate = Convert.ToDateTime(objDataReader["UpdatedDate"].ToString()); } break; case "SortedBy": if (!Convert.IsDBNull(objDataReader["SortedBy"])) { objUserInfoPartial.SortedBy = Convert.ToByte(objDataReader["SortedBy"].ToString()); } break; case "Remarks": if (!Convert.IsDBNull(objDataReader["Remarks"])) { objUserInfoPartial.Remarks = objDataReader["Remarks"].ToString(); } break; default: break; } } }