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)); }