public static MemberRole getFromReader(IDataReader rd) { MemberRole Item = new MemberRole(); Item.ID = (Int32)(rd["MR_ID"]); Item.Username = (String)(rd["MR_Username"]); Item.ROLE_ID = (Int32)(rd["MR_ROLE_ID"]); Item.RowId = (Guid)(rd["MR_RowId"]); Item.NgayTao = (DateTime)(rd["MR_NgayTao"]); Item.NgayCapNhat = (DateTime)(rd["MR_NgayCapNhat"]); Item.NguoiTao = (String)(rd["MR_NguoiTao"]); return(Item); }
public static MemberRole SelectById(Int32 MR_ID) { MemberRole Item = new MemberRole(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("MR_ID", MR_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblMemberRole_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static MemberRole InsertDangKyCaNhan(SqlTransaction tran, int CQ_ID, string Username) { MemberRole Item = new MemberRole(); SqlParameter[] obj = new SqlParameter[2]; obj[0] = new SqlParameter("Username", Username); obj[1] = new SqlParameter("CQ_ID", CQ_ID); using (IDataReader rd = SqlHelper.ExecuteReader(tran, CommandType.StoredProcedure, "sp_tblMemberRole_Insert_InsertDangKyCaNhan_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static MemberRole Insert(MemberRole Inserted) { MemberRole Item = new MemberRole(); SqlParameter[] obj = new SqlParameter[6]; obj[0] = new SqlParameter("MR_Username", Inserted.Username); obj[1] = new SqlParameter("MR_ROLE_ID", Inserted.ROLE_ID); obj[2] = new SqlParameter("MR_RowId", Inserted.RowId); obj[3] = new SqlParameter("MR_NgayTao", Inserted.NgayTao); obj[4] = new SqlParameter("MR_NgayCapNhat", Inserted.NgayCapNhat); obj[5] = new SqlParameter("MR_NguoiTao", Inserted.NguoiTao); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblMemberRole_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static MemberRole Insert(SqlTransaction tran, int ROLE_ID, string Username) { MemberRole Item = new MemberRole(); SqlParameter[] obj = new SqlParameter[6]; obj[0] = new SqlParameter("MR_Username", Username); obj[1] = new SqlParameter("MR_ROLE_ID", ROLE_ID); obj[2] = new SqlParameter("MR_RowId", Guid.NewGuid()); obj[3] = new SqlParameter("MR_NgayTao", DateTime.Now); obj[4] = new SqlParameter("MR_NgayCapNhat", DateTime.Now); obj[5] = new SqlParameter("MR_NguoiTao", Username); using (IDataReader rd = SqlHelper.ExecuteReader(tran, CommandType.StoredProcedure, "sp_tblMemberRole_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }