public int Update(Stock obj, String Original_ItemCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@StoreID", obj.StockStore.StoreID),
new SqlParameter("@StockType", obj.StockType),
new SqlParameter("@StockMaterialID", obj.StockMaterial.MaterialCode),
new SqlParameter("@StockBasicProduct", obj.StockBasicProduct.BasicProductCode),
new SqlParameter("@StockFinishProduct", obj.StockFinishProduct.FinishProductCode),
new SqlParameter("@StockQty", obj.StockQty),
new SqlParameter("@StockReorderLevel", obj.StockReorderLevel),
new SqlParameter("@StockMinimumQty", obj.StockMinimumQty),
new SqlParameter("@StockMaximumQty", obj.StockMaximumQty),
new SqlParameter("@StockEconomicalQty", obj.StockEconomicalQty),
new SqlParameter("@StockReservedQty", obj.StockReservedQty),
new SqlParameter("@StockStatus", obj.StockStatus),
new SqlParameter("@StockUnitPrice", obj.StockUnitPrice),
new SqlParameter("@Original_StockItemCode", obj.StockUnitPrice)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_Stock_All", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(QCReport obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@QCReportID", obj.QCReportID),
new SqlParameter("@ReportType", obj.ReportType),
new SqlParameter("@RPDBatchID", obj.RPDBatchID),
new SqlParameter("@PRPDBatchID", obj.PRPDBatchID),
new SqlParameter("@ProductionBatchID", obj.ProductionBatchID),
new SqlParameter("@PackingBatchID", obj.PackingBatchID),
new SqlParameter("@AnalyzedBy", obj.AnalyzedBy),
new SqlParameter("@RDQAOfficer", obj.RDQAOfficer),
new SqlParameter("@TestBy", obj.TestBy),
new SqlParameter("@SendBy", obj.SendBy),
new SqlParameter("@SendDate", obj.SendDate),
new SqlParameter("@SampleSize", obj.SampleSize),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@SpecificGravity", obj.SpecificGravity),
new SqlParameter("@Status", obj.Status),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_QCReport_Update", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(BasicProduct objBasicProduct, int DepID, int SectionID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BasicProductCode", objBasicProduct.BasicProductCode),
new SqlParameter("@BasicProductName", objBasicProduct.BasicProductName),
new SqlParameter("@BasicProductDescription", objBasicProduct.BasicProductDescription),
new SqlParameter("@BasicProductSubCatID", objBasicProduct.BasicProductSubCategory.CategoryID),
new SqlParameter("@BasicProductCatID", objBasicProduct.BasicProductCategory.CategoryID),
new SqlParameter("@BasicProductUnitID", objBasicProduct.BasicProductUnit.UnitID),
new SqlParameter("@BasicProductFormID", objBasicProduct.BasicProductForm.FormID),
new SqlParameter("@BasicProductAvgCost", objBasicProduct.BasicProductAVGCost),
new SqlParameter("@BasicProductStatus", objBasicProduct.BasicProductStatus),
new SqlParameter("@BasicProductType", objBasicProduct.BasicProductType),
new SqlParameter("@STDBatchSize", objBasicProduct.STDBatchSize),
new SqlParameter("@DepID", DepID),
new SqlParameter("@SectionID", SectionID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_BasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(BasicProduct objBasicProduct, String OriginalBasicCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BasicProductCode", objBasicProduct.BasicProductCode),
new SqlParameter("@BasicProductName", objBasicProduct.BasicProductName),
new SqlParameter("@BasicProductDescription", objBasicProduct.BasicProductDescription),
new SqlParameter("@BasicProductSubCatID", objBasicProduct.BasicProductSubCategory.CategoryID),
new SqlParameter("@BasicProductCatID", objBasicProduct.BasicProductCategory.CategoryID),
new SqlParameter("@BasicProductUnitID", objBasicProduct.BasicProductUnit.UnitID),
new SqlParameter("@BasicProductFormID", objBasicProduct.BasicProductForm.FormID),
new SqlParameter("@BasicProductFormulaID", objBasicProduct.BasicProductFormula.FormulaID),
new SqlParameter("@BasicProductAvgCost", objBasicProduct.BasicProductAVGCost),
new SqlParameter("@BasicProductStatus", objBasicProduct.BasicProductStatus),
new SqlParameter("@BasicProductType", objBasicProduct.BasicProductType),
new SqlParameter("@Original_BasicProductCode", OriginalBasicCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_BasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(Supplier obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@SupplierType", obj.SupplierType),
new SqlParameter("@SupName", obj.SupplieName),
new SqlParameter("@SupAddress", obj.SupplierAddress),
new SqlParameter("@SupPhone", obj.SupplierPhone),
new SqlParameter("@SupMobile", obj.SupplierMobile),
new SqlParameter("@SubEmail", obj.SupplierEmail),
new SqlParameter("@SupFax", obj.SupplierFax),
new SqlParameter("@SupVat", obj.SupplierVat),
new SqlParameter("@SupVatNumber", obj.SupplierVATNo),
new SqlParameter("@SupContactPerson", obj.SupplierContactPerson),
new SqlParameter("@SupplierStatus", obj.SupplierStatus),
new SqlParameter("@SupplierCode", obj.SupplierNameCode),
new SqlParameter("@Original_SupplierID", obj.SupplierNameCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_Supplier", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(Customer obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@CustomerID", obj.CustomerID),
new SqlParameter("@Name", obj.Name),
new SqlParameter("@Address", obj.Address),
new SqlParameter("@Telephone", obj.Telephone),
new SqlParameter("@ProductType", obj.ProductType),
new SqlParameter("@SalesMethod", obj.SalesMethod),
new SqlParameter("@Territory", obj.Territory),
new SqlParameter("@outParam", SqlDbType.Int, 120)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_Customer", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update_RPD(BatchPackingMR obj, MTN.Status MTNState, MTN.Type MTNType, MTN.ItemType MTNItemType, string EnteredBy)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchID", obj.BatchID),
new SqlParameter("@BatchUsed", obj.BatchUsed),
new SqlParameter("@BatchDamaged", obj.BatchDamaged),
new SqlParameter("@BatchReturned", obj.BatchReturned),
new SqlParameter("@State", obj.State),
new SqlParameter("@MTNStatus", Convert.ToInt32(MTNState)),
new SqlParameter("@MTNType", Convert.ToInt32(MTNType)),
new SqlParameter("@MTNItemType", Convert.ToInt32(MTNItemType)),
new SqlParameter("@EnteredBy", EnteredBy),
new SqlParameter("@IssuedBy", Convert.ToInt32(MTNType)),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@ID", obj.ID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_BatchPackingMR_RPD", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(Supplier obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@SupplierType", obj.SupplierType),
new SqlParameter("@SupName", obj.SupplieName),
new SqlParameter("@SupAddress", obj.SupplierAddress),
new SqlParameter("@SupPhone", obj.SupplierPhone),
new SqlParameter("@SupMobile", obj.SupplierMobile),
new SqlParameter("@SupEmail", obj.SupplierEmail),
new SqlParameter("@SupFax", obj.SupplierFax),
new SqlParameter("@SupVat", obj.SupplierVat),
new SqlParameter("@SupVatNumber", obj.SupplierVATNo),
new SqlParameter("@SupContactPerson", obj.SupplierContactPerson),
new SqlParameter("@SupplierStatus", obj.SupplierStatus),
new SqlParameter("@SupplierCode", obj.SupplierNameCode),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_Supplier", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add_For_GeneralAct(PRPDBatchActivityDetails obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchBatchActID", obj.PRPDBatchActivity),
new SqlParameter("@SubActivity", obj.SubActivity),
new SqlParameter("@ActivityDate", obj.ActivityDate),
new SqlParameter("@StartTime", obj.StartTime),
new SqlParameter("@StopTime", obj.StopTime),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@StopQty", obj.StopQty),
new SqlParameter("@SupervisedBy", obj.SupervisedBy),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@PRPDBatchActDetailsID", obj.PRPDBatchActDetailsID)};
return Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchActivityDetailsGen", paramList);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int AddActWithMachine(PRPDBatchActivityDetails obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchBatchActID", obj.PRPDBatchActivity),
new SqlParameter("@SubActivity", obj.SubActivity),
new SqlParameter("@ActivityDate", obj.ActivityDate),
new SqlParameter("@StartTime", obj.StartTime),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@SupervisedBy", obj.SupervisedBy),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@NoOfTrays", obj.NoOfTrays),
new SqlParameter("@WeightLoss", obj.WeightLoss),
new SqlParameter("@ID", obj.PRPDBatchActDetailsID)};
return Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchActivityDetails", paramList);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(PRPDBatchActivityDetails obj, long Original_PRPDBatchActDetailsID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchBatchActID", obj.PRPDBatchActivity),
new SqlParameter("@SubActivity", obj.SubActivity),
new SqlParameter("@ActivityDate", obj.ActivityDate),
new SqlParameter("@StartTime", obj.StartTime),
new SqlParameter("@StopTime", obj.StopTime),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@StopQty", obj.StopQty),
new SqlParameter("@SupervisedBy", obj.SupervisedBy),
new SqlParameter("@Remarks",obj.Remarks),
new SqlParameter("@Original_PRPDBatchActDetailsID", obj.PRPDBatchActDetailsID)};
return Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDBatchActivityDetails", paramList);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(RPDBatch obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@RPDBatchID", obj.RPDBatchID),
new SqlParameter("@RPDBatchSuperviserID", obj.RPDBatchSupervisedBy),
new SqlParameter("@RPDBatchMaterialCode", obj.RPDBatchMaterial),
new SqlParameter("@RPDBatchQty", obj.RPDBatchQty),
new SqlParameter("@RPDBatchInstructedBy", obj.RPDBatchInstructedBy),
new SqlParameter("@RPDBatchInstructedDate", obj.RPDBatchInstructedDate),
new SqlParameter("@RPDBatchStartDate", obj.RPDBatchStartDate),
new SqlParameter("@RPDBatchEndDate", obj.RPDBatchEndDate),
new SqlParameter("@RPDBatchFinalQty", obj.RPDBatchFinalQty),
new SqlParameter("@RPDBatchStatus", obj.Status),
new SqlParameter("@RPDBatchMRNO", obj.RPDBatchMR),
new SqlParameter("@RPDBatchType", obj.Type),
new SqlParameter("@RPDBatchApprovedBy", obj.ApprovedBy),
new SqlParameter("@RPDBatchApprovedDate", obj.ApprovedDate),
new SqlParameter("@RPDBatchEndBy", obj.EndBy)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_RPDBatch", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(Machine obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MachineCode", obj.MachineCode),
new SqlParameter("@MachineName", obj.MachineName),
new SqlParameter("@MachineSupplierID", obj.MachineSupplier),
new SqlParameter("@MachineTypeID", obj.MachineType.MachineTypeID),
new SqlParameter("@MachineDescription", obj.MachineDescription),
new SqlParameter("@MachinHourCost", obj.MachineHourCost),
new SqlParameter("@MachineCapacity", obj.MachineCapacity),
new SqlParameter("@MachineCapacityUnitID", obj.MachineCapacityUnit.UnitID),
new SqlParameter("@MachineValue", obj.MachineValue),
new SqlParameter("@MachinePurchaseDate", obj.MachinePurchaseDate),
new SqlParameter("@MachineTransferDetails", obj.MachineTransferDetails),
new SqlParameter("@MachinePropertyTag", obj.MachinePropertyTag),
new SqlParameter("@MachineBranch", obj.MachineBranch),
new SqlParameter("@MachineWastage", obj.MachineWastage)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_Machine", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(MTN obj, long OriginalMTNNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNBatchID", obj.MTNBatch),
new SqlParameter("@MTNDate", obj.MTNDate),
new SqlParameter("@MTNApprovedBy", obj.MTNApprovedBy.EmployeeID),
new SqlParameter("@MTNApproveDate", obj.MTNApprovedDate),
new SqlParameter("@MTNEnterdBy", obj.MTNEnterdBy.EmployeeID),
new SqlParameter("@MTNFromDepID", obj.MTNDepartmentFrom.DepID),
new SqlParameter("@MTNToDepID", obj.MTNDepartmentTo.DepID),
new SqlParameter("@MTNReceivedBy", obj.MTNReceivedBy.EmployeeID),
new SqlParameter("@MTNReceivedDate", obj.MTNReceivedDate),
new SqlParameter("@MTNStatus", obj.MTNStatus),
new SqlParameter("@MTNType", obj.MTNType),
new SqlParameter("@MTNItemType", obj.MTNItemType),
new SqlParameter("@MTNStore", obj.MTNStore.StoreID),
new SqlParameter("@Original_MTNNO", OriginalMTNNO)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_MR", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(PRPDBatchQTR obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchID", obj.PRPDBatchID),
new SqlParameter("@SandContent", obj.SandContent),
new SqlParameter("@ForiegnMatter", obj.ForiegnMatter),
new SqlParameter("@MoistureContent", obj.MoistureContent),
new SqlParameter("@AnalyzedBy", obj.AnalyzedBy),
new SqlParameter("@RDQAOfficer", obj.RDQAOfficer),
new SqlParameter("@Date", obj.Date),
new SqlParameter("@SampleSize", obj.SampleSize),
new SqlParameter("@Acceptance", obj.Acceptance),
new SqlParameter("@SandContentState", obj.SandContentState),
new SqlParameter("@ForiegnMatterState", obj.ForiegnMatterState),
new SqlParameter("@MoistureContentState", obj.MoistureContentState),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@Status", obj.Status)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchQTR", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(PRPDCAP obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDCAPID", obj.PRPDCAPID),
new SqlParameter("@CAPMaterial", obj.MaterialCode),
new SqlParameter("@GRNNO", obj.GRNNO),
new SqlParameter("@CAPQty", obj.CAPQty),
new SqlParameter("@Instructions", obj.Instructions),
new SqlParameter("@ReworkQty", obj.ReworkQty),
new SqlParameter("@DisposeQty", obj.DisposeQty),
new SqlParameter("@AcceptQty", obj.AcceptQty),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@EnterdBy", obj.EnteredBy.EmployeeID),
new SqlParameter("@EnterdDate", obj.EnteredDate),
new SqlParameter("@ApprovedBy", obj.ApprovedBy.EmployeeID),
new SqlParameter("@ApprovedDate", obj.ApprovedDate),
new SqlParameter("@TestedBy", obj.TestedBy.EmployeeID),
new SqlParameter("@TestDate", obj.TestedDate),
new SqlParameter("@CAPStatus", obj.Status),
new SqlParameter("@ReworkMTN", obj.ReworkMTN),
new SqlParameter("@DisposeMTN", obj.DisposeMTN)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDCAP", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(MR obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRStore", obj.MRStore.StoreID),
new SqlParameter("@MRDate", obj.MRDate),
new SqlParameter("@MRApprovedBy", obj.MRApprovedBy),
new SqlParameter("@MRApproveDate", obj.MRApprovedDate),
new SqlParameter("@MREnterdBy", obj.MREnterdBy),
new SqlParameter("@MRFromDepId", obj.MRDepartmentFrom.DepID),
new SqlParameter("@MRIssuedBy", obj.MRIssuedBy),
new SqlParameter("@MRIssuedDate", obj.MRIssuedDate),
new SqlParameter("@MRReceivedBy", obj.MRReceivedBy),
new SqlParameter("@MRReceivedDate", obj.MRReceivedDate),
new SqlParameter("@MRRemarks", obj.MRRemarks),
new SqlParameter("@MRStatus", obj.MRStatus),
new SqlParameter("@MRType", obj.MRType),
new SqlParameter("@Original_MRNO", obj.MRNO)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MR", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(ProjectMaterials Obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ProjectID", Obj.ProjectID),
new SqlParameter("@ItemCode", Obj.MaterialID),
new SqlParameter("@UsedQty", Obj.UsedQty),
new SqlParameter("@DamagedQty", Obj.DamagedQty),
new SqlParameter("@UnitPrice", Obj.UnitPrice),
new SqlParameter("@EnteredBy", Obj.EnteredBy),
new SqlParameter("@ItemTypeName", Obj.ItemTypeName),
new SqlParameter("@outParam", SqlDbType.Int, 120)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_ProjectMaterials", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(Material obj, String OriginalCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MaterialCode", obj.MaterialCode),
new SqlParameter("@MaterialDescription", obj.MaterialDescription),
new SqlParameter("@MatMainType", obj.MaterialMainType),
new SqlParameter("@MatTypeID", obj.MateialType.MatType),
new SqlParameter("@ItemFormID", obj.MatForm.FormID),
new SqlParameter("@UnitID", obj.MatUnit.UnitID),
new SqlParameter("@AVGCost", obj.MatCost),
new SqlParameter("@Seasanal", obj.IsSeasanal),
new SqlParameter("@Local", obj.IsLocal),
new SqlParameter("@Export", obj.IsExport),
new SqlParameter("@SeasanFrom", obj.MatSeasonFrom),
new SqlParameter("@SeasanTo", obj.MatSeasonTo),
new SqlParameter("@BasicMaterialCode", obj.MatBasicMaterial),
new SqlParameter("@BasicQty", obj.MatBasicQty),
new SqlParameter("@ParticalSize", obj.MatParticleSize),
new SqlParameter("@Status", obj.MaterialStatus),
new SqlParameter("@MaterialType", obj.MaterialType),
new SqlParameter("@MatCatID", obj.MaterialCategory),
new SqlParameter("@Original_MaterialCode", OriginalCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_Material", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(FinishProduct objFinishProduct, String OriginalCode)
{
try
{
if (objFinishProduct.FinishProductFormula == null)
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@BasicProductCode", objFinishProduct.BasicProduct.BasicProductCode),
new SqlParameter("@FinishProdutFormulaID", null),
new SqlParameter("@FinishProdutPackingTypeID", objFinishProduct.FinishProductPackingType.PackingID),
new SqlParameter("@FinishProdutDescription", objFinishProduct.FinishProductDescription),
new SqlParameter("@FinishProdutBasicQty", objFinishProduct.BasicProductQty),
new SqlParameter("@FinishProdutAvgCost", objFinishProduct.FinishProductAvgCost),
new SqlParameter("@FinishProdutStatus", objFinishProduct.FinishProductStatus),
new SqlParameter("@PrimaryFinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@PrimaryFinishProductQty", objFinishProduct.PrimaryFinishProductQty),
new SqlParameter("@FinishProductType", objFinishProduct.FinishProductType),
new SqlParameter("@SKUID", objFinishProduct.SKUID),
new SqlParameter("@Original_FinishProductCode", OriginalCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_FinishProduct", paramList));
}
else
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FinishProdutCode", objFinishProduct.FinishProductCode),
new SqlParameter("@BasicProductCode", objFinishProduct.BasicProduct.BasicProductCode),
new SqlParameter("@FinishProdutFormulaID", objFinishProduct.FinishProductFormula.FormulaID),
new SqlParameter("@FinishProdutPackingTypeID", objFinishProduct.FinishProductPackingType.PackingID),
new SqlParameter("@FinishProdutDescription", objFinishProduct.FinishProductDescription),
new SqlParameter("@FinishProdutBasicQty", objFinishProduct.BasicProductQty),
new SqlParameter("@FinishProdutAvgCost", objFinishProduct.FinishProductAvgCost),
new SqlParameter("@FinishProdutStatus", objFinishProduct.FinishProductStatus),
new SqlParameter("@PrimaryFinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@PrimaryFinishProductQty", objFinishProduct.PrimaryFinishProductQty),
new SqlParameter("@FinishProductType", objFinishProduct.FinishProductType),
new SqlParameter("@SKUID", objFinishProduct.SKUID),
new SqlParameter("@Original_FinishProductCode", OriginalCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_FinishProduct", paramList));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(String FinishProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_FinishProductCode", FinishProductCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_FinishProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(String ProductSubCategoryID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_ProductSubCatID", ProductSubCategoryID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_ProductSubCategory", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(long ID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_RPDPackDetails", ID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_RPDBatchActPackingDetails", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int GetNotFinishedCount(long BatchActivityDetailsID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchActID", BatchActivityDetailsID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPGET_RPDActivityDetailsMachine_Count_NotFinished", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(long UserAccesRolesID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_UserRoleID", UserAccesRolesID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_Unit", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(long GRNNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_GRNNO", GRNNO)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_GRN", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(PRPDCAP obj, long Original_PRPDCAPID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_PRPDCAPID", Original_PRPDCAPID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDCAP", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(MachineType obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MachineType", obj.MachineTypeTitle)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_MachineType", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(long MachineTypeID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_MachineTypeID", MachineTypeID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_MachineType", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Delete(long ID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ID", ID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_DeliverNoteMaterials", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}