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