public long Add(BatchActivity objBatchActivity) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchActivity.BatchActID), new SqlParameter("@BatchID", objBatchActivity.Batch.BatchID), new SqlParameter("@ActID", objBatchActivity.MainActivity.MainActID), new SqlParameter("@BatchActStatus", Convert.ToInt32(objBatchActivity.BatchActStatus)), new SqlParameter("@SequenceNo", objBatchActivity.SequenceNo), new SqlParameter("@Part", objBatchActivity.Part), new SqlParameter("@ActType", objBatchActivity.ActType), new SqlParameter("@BlockNextActivity", objBatchActivity.BlockNextActivity), new SqlParameter("@ActMethod", objBatchActivity.ActMethod), new SqlParameter("@outParam", SqlDbType.Int) { Direction = ParameterDirection.Output } }; return(Execute.RunSP_Int(Connection, "SPADD_BatchActivity_Update", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Decimal UnitPrice(String PRPDBatchID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDBatchID", PRPDBatchID) }; return(Execute.RunSP_Int(Connection, "SPGET_PRPDBatch_UnitPrice", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Get_ReorderLevel_Below_Count(String EmpID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@EmpID", EmpID) }; return(Execute.RunSP_Int(Connection, "SPGET_STOCK_BELOW_REORDER_COUNT_By_Storekeeper", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Delete(int LabourRecID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@LabourRecID", LabourRecID) }; return(Execute.RunSP_Int(Connection, "SPDELETE_BatchLaourDetails", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Delete(string STDBatchID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_STDBatchID", STDBatchID) }; return(Execute.RunSP_Int(Connection, "SPDELETE_STDBatch", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Delete(String CustomerID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@CustomerID", CustomerID) }; return(Execute.RunSP_Int(Connection, "SPDELETE_Customer", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int GET_Issue_Count(String EmpID, MR.Status Status) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@EmpID", EmpID), new SqlParameter("@MRStatus", Status) }; return(Execute.RunSP_Int(Connection, "SPGET_MR_CHECKED_Approval", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int GetSemiFinishedRequisitionStatus_ByPart(String BatchID, string Part) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", BatchID), new SqlParameter("@PartID", Part) }; return(Execute.RunSP_Int(Connection, "SPGET_BatchBySemiFinishedRequisitionState", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Decimal GetIssuedQuantity(long MRNO, String Item) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO), new SqlParameter("@Item", Item) }; return(Execute.RunSP_Int(Connection, "SPGET_MRItemIssuedQty", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Decimal GetReworkQty(long MTNNO, String MaterialCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", MTNNO), new SqlParameter("@MaterialCode", MaterialCode) }; return(Execute.RunSP_Int(Connection, "SPGET_PRPDBatch_RewokedQty", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Update_Initial(BatchActivity objBatchActivity) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchActivity.BatchActID), new SqlParameter("@StartQty", objBatchActivity.StartQty), new SqlParameter("@EndProductCode", objBatchActivity.EndProductCode), }; return(Execute.RunSP_Int(Connection, "SPUPDATE_BatchActivity_Initial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Delete(String Original_MaterialCode, String @Original_BatchID, String Part) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MaterialCode", Original_MaterialCode), new SqlParameter("@BatchID", @Original_BatchID), new SqlParameter("@Part", Part) }; return(Execute.RunSP_Int(Connection, "SPDELETE_BatchFormulaMaterial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update_Weigh(string BatchID, string Part, string WeighBy) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", BatchID), new SqlParameter("@Part", Part), new SqlParameter("@WeighBy", WeighBy), }; return(Execute.RunSP_Int(Connection, "SPUPDATE_BatchFormulaMaterial_WeighAll", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Get_StockByStore(String StoreID, String FinishProductCode, Decimal IssuedQty) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@StoreID", StoreID), new SqlParameter("@MRItemCode", FinishProductCode), new SqlParameter("@IssuedQty", IssuedQty) }; return(Execute.RunSP_Int(Connection, "SPGET_MRFinishProduct_StockByStoreID", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Add(BatchMachineDetails objBatchMachineDetails) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchMachineDetails.BatchAct.BatchActID), new SqlParameter("@MachineID", objBatchMachineDetails.TheMachine.MachineCode), new SqlParameter("@MachineStart", objBatchMachineDetails.StartTime), new SqlParameter("@MachineStop", objBatchMachineDetails.StopTime) }; return(Execute.RunSP_Int(Connection, "SPADD_BatchMachineDetails", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Update(BatchActivity objBatchActivity) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchActivity.BatchActID), new SqlParameter("@StopQty", objBatchActivity.StopQty), new SqlParameter("@BatchActStatus", Convert.ToInt32(objBatchActivity.BatchActStatus)), new SqlParameter("@ActMethod", objBatchActivity.ActMethod), }; return(Execute.RunSP_Int(Connection, "SPUPDATE_BatchActivity", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update_BulkPrinted(long GRNNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@GRNNO", GRNNO) }; int x = Execute.RunSP_Int(Connection, "SPUPDATE_GRN_GRNBulkPrint", paramList); return(x); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Add_QCFail(string BatchID, string InstructedBy, long MainActID, string Part) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", BatchID), new SqlParameter("@InstructedBy", InstructedBy), new SqlParameter("@MainActID", MainActID), new SqlParameter("@Part", Part) }; return(Execute.RunSP_Int(Connection, "SPADD_BatchActivity_QCFail", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Issue(MRFinishProduct obj, String StoreID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRItemCode", obj.FinishProduct.FinishProductCode), new SqlParameter("@StoreID", StoreID), new SqlParameter("@MRIssuedQty", obj.IssuedQty) }; return(Execute.RunSP_Int(Connection, "SPUPDATE_MRFinishProduct_Issue", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Add_Secondary(BatchLabourDetails objBatchLabourDetails) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchLabourDetails.BatchAct.BatchActID), new SqlParameter("@EmployeeID", objBatchLabourDetails.Emp.EmployeeID), new SqlParameter("@WorkStart", objBatchLabourDetails.WorkStart), new SqlParameter("@WorkStop", objBatchLabourDetails.WorkStop), new SqlParameter("@OTHours", objBatchLabourDetails.OTHours) }; return(Execute.RunSP_Int(Connection, "SPADD_BatchLabourDetails_Secondary", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(BatchFormulaBasicProducts obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BasicProductCode", obj.BasicProductCode), new SqlParameter("@Qty", obj.Qty), new SqlParameter("@BatchID", obj.BatchID), new SqlParameter("@Part", obj.Part), new SqlParameter("@AddedBy", obj.AddedBy), new SqlParameter("@Remarks", obj.Remarks) }; return(Execute.RunSP_Int(Connection, "SPUPDATE_BatchFormulaBasicProducts", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(PRPDActivityDetailsLabour obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", obj.PRPDBatchActivityDetails), new SqlParameter("@Helper", obj.Helper.EmployeeID), new SqlParameter("@StartTime", obj.StartTime), new SqlParameter("@StopTime", obj.StopTime), new SqlParameter("@OTHours", obj.OTHours), new SqlParameter("@Remarks", obj.Remarks) }; return(Execute.RunSP_Int(Connection, "SPADD_PRPDActivityDetailsLabour", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add_Re(string BatchID, string ParentBatches, decimal BatchSize, string CreatedBy, int BatchStatus, string BatchType) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", BatchID), new SqlParameter("@ParentBatches", ParentBatches), new SqlParameter("@BatchGeneratedBy", CreatedBy), new SqlParameter("@BatchStatus", BatchStatus), new SqlParameter("@BatchSize", BatchSize), new SqlParameter("@BatchType", BatchType) }; return(Execute.RunSP_Int(Connection, "SPADD_Batch_Re", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(PRPDActivityDetailsMachine obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", obj.PRPDBatchActDetailsID), new SqlParameter("@MachineCode", obj.MachineCode), new SqlParameter("@MeshSize", obj.MeshSize), new SqlParameter("@StartTime", obj.StartTime), new SqlParameter("@StopTime", obj.StopTime), new SqlParameter("@Remarks", obj.Remarks) }; return(Execute.RunSP_Int(Connection, "SPADD_PRPDActivityDetailsMachine", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(BatchFormulaMaterial obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MaterialCode", obj.MaterialCode), new SqlParameter("@BatchID", obj.BatchID), new SqlParameter("@Qty", obj.Qty), new SqlParameter("@Part", obj.Part), new SqlParameter("@Type", obj.Type), new SqlParameter("@AddedBy", obj.AddedBy), new SqlParameter("@Remarks", obj.Remarks), new SqlParameter("@Status", obj.Status), }; return(Execute.RunSP_Int(Connection, "SPADD_BatchFormulaMaterial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }