public void GetSingleQueryUpdate(MsUserRole item, ref List <SqlCommand> ArraySQLCmd) { MsUserRole itm = item; DALInfo.AssignedInfo(ref itm); UpdateQuery(itm, ArraySQLCmd); }
private List <MsUserRole> MoveDataToCollection(SqlDataReader MyReader, Boolean isCustom = false) { List <MsUserRole> msUserRoleList = new List <MsUserRole>(); while (MyReader.Read()) { MsUserRole objMsUserRole = new MsUserRole(); objMsUserRole.ModuleID = MyReader["moduleid"].ToString().Trim(); objMsUserRole.UserRoleID = MyReader["userroleid"].ToString().Trim(); objMsUserRole.UserRoleDesc = MyReader["userroledesc"].ToString().Trim(); objMsUserRole.CrtUsrID = MyReader["crtusrid"].ToString().Trim(); objMsUserRole.TsCrt = Mapper <DateTime>(MyReader["tscrt"]); objMsUserRole.ModUsrID = MyReader["modusrid"].ToString().Trim(); objMsUserRole.TsMod = Mapper <DateTime?>(MyReader["tsmod"]); objMsUserRole.ActiveFlag = MyReader["activeflag"].ToString().Trim(); objMsUserRole.RowState = DataRowState.Unchanged; if (isCustom == true) { objMsUserRole.RowNumber = Convert.ToInt64(MyReader["RowNumber"]); objMsUserRole.TotalRecord = Convert.ToInt64(MyReader["TotalRecord"]); } msUserRoleList.Add(objMsUserRole); } return(msUserRoleList); }
public void GetBatchQueryUpdate(List <MsUserRole> objDomain, ref List <SqlCommand> ArraySQLCmd) { foreach (MsUserRole item in objDomain) { MsUserRole itm = item; DALInfo.AssignedInfo(ref itm); UpdateQuery(itm, ArraySQLCmd); } }
public TransactionResult Update(ref MsUserRole item) { List <SqlCommand> ArraySQLCmd = new List <SqlCommand>(); TransactionDB TransDB = new TransactionDB(DALInfo); TransactionResult ObjTransResult = default(TransactionResult); GetSingleQueryUpdate(item, ref ArraySQLCmd); ObjTransResult = TransDB.BatchUpdate(ArraySQLCmd); if (ObjTransResult.Result == 1 && !item.RowState.Equals(DataRowState.Deleted)) { item.RowState = DataRowState.Unchanged; } return(ObjTransResult); }
public List <MsUserRole> MoveDataToCollectionDomain(DataTable dataTable) { List <MsUserRole> msUserRoleList = new List <MsUserRole>(); for (int i = 0; i <= dataTable.Rows.Count - 1; i++) { MsUserRole objMsUserRole = new MsUserRole(); objMsUserRole.ModuleID = dataTable.Rows[i]["moduleid"].ToString(); objMsUserRole.UserRoleID = dataTable.Rows[i]["userroleid"].ToString(); objMsUserRole.UserRoleDesc = dataTable.Rows[i]["userroledesc"].ToString(); objMsUserRole.CrtUsrID = dataTable.Rows[i]["crtusrid"].ToString(); objMsUserRole.TsCrt = Mapper <DateTime>(dataTable.Rows[i]["tscrt"]); objMsUserRole.ModUsrID = dataTable.Rows[i]["modusrid"].ToString(); objMsUserRole.TsMod = Mapper <DateTime?>(dataTable.Rows[i]["tsmod"]); objMsUserRole.ActiveFlag = dataTable.Rows[i]["activeflag"].ToString(); objMsUserRole.RowState = DataRowState.Unchanged; msUserRoleList.Add(objMsUserRole); } return(msUserRoleList); }
public MsUserRole GetMsUserRoleByMsUserRoleID(string UserRoleID) { SqlConnection conn = new SqlConnection(DALInfo.ConnectionString); SqlCommand cmd = new SqlCommand("up_RetrieveMsUserRole", conn); MsUserRole objTbl = new MsUserRole(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserRoleID", UserRoleID); SqlDataReader da = default(SqlDataReader); try { cmd.Connection.Open(); da = cmd.ExecuteReader(); if (da.HasRows) { objTbl = MoveDataToCollection(da)[0]; } else { return(objTbl); } } catch (Exception) { throw; } finally { da.Close(); conn.Close(); cmd.Dispose(); } return(objTbl); }
public void UpdateQuery(MsUserRole item, List <SqlCommand> ArraySQLCmd) { SqlCommand cmd = null; if (item.RowState == DataRowState.Added) { cmd = new SqlCommand("up_InsertMsUserRole"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduleid", SqlDbType.VarChar, 5).Value = item.ModuleID; cmd.Parameters.Add("@userroleid", SqlDbType.VarChar, 20).Value = item.UserRoleID; cmd.Parameters.Add("@userroledesc", SqlDbType.VarChar, 50).Value = item.UserRoleDesc == null ? (object)DBNull.Value : item.UserRoleDesc; cmd.Parameters.Add("@crtusrid", SqlDbType.VarChar, 20).Value = item.CrtUsrID; cmd.Parameters.Add("@modusrid", SqlDbType.VarChar, 20).Value = item.ModUsrID == null ? (object)DBNull.Value : item.ModUsrID; cmd.Parameters.Add("@activeflag", SqlDbType.Char, 1).Value = item.ActiveFlag; } else if (item.RowState == DataRowState.Modified) { cmd = new SqlCommand("up_UpdateMsUserRole"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduleid", SqlDbType.VarChar, 5).Value = item.ModuleID; cmd.Parameters.Add("@userroleid", SqlDbType.VarChar, 20).Value = item.UserRoleID; cmd.Parameters.Add("@userroledesc", SqlDbType.VarChar, 50).Value = item.UserRoleDesc == null ? (object)DBNull.Value : item.UserRoleDesc; cmd.Parameters.Add("@modusrid", SqlDbType.VarChar, 20).Value = item.ModUsrID == null ? (object)DBNull.Value : item.ModUsrID; cmd.Parameters.Add("@activeflag", SqlDbType.Char, 1).Value = item.ActiveFlag; } else if (item.RowState == DataRowState.Deleted) { cmd = new SqlCommand("up_DeleteMsUserRole"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@userroleid", SqlDbType.VarChar, 20).Value = item.UserRoleID; cmd.Parameters.Add("@modusrid", SqlDbType.VarChar, 20).Value = item.ModUsrID == null ? (object)DBNull.Value : item.ModUsrID; } if (cmd != null) { ArraySQLCmd.Add(cmd); } }
public TransactionResult Update(ref MsUserRole item) { return(new MsUserRoleDataAccess(DALInfo).Update(ref item)); }