public string DeleteBrand(DTO.BrandMaster Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "sp_BrandsMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrandID", Ob.BrandID);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 6);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public DataSet BindGridView(DTO.BrandMaster Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_BrandsMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrandName", Ob.BrandName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 4);
ds = PrjClass.GetData(cmd);
return(ds);
}
public string SaveBrandMaster(DTO.BrandMaster Ob)
{
ArrayList date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BranchId);
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_BrandsMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrandName", Ob.BrandName);
cmd.Parameters.AddWithValue("@Active", Ob.Active);
cmd.Parameters.AddWithValue("@DateCreated", date[0].ToString());
cmd.Parameters.AddWithValue("@DateModified", date[0].ToString());
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string SaveBrandMaster(DTO.BrandMaster Ob)
{
return(DAL.DALFactory.Instance.Dal_BrandMaster.SaveBrandMaster(Ob));
}
public string DeleteBrand(DTO.BrandMaster Ob)
{
return(DAL.DALFactory.Instance.Dal_BrandMaster.DeleteBrand(Ob));
}
public DataSet BindGridView(DTO.BrandMaster Ob)
{
return(DAL.DALFactory.Instance.Dal_BrandMaster.BindGridView(Ob));
}