public static List <StoreCustom> GetStoreCustomListByFilter(string searchValue, int companyId)
{
List <StoreCustom> list = new List <StoreCustom>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetStoreCustomListByFilter";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue);
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
StoreCustom storeCustom = new StoreCustom();
storeCustom.StoreCustomId = Convert.ToInt32(dataReader["StoreCustomId"]);
storeCustom.CustomDescription = dataReader["CustomDescription"].ToString();
storeCustom.CustomStoreId = Convert.ToInt32(dataReader["CustomStoreId"]);
storeCustom.StoreId = Convert.ToInt32(dataReader["StoreId"]);
storeCustom.SPARStoreId = Convert.ToInt32(dataReader["SPARStoreId"]);
storeCustom.Address = dataReader["Address"].ToString();
storeCustom.GPS = dataReader["GPS"].ToString();
storeCustom.ContactNumber = dataReader["ContactNumber"].ToString();
storeCustom.GroupStore = Convert.ToInt32(dataReader["GroupStore"]);
storeCustom.CatmanStore = Convert.ToInt32(dataReader["CatmanStore"]);
storeCustom.Attachment = dataReader["Attachment"].ToString();
storeCustom.Comment = dataReader["Comment"].ToString();
list.Add(storeCustom);
}
}
return(list);
}
public static StoreCustom GetStoreCustomByStoreId(int storeId, int companyId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetStoreCustomByStoreId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@StoreId", DbType.Int32, storeId);
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId);
db.AddOutParameter(dbCommand, "@StoreCustomId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@CustomDescription", DbType.String, 50);
db.AddOutParameter(dbCommand, "@CustomStoreId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@SPARStoreId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Address", DbType.String, 2000);
db.AddOutParameter(dbCommand, "@GPS", DbType.String, 200);
db.AddOutParameter(dbCommand, "@ContactPerson", DbType.String, 200);
db.AddOutParameter(dbCommand, "@ContactNumber", DbType.String, 50);
db.AddOutParameter(dbCommand, "@GroupStore", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@StoreGroupId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@CatmanStore", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Attachment", DbType.String, 1000);
db.AddOutParameter(dbCommand, "@Comment", DbType.String, 4000);
db.AddOutParameter(dbCommand, "@Email", DbType.String, 200);
db.ExecuteNonQuery(dbCommand);
StoreCustom storeCustom = new StoreCustom();
storeCustom.StoreId = storeId;
storeCustom.StoreCustomId = Convert.ToInt32(db.GetParameterValue(dbCommand, "storeCustomId"));
storeCustom.CustomDescription = db.GetParameterValue(dbCommand, "CustomDescription").ToString();
storeCustom.CustomStoreId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CustomStoreId"));
storeCustom.SPARStoreId = Convert.ToInt32(db.GetParameterValue(dbCommand, "SPARStoreId"));
storeCustom.Address = db.GetParameterValue(dbCommand, "Address").ToString();
storeCustom.GPS = db.GetParameterValue(dbCommand, "GPS").ToString();
storeCustom.ContactPerson = db.GetParameterValue(dbCommand, "ContactPerson").ToString();
storeCustom.ContactNumber = db.GetParameterValue(dbCommand, "ContactNumber").ToString();
storeCustom.GroupStore = Convert.ToInt32(db.GetParameterValue(dbCommand, "GroupStore"));
storeCustom.StoreGroupId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StoreGroupId"));
storeCustom.CatmanStore = Convert.ToInt32(db.GetParameterValue(dbCommand, "CatmanStore"));
storeCustom.Attachment = db.GetParameterValue(dbCommand, "Attachment").ToString();
storeCustom.Comment = db.GetParameterValue(dbCommand, "Comment").ToString();
storeCustom.Email = db.GetParameterValue(dbCommand, "Email").ToString();
return(storeCustom);
}
