public DataSet GetAllItemTracking(DTO.Item_Tracking Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemTracking"); cmd = AddParameters_ItemTracking(cmd, FlagType.Select, Ob); return((DataSet)SqlHelper.ExecuteStoredProc(cmd)); }
public int DeleteItemtracking(DTO.Item_Tracking Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemTracking"); FlagType flag; flag = FlagType.Delete; cmd = AddParameters_ItemTracking(cmd, FlagType.Delete, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveItemTracking(DTO.Item_Tracking Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemTracking"); FlagType flag; if (Ob.TrackId > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_ItemTracking(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public SqlCommand AddParameters_ItemTracking(SqlCommand cmd, FlagType flag, DTO.Item_Tracking Ob) { cmd.Parameters.Add(new SqlParameter("@FLAG", flag)); cmd.Parameters.Add(new SqlParameter("@TrackingID", Ob.TrackingId)); cmd.Parameters.Add(new SqlParameter("@BookingID", Ob.BookingID)); cmd.Parameters.Add(new SqlParameter("@ItemID", Ob.ItemID)); cmd.Parameters.Add(new SqlParameter("@IsSubItem", Ob.IsSubItem)); cmd.Parameters.Add(new SqlParameter("@SubItemID", Ob.SubItemID)); cmd.Parameters.Add(new SqlParameter("@SubItemItemID", Ob.SubItemItemID)); cmd.Parameters.Add(new SqlParameter("@TrackingStatus", Ob.TrackingStatus)); cmd.Parameters.Add(new SqlParameter("@BarCode", Ob.BarCode)); cmd.Parameters.Add(new SqlParameter("@Active", Ob.Active)); cmd.Parameters.Add(new SqlParameter("@DateCreated", Ob.DateCreated)); cmd.Parameters.Add(new SqlParameter("@DateModified", Ob.DateModified)); cmd.Parameters.Add(new SqlParameter("@CreatedBy", Ob.CreatedBy)); cmd.Parameters.Add(new SqlParameter("@ModifiedBy", Ob.ModiFiedBy)); cmd.Parameters.Add(new SqlParameter("@BranchID", Ob.BranchID)); return(cmd); }
public int SaveItemTracking(DTO.Item_Tracking Ob) { return(DAL.DALFactory.Instance.DAL_ItemTracking.SaveItemTracking(Ob)); }
public int DeleteItemtracking(DTO.Item_Tracking Ob) { return(DAL.DALFactory.Instance.DAL_ItemTracking.DeleteItemtracking(Ob)); }
public DataSet GetAllItemTracking(DTO.Item_Tracking Ob) { return(DAL.DALFactory.Instance.DAL_ItemTracking.GetAllItemTracking(Ob)); }