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