public static List <StoreCustomMember> GetStoreCustomMemberListByStoreCustomId(int storeCustomId)
{
List <StoreCustomMember> list = new List <StoreCustomMember>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetStoreCustomMemberListByStoreCustomId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@StoreCustomId", DbType.Int32, storeCustomId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
StoreCustomMember storeCustomMember = new StoreCustomMember();
storeCustomMember.StoreCustomMemberId = Convert.ToInt32(dataReader["StoreCustomMemberId"]);
storeCustomMember.StoreCustomId = Convert.ToInt32(dataReader["StoreCustomId"]);
storeCustomMember.EmployeeName = dataReader["EmployeeName"].ToString();
storeCustomMember.RoleName = dataReader["RoleName"].ToString();
storeCustomMember.Email = dataReader["Email"].ToString();
storeCustomMember.ContactNumber = dataReader["ContactNumber"].ToString();
storeCustomMember.Birthday = Convert.ToDateTime(dataReader["Birthday"]);
list.Add(storeCustomMember);
}
}
return(list);
}
public static StoreCustomMember GetStoreCustomMemberByStoreCustomMemberId(int storeCustomMemberId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetStoreCustomMemberByStoreCustomMemberId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@StoreCustomMemberId", DbType.Int32, storeCustomMemberId);
db.AddOutParameter(dbCommand, "@StoreCustomId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@EmployeeName", DbType.String, 100);
db.AddOutParameter(dbCommand, "@RoleName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@Email", DbType.String, 200);
db.AddOutParameter(dbCommand, "@ContactNumber", DbType.String, 50);
db.AddOutParameter(dbCommand, "@Birthday", DbType.DateTime, 8);
db.ExecuteNonQuery(dbCommand);
StoreCustomMember storeCustomMember = new StoreCustomMember();
storeCustomMember.StoreCustomMemberId = storeCustomMemberId;
storeCustomMember.StoreCustomId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StoreCustomId"));
storeCustomMember.EmployeeName = db.GetParameterValue(dbCommand, "EmployeeName").ToString();
storeCustomMember.RoleName = db.GetParameterValue(dbCommand, "RoleName").ToString();
storeCustomMember.Email = db.GetParameterValue(dbCommand, "Email").ToString();
storeCustomMember.ContactNumber = db.GetParameterValue(dbCommand, "ContactNumber").ToString();
storeCustomMember.Birthday = Convert.ToDateTime(db.GetParameterValue(dbCommand, "Birthday"));
return(storeCustomMember);
}