public int CreatePackingMTN_Secondary_toStores(MTN obj, BatchActivity.Status Status, string FinishProductCode, int Qty, BatchActivity.Status BatchActStatus_Finished, BatchActivity.Status BatchActStatus_Secondary) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNPackingBatch", obj.PackingBatch), new SqlParameter("@MTNEnterdBy", obj.MTNEnterdBy.EmployeeID), new SqlParameter("@MTNToDepID", obj.MTNDepartmentTo.DepID), new SqlParameter("@MTNStatus", obj.MTNStatus), new SqlParameter("@MTNType", obj.MTNType), new SqlParameter("@MTNItemType", obj.MTNItemType), new SqlParameter("@FinishProductCode", FinishProductCode), new SqlParameter("@Qty", Qty), new SqlParameter("@NextBatchActivityStatus", Convert.ToInt32(Status)), new SqlParameter("@BatchActStatus_Finished", Convert.ToInt32(BatchActStatus_Finished)), new SqlParameter("@BatchActStatus_Secondary", Convert.ToInt32(BatchActStatus_Secondary)), new SqlParameter("@outParam", SqlDbType.Int) { Direction = ParameterDirection.Output } }; return(Execute.RunSP_Output(Connection, "SPADD_MTN_Packing_Secondary", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_DataView_Packing_Secondary(BatchActivity.Status Status, long UserID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActStatus", Status), new SqlParameter("@UserID", UserID) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_Packing_Secondary", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_Packing_PrimaryBatchRemainningQty(int PrimaryBatchID, BatchActivity.Status Status_Finished, BatchActivity.Status Status_Secondary) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActStatus_Finished", Status_Finished), new SqlParameter("@BatchActStatus_Secondary", Status_Secondary), new SqlParameter("@PrimaryBatchID", PrimaryBatchID) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Packing_PrimaryBatchRemainningQty", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }