public int CreateBasicProductTransfer_Semi_toRPD(MTN obj, Batch.Status NextStatus, string BasicProductCode, decimal BasicQty) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNBatchID", obj.MTNBatch), 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("@BasicProductCode", BasicProductCode), new SqlParameter("@Qty", BasicQty), new SqlParameter("@NextBatchStatus", Convert.ToInt32(NextStatus)), new SqlParameter("@outParam", SqlDbType.Int) { Direction = ParameterDirection.Output } }; return(Execute.RunSP_Output(Connection, "SPADD_MTN_BasicProductTransfer_Semi", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public void LoadBatches(Batch.Status Status) { try { dtBatchList = objBatchDL.Get_DataView(Status, CurrentUser.UserID); if (dtBatchList.Rows.Count > 0) { gvBatchList.AutoGenerateColumns = false; bindBatch.DataSource = dtBatchList; gvBatchList.DataSource = bindBatch; bindBatch.ResetBindings(true); } else { gvBatchList.AutoGenerateColumns = false; bindBatch.DataSource = null; gvBatchList.DataSource = bindBatch; bindBatch.ResetBindings(true); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void LoadBatches(Batch.Status Status) { try { bindBatch.DataSource = objBatchDL.Get_DataView(Status, CurrentUser.UserID); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataTable Get_DataView(Batch.Status Status, long UserID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Status", Status), new SqlParameter("@UserID", UserID) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_DataView_Rework(Batch.Status Status, string BatchType1, string BatchType2) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchStatus", Status), new SqlParameter("@BatchType1", BatchType1), new SqlParameter("@BatchType2", BatchType2) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_ReworkBatchList", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update_QCStatus(string BatchID, string ChangedBy, Batch.Status TheStatus) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", BatchID), new SqlParameter("@ChangedBy", ChangedBy), new SqlParameter("@BatchStatus", Convert.ToInt32(TheStatus)) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_Batch_QCStatus", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_DataView_FinishPrimaryPacking(Batch.Status Status, long UserID, int BatchActivity_Finished, string ActType) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Status", Status), new SqlParameter("@UserID", UserID), new SqlParameter("@BatchActivity_Finished", BatchActivity_Finished), new SqlParameter("@ActType", ActType) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_FinishPrimaryPacking", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_DataView_Packing(Batch.Status Status1, Batch.Status Status2, long UserID, string BasicProductType) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Status1", Status1), new SqlParameter("@Status2", Status2), new SqlParameter("@UserID", UserID), new SqlParameter("@BasicProductType", BasicProductType) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_Packing", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_DataView_Admin(Batch.Status Status1, Batch.Status Status2, Batch.Status Status3, Batch.Status Status4, Batch.Status Status5) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Status1", (int)Status1), new SqlParameter("@Status2", (int)Status2), new SqlParameter("@Status3", (int)Status3), new SqlParameter("@Status4", (int)Status4), new SqlParameter("@Status5", (int)Status5) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_Admin", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public DataTable Get_DataView_PrimaryPacking_Edit(Batch.Status Status1, Batch.Status Status2, long UserID, string BasicProductType, string ActType, int BatchActivity_Initial, int BatchActivity_Start, int BatchActivity_Finish) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Status1", Status1), new SqlParameter("@Status2", Status2), new SqlParameter("@UserID", UserID), new SqlParameter("@BasicProductType", BasicProductType), new SqlParameter("@ActType", ActType), new SqlParameter("@BatchActivity_Initial", BatchActivity_Initial), new SqlParameter("@BatchActivity_Start", BatchActivity_Start), new SqlParameter("@BatchActivity_Finish", BatchActivity_Finish) }; return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_PrimaryPacking_Edit", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }