public static int SaveProductionPhase(int PID, int MID, float PTime) { int retval = -1; DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); retval = oSqlClientProvider.SaveProductionPhase(PID, MID, PTime); if (retval == 0) { scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { } catch (Exception Exp) { } } return(retval); }
protected virtual bool Load(Enumarations.State MinState) { bool bTemp = false; DataSet oDS; oDS = null; if (this.ID > 0) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); oDS = oSqlClientProvider.GetMachineDetailByMID(this.ID, (int)MinState); if (Utility.CheckDataSetState(oDS) && (Utility.CheckDataTableState(oDS.Tables[0]))) { if (oDS.Tables[0].Rows.Count > 0) { bTemp = LoadMachineFromDataRow(oDS.Tables[0].Rows[0], MinState); } } } catch (Exception Exp) { } finally { } } return(bTemp); }
protected virtual bool Load(int PID) { bool bTemp = false; DataSet oDS; oDS = null; if (this.ID > 0) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); oDS = oSqlClientProvider.GetStockDetailByProductId(PID); if (Utility.CheckDataSetState(oDS) && (Utility.CheckDataTableState(oDS.Tables[0]))) { if (oDS.Tables[0].Rows.Count > 0) { bTemp = LoadOperatorFromDataRow(oDS.Tables[0].Rows[0], MinState); } } } catch (Exception Exp) { } finally { } } return(bTemp); }
public static DataTable GetStateListForDDLWithoutChose() { DataSet oDS = new DataSet(); DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); oDS = oSqlClientProvider.GetStateListForDDLWithoutChose(); return(oDS.Tables[0]); }
public int Save() { int nResult = -1; int nNewUID = -1; DataSet ds = new DataSet(); DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nNewUID = oSqlClientProvider.SaveOrder(this.ID, this.CustomerID, (int)this.OrderStatus, this.DateOfDelivery, this.Products, this.EstimatedTotalProductionTime, this.TotalCost, (int)State, this.UpdateUserID, out nResult); if (nResult == 0) { this.ID = nNewUID; } return(nResult); }
public int Save() { int nResult = -1; int nNewUID = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nNewUID = oSqlClientProvider.SaveProduct(this.ID, this.Name, this.Code, this.ExtraCode1, this.ExtraCode2, this.ExtraCode3, this.ExtraCode4, this.Category.ID, this.Diameter, this.WireDiameter, this.NumberOfForm, this.NumberOfTurns, this.RawMaterialsCharacteristic, this.StraighteningLength, this.Price, this.Weight, this.Picture1, this.Picture2, this.Picture3, this.Picture4, this.TecniquePicture, this.PDFDocument, this.HatveArasi, this.ToplamBoy, this.KancaArasi, this.Ictenice, this.KancaYonu, (int)State, this.UpdateUserID, out nResult); if (nResult == 0) { this.ID = nNewUID; scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public int Save() { int nResult = -1; int nNewUID = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); // nNewUID = oSqlClientProvider.SaveStock(this.ID, this.ProductId, this.ColorId, out nResult); if (nResult == 0) { this.ID = nNewUID; scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public int Save() { int nResult = -1; int nNewUID = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nNewUID = oSqlClientProvider.SaveCustomer(this.ID, this.Name, this.Country, this.City, this.Email, this.Address, (int)this.State, this.UpdateUserID, out nResult); if (nResult == 0) { this.ID = nNewUID; scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public int Save() { int nResult = -1; int nNewUID = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nNewUID = oSqlClientProvider.SaveRawMaterials(this.ID, this.WireDiameter, this.Hardness, this.Compound, this.Amount, this.Quality, this.SurfaceCondition, (int)this.State, this.UpdateUserID, out nResult); if (nResult == 0) { this.ID = nNewUID; scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public static int UpdateOrderDetailForRawMaterials(int OID, int PID, int IsRawMaterialsUsed, int UsedRawMaterialsAmount, int RawMaterialsID) { int nResult = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nResult = oSqlClientProvider.UpdateOrderDetailForRawMaterials(OID, PID, IsRawMaterialsUsed, UsedRawMaterialsAmount, RawMaterialsID); if (nResult == 0) { scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public static int ChangeOrderProductPaintStatus(int OID, int PID, int Status, int PaintedAmount, int DeliveredAmount) { int nResult = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nResult = oSqlClientProvider.ChangeOrderProductPaintStatus(OID, PID, Status, PaintedAmount, DeliveredAmount); if (nResult == 0) { scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public static int UpdateOrderDetail(int OID, int PID, int OrderCount, int UsedStockCountColored, int UsedStockCountNonColored, int ProductionCount, int CID, string PackageType, int OPStatus, int Operator, int ProductedAmount) { int nResult = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nResult = oSqlClientProvider.UpdateOrderDetail(OID, PID, OrderCount, UsedStockCountColored, UsedStockCountNonColored, ProductionCount, CID, PackageType, OPStatus, Operator, ProductedAmount); if (nResult == 0) { scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }
public static DataSet getOperatorList(string strWhere, int PageIndex, int NumberofRowsRetrieved, string SortColumn, int SortOrder) { DataSet ds = null; try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); ds = oSqlClientProvider.GetOperatorListWithPagingAndSorting(strWhere, PageIndex, NumberofRowsRetrieved, SortColumn, SortOrder); } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } return(ds); }
public static DataSet VerifyPassword(string UName, string UPassword) { DataSet ds = null; try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); ds = oSqlClientProvider.VerifyPassword(UName, UPassword); } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } return(ds); }
public static DataTable GetOpearatorListForDDL() { DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); return(oProvider.GetOperatorListForDDL().Tables[0]); }
public static DataTable GetProductCategoryListForDDL() { DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); return(oProvider.GetProductCategoryListForDDL().Tables[0]); }
public static DataTable GetOrderDetailListByOrderID(int OID) { DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); return(oProvider.GetOrderDetailListByOrderID(OID).Tables[0]); }
public static DataTable GetRawMaterialsListForDDL() { DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); return(oProvider.GetRawMaterialsListForDDL().Tables[0]); }
public static DataTable CalculateProductionTimeByPIDAndCount(int PID, int Count) { DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); return(oProvider.CalculateProductionTimeByPIDAndCount(PID, Count).Tables[0]); }
public static int SaveOrderDetail(int OID, int PID, int OrderCount, int UsedStockCountColored, int UsedStockCountNonColored, int ProductionCount, int CID, string PackageType, int OPStatus) { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); return(oSqlClientProvider.SaveOrderDetail(OID, PID, OrderCount, UsedStockCountColored, UsedStockCountNonColored, ProductionCount, CID, PackageType, OPStatus)); }
public static int DeleteOrderDetail(int OID) { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); return(oSqlClientProvider.DeleteOrderDetail(OID)); }