public bool InsertData(string UserID, CustomerData cusData)
{
Boolean ret = true;
CustomerDAL oDAL = new CustomerDAL();
SetDataToDAL(oDAL, cusData);
ret = oDAL.InsertCurrentData(UserID, null);
if (ret == false)
_error = oDAL.ErrorMessage;
return ret;
}
public bool UpdateData(string UserID, CustomerData cusData)
{
Boolean ret = true;
CustomerDAL oDAL = new CustomerDAL();
//double LOID = 0;
//LOID = GetLOID(cusData.CODE);
oDAL.GetDataByLOID(cusData.LOID, null);
SetDataToDAL(oDAL, cusData);
ret = oDAL.UpdateCurrentData(UserID, null);
if (ret == false)
_error = oDAL.ErrorMessage;
return ret;
}
public bool GetCustomerDiscount(double customer, double totalPrice)
{
bool ret = true;
_DISCOUNT = 0;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
CustomerDAL cDAL = new CustomerDAL();
cDAL.GetDataByLOID(customer, obj.zTrans);
if (cDAL.OnDB)
{
if (cDAL.EFDATE.Date <= DateTime.Today && DateTime.Today <= cDAL.EPDATE.Date)
_DISCOUNT = DALObj.GetMemberDiscount(cDAL.MEMBERTYPE, totalPrice, obj.zTrans);
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
public bool DeleteData(ArrayList arrLOID)
{
bool ret = true;
OracleDBObj objDB = new OracleDBObj();
objDB.CreateConnection();
objDB.CreateTransaction();
try
{
foreach (double LOID in arrLOID)
{
CustomerDAL oDAL = new CustomerDAL();
oDAL.GetDataByLOID(LOID, objDB.zTrans);
oDAL.DeleteCurrentData(objDB.zTrans);
}
objDB.zTrans.Commit();
ret = true;
}
catch(Exception ex)
{
objDB.zTrans.Rollback();
_error = ex.Message;
ret = false;
}
objDB.CloseConnection();
return ret;
}
public CustomerData GetCustomerData(double loid)
{
CustomerDAL dal = new CustomerDAL();
CustomerData data = new CustomerData();
dal.GetDataByLOID(loid, null);
data.ACTIVE = dal.ACTIVE;
data.BILLADDRESS = dal.BILLADDRESS;
data.BILLAMPHUR = dal.BILLAMPHUR;
data.BILLEMAIL = dal.BILLEMAIL;
data.BILLFAX = dal.BILLFAX;
data.BILLPROVINCE = dal.BILLPROVINCE;
data.BILLROAD = dal.BILLROAD;
data.BILLTAMBOL = dal.BILLTAMBOL;
data.BILLTEL = dal.BILLTEL;
data.BILLZIPCODE = dal.BILLZIPCODE;
data.CADDRESS = dal.CADDRESS;
data.CAMPHUR = dal.CAMPHUR;
data.CEMAIL = dal.CEMAIL;
data.CFAX = dal.CFAX;
data.CLASTNAME = dal.CLASTNAME;
data.CMOBILE = dal.CMOBILE;
data.CNAME = dal.CNAME;
data.CODE = dal.CODE;
data.CPROVINCE = dal.CPROVINCE;
data.CREDITAMOUNT = dal.CREDITAMOUNT;
data.CREDITDAY = dal.CREDITDAY;
data.CROAD = dal.CROAD;
data.CTAMBOL = dal.CTAMBOL;
data.CTEL = dal.CTEL;
data.CTITLE = dal.CTITLE;
data.CUSTOMERTYPE = dal.CUSTOMERTYPE;
data.CZIPCODE = dal.CZIPCODE;
data.DELIVERTYPE = dal.DELIVERTYPE;
data.EFDATE = dal.EFDATE;
data.EPDATE = dal.EPDATE;
data.IDENTITY = dal.IDENTITY;
data.LASTNAME = dal.LASTNAME;
data.MEMBERTYPE = dal.MEMBERTYPE;
data.NAME = dal.NAME;
data.PAYMENT = dal.PAYMENT;
data.REMARK = dal.REMARK;
data.SENDADDRESS = dal.SENDADDRESS;
data.SENDAMPHUR = dal.SENDAMPHUR;
data.SENDEMAIL = dal.SENDEMAIL;
data.SENDFAX = dal.SENDFAX;
data.SENDPLACE = dal.SENDPLACE;
data.SENDPROVINCE = dal.SENDPROVINCE;
data.SENDROAD = dal.SENDROAD;
data.SENDTAMBOL = dal.SENDTAMBOL;
data.SENDTEL = dal.SENDTEL;
data.SENDZIPCODE = dal.SENDZIPCODE;
data.TITLE = dal.TITLE;
return data;
}
private void SetDataToDAL(CustomerDAL oDAL, CustomerData cusData)
{
oDAL.ACTIVE = "1";
//-------------------- ª×èͺÃÔÉÑ·/ÅÙ¡¤éÒ ---------------------------------------
oDAL.CODE = cusData.CODE;
oDAL.CUSTOMERTYPE = cusData.CUSTOMERTYPE;
oDAL.IDENTITY = cusData.IDENTITY;
oDAL.TITLE = cusData.TITLE;
oDAL.NAME = cusData.NAME;
oDAL.LASTNAME = cusData.LASTNAME;
oDAL.MEMBERTYPE = cusData.MEMBERTYPE;
oDAL.EFDATE = cusData.EFDATE;
oDAL.EPDATE = cusData.EPDATE;
//-------------------- à§×è͹䢡ÒêÓÃÐà§Ô¹ ---------------------------------------
oDAL.PAYMENT = cusData.PAYMENT;
oDAL.CREDITDAY = cusData.CREDITDAY;
oDAL.CREDITAMOUNT = cusData.CREDITAMOUNT;
//-------------------- ·ÕèÍÂÙèºÃÔÉÑ·/ÅÙ¡¤éÒ/ÊÁÒªÔ¡ ---------------------------------------
oDAL.BILLADDRESS = cusData.BILLADDRESS;
oDAL.BILLROAD = cusData.BILLROAD;
oDAL.BILLPROVINCE = cusData.BILLPROVINCE;
oDAL.BILLAMPHUR = cusData.BILLAMPHUR;
oDAL.BILLTAMBOL = cusData.BILLTAMBOL;
oDAL.BILLZIPCODE = cusData.BILLZIPCODE;
oDAL.BILLTEL = cusData.BILLTEL;
oDAL.BILLFAX = cusData.BILLFAX;
oDAL.BILLEMAIL = cusData.BILLEMAIL;
//-------------------- ª×èͼÙéµÔ´µèÍ ---------------------------------------
oDAL.CTITLE = cusData.CTITLE;
oDAL.CNAME = cusData.CNAME;
oDAL.CLASTNAME = cusData.CLASTNAME;
oDAL.CTEL = cusData.CTEL;
oDAL.CMOBILE = cusData.CMOBILE;
oDAL.CEMAIL = cusData.CEMAIL;
oDAL.CADDRESS = cusData.CADDRESS;
oDAL.CROAD = cusData.CROAD;
oDAL.CPROVINCE = cusData.CPROVINCE;
oDAL.CAMPHUR = cusData.CAMPHUR;
oDAL.CTAMBOL = cusData.CTAMBOL;
oDAL.CZIPCODE = cusData.CZIPCODE;
//-------------------- ʶҹ·ÕèÊè§ÊÔ¹¤éÒ ---------------------------------------
oDAL.SENDPLACE = cusData.SENDPLACE;
oDAL.DELIVERTYPE = cusData.DELIVERTYPE;
oDAL.SENDADDRESS = cusData.SENDADDRESS;
oDAL.SENDROAD = cusData.SENDROAD;
oDAL.SENDPROVINCE = cusData.SENDPROVINCE;
oDAL.SENDAMPHUR = cusData.SENDAMPHUR;
oDAL.SENDTAMBOL = cusData.SENDTAMBOL;
oDAL.SENDZIPCODE = cusData.SENDZIPCODE;
oDAL.SENDTEL = cusData.SENDTEL;
oDAL.SENDFAX = cusData.SENDFAX;
oDAL.SENDEMAIL = cusData.SENDEMAIL;
//-------------------- ËÁÒÂà赯 ---------------------------------------
oDAL.REMARK = cusData.REMARK;
}
public StockOutFGReqData GetRequisitionData(double requisition)
{
StockOutFGReqData data = new StockOutFGReqData();
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
ReqDAL.GetDataByLOID(requisition, obj.zTrans);
data.CADDRESS = ReqDAL.CADDRESS;
data.CFAX = ReqDAL.CFAX;
data.CLASTNAME = ReqDAL.CLASTNAME;
data.CNAME = ReqDAL.CNAME;
data.CTEL = ReqDAL.CTEL;
data.CTITLE = ReqDAL.CTITLE;
data.CUSTOMER = ReqDAL.CUSTOMER;
CustomerDAL cDAL = new CustomerDAL();
cDAL.GetDataByLOID(data.CUSTOMER, obj.zTrans);
data.CUSTOMERCODE = cDAL.CODE;
data.CUSTOMERNAME = (cDAL.NAME + " " + cDAL.LASTNAME).Trim();
data.REQUISITION = ReqDAL.LOID;
data.REQUISITIONCODE = ReqDAL.CODE;
data.REQUISITIONTYPE = ReqDAL.REQUISITIONTYPE;
data.RESERVEDATE = ReqDAL.RESERVEDATE;
data.REQDATE = ReqDAL.REQDATE;
DocTypeDAL dDAL = new DocTypeDAL();
dDAL.GetDataByRequisitionType(data.REQUISITIONTYPE, obj.zTrans);
data.DOCTYPE = dDAL.LOID;
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
_error = ex.Message;
}
return data;
}
public StockOutFGReqData GetRequisitionData(double requisition)
{
StockOutFGReqData data = new StockOutFGReqData();
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
ReqDAL.GetDataByLOID(requisition, obj.zTrans);
data.CADDRESS = ReqDAL.CADDRESS;
data.CFAX = ReqDAL.CFAX;
data.CLASTNAME = ReqDAL.CLASTNAME;
data.CNAME = ReqDAL.CNAME;
data.CTEL = ReqDAL.CTEL;
data.CTITLE = ReqDAL.CTITLE;
data.CUSTOMER = ReqDAL.CUSTOMER;
data.WAREHOUSE = ReqDAL.WAREHOUSE;
data.REFWAREHOUSE = ReqDAL.REFWAREHOUSE == 0 ? ReqDAL.WAREHOUSE : ReqDAL.REFWAREHOUSE;
WarehouseDAL wDAL = new WarehouseDAL();
wDAL.GetDataByLOID(data.WAREHOUSE, obj.zTrans);
data.WAREHOUSECODE = wDAL.CODE;
data.WAREHOUSENAME = wDAL.NAME;
CustomerDAL cDAL = new CustomerDAL();
cDAL.GetDataByLOID(data.CUSTOMER, obj.zTrans);
data.CUSTOMERCODE = cDAL.CODE;
data.CUSTOMERNAME = (cDAL.NAME + " " + cDAL.LASTNAME).Trim();
data.REQUISITION = ReqDAL.LOID;
data.REQUISITIONCODE = ReqDAL.CODE;
data.REQUISITIONTYPE = ReqDAL.REQUISITIONTYPE;
data.RESERVEDATE = ReqDAL.RESERVEDATE;
data.REQDATE = ReqDAL.REQDATE;
DocTypeDAL dDAL = new DocTypeDAL();
dDAL.GetDataByRequisitionType(data.REQUISITIONTYPE, obj.zTrans);
data.DOCTYPE = dDAL.LOID;
RequisitionItemDAL reqItemDAL = new RequisitionItemDAL();
DataTable dt = GetProductLot(data.REQUISITION, data.REFWAREHOUSE);
int i = 1;
foreach (DataRow dRow in dt.Rows)
{
dRow["NO"] = i;
i += 1;
}
data.REQUISITIONITEM = dt;
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
_error = ex.Message;
}
return data;
}
public StockOutFGReqData GetcustomerData(double requisition)
{
StockOutFGReqData data = new StockOutFGReqData();
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
ReqDAL.GetDataByLOID(requisition, obj.zTrans);
data.CADDRESS = ReqDAL.CADDRESS;
data.CFAX = ReqDAL.CFAX;
data.CLASTNAME = ReqDAL.CLASTNAME;
data.CNAME = ReqDAL.CNAME;
data.CTEL = ReqDAL.CTEL;
data.CTITLE = ReqDAL.CTITLE;
data.CUSTOMER = ReqDAL.CUSTOMER;
data.WAREHOUSE = ReqDAL.WAREHOUSE;
data.REFWAREHOUSE = ReqDAL.REFWAREHOUSE == 0 ? ReqDAL.WAREHOUSE : ReqDAL.REFWAREHOUSE;
WarehouseDAL wDAL = new WarehouseDAL();
wDAL.GetDataByLOID(data.WAREHOUSE, obj.zTrans);
data.WAREHOUSECODE = wDAL.CODE;
data.WAREHOUSENAME = wDAL.NAME;
CustomerDAL cDAL = new CustomerDAL();
cDAL.GetDataByLOID(data.CUSTOMER, obj.zTrans);
data.CUSTOMERCODE = cDAL.CODE;
data.CUSTOMERNAME = (cDAL.NAME + " " + cDAL.LASTNAME).Trim();
data.REQUISITION = ReqDAL.LOID;
data.REQUISITIONCODE = ReqDAL.CODE;
data.REQUISITIONTYPE = ReqDAL.REQUISITIONTYPE;
data.RESERVEDATE = ReqDAL.RESERVEDATE;
data.REQDATE = ReqDAL.REQDATE;
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
_error = ex.Message;
}
return data;
}
