private string SyncStockOut(SyncToDepartmentObject syncToDept)
{
PosClientDb clientDb = new PosClientDb();
PosDatabase database = PosDatabase.Instance;
var deptStkInAdapter = new crl_dept_stk_inTableAdapter();
deptStkInAdapter.ClearBeforeFill = true;
deptStkInAdapter.Fill(clientDb.crl_dept_stk_in);
var deptStkInDetAdapter = new crl_dept_stk_in_detTableAdapter();
deptStkInDetAdapter.Fill(clientDb.crl_dept_stk_in_det);
var deptStkTableAdapter = new crl_dept_stkTableAdapter();
deptStkTableAdapter.Fill(clientDb.crl_dept_stk);
var stkOutTableAdapter = new crl_stk_outTableAdapter();
stkOutTableAdapter.Fill(clientDb.crl_stk_out);
string template = DateTime.Now.ToString("yyMMdd");
var maxId = (from dr in clientDb.crl_dept_stk_in
where dr.STOCK_IN_ID.Contains(template)
orderby dr.STOCK_IN_ID descending
select dr).Max(r => r.STOCK_IN_ID);
string maxStockInId = !ObjectUtility.IsNullOrEmpty(maxId) ? string.Format("{0:0000000000000000}",Int64.Parse(maxId.ToString()) + 1) : string.Format("{0:00000}",syncToDept.Department.DepartmentId) + template + "0001";
Department department = syncToDept.Department;
PosClientDb.crl_stk_outDataTable master = clientDb.crl_stk_out;
PosClientDb.crl_stk_out_detDataTable details = new PosClientDb.crl_stk_out_detDataTable();
foreach (DataRow dataRow in syncToDept.StockOutDetail.Rows)
{
PosClientDb.crl_stk_out_detRow row = details.Newcrl_stk_out_detRow();
database.AssignValue(row,dataRow,details.Columns);
details.Addcrl_stk_out_detRow(row);
}
foreach (DataRow stockOut in syncToDept.StockOut.Rows)
{
long stockOutId = Int64.Parse(stockOut["STOCK_OUT_ID"].ToString());
string filter = "STOCK_OUT_ID = " + stockOut["STOCK_OUT_ID"].ToString();
var currents = from dr in clientDb.crl_stk_out
where dr.STOCK_OUT_ID == stockOutId
select dr;
// if has synchronizes stock out then continue
if(currents.Count()>0) continue;
// create new department stock in
PosClientDb.crl_dept_stk_inRow newRow = clientDb.crl_dept_stk_in.Newcrl_dept_stk_inRow();
newRow.STOCK_IN_ID = maxStockInId;
newRow.STOCK_IN_TYPE = 0;
newRow.SRC_DEPARTMENT_ID = Int64.Parse(stockOut["DEPARTMENT_ID"].ToString());
newRow.TOTAL_QUANTITY = Int64.Parse(stockOut["TOTAL_QUANTITY"].ToString());
newRow.DEPARTMENT_ID = department.DepartmentId;
newRow.STOCK_IN_DATE = DateTime.Now;
newRow.CREATE_DATE = DateTime.Now;
newRow.UPDATE_DATE = DateTime.Now;
newRow.CREATE_ID = "admin";
newRow.UPDATE_ID = "admin";
newRow.DESCRIPTION = stockOut["DESCRIPTION"].ToString();
newRow.EXCLUSIVE_KEY = 1;
clientDb.crl_dept_stk_in.Addcrl_dept_stk_inRow(newRow);
// create department stock in detail
var specificDetails = from dt in details
where dt.STOCK_OUT_ID == Int64.Parse(stockOut["STOCK_OUT_ID"].ToString())
select dt;
foreach (PosClientDb.crl_stk_out_detRow crlStkOutDetRow in specificDetails)
{
// insert stock_in
PosClientDb.crl_dept_stk_in_detRow detail = clientDb.crl_dept_stk_in_det.Newcrl_dept_stk_in_detRow();
detail.STOCK_IN_ID = maxStockInId;
detail.DEPARTMENT_ID = newRow.DEPARTMENT_ID;
detail.EXCLUSIVE_KEY = newRow.EXCLUSIVE_KEY;
detail.CREATE_DATE = newRow.CREATE_DATE;
detail.UPDATE_DATE = newRow.UPDATE_DATE;
detail.CREATE_ID = newRow.CREATE_ID;
detail.UPDATE_ID = newRow.UPDATE_ID;
detail.PRODUCT_ID = crlStkOutDetRow.PRODUCT_ID;
detail.PRODUCT_MASTER_ID = crlStkOutDetRow.PRODUCT_MASTER_ID;
detail.QUANTITY = crlStkOutDetRow.QUANTITY;
clientDb.crl_dept_stk_in_det.Addcrl_dept_stk_in_detRow(detail);
// update stock
PosClientDb.crl_dept_stkRow stkRow = (from stk in clientDb.crl_dept_stk.AsEnumerable()
where stk.PRODUCT_ID.Equals(crlStkOutDetRow.PRODUCT_ID)
select stk).FirstOrDefault();
if(stkRow!=null) // if found
{
stkRow.QUANTITY += (int)crlStkOutDetRow.QUANTITY;
} // not found
else
{
PosClientDb.crl_dept_stkRow newStkRow = clientDb.crl_dept_stk.Newcrl_dept_stkRow();
newStkRow.PRODUCT_ID = crlStkOutDetRow.PRODUCT_ID;
newStkRow.PRODUCT_MASTER_ID = crlStkOutDetRow.PRODUCT_MASTER_ID;
newStkRow.QUANTITY = (int)crlStkOutDetRow.QUANTITY;
newStkRow.GOOD_QUANTITY = (int)crlStkOutDetRow.QUANTITY;
newStkRow.DEPARTMENT_ID = newRow.DEPARTMENT_ID;
newStkRow.EXCLUSIVE_KEY = newRow.EXCLUSIVE_KEY;
newStkRow.CREATE_DATE = newRow.CREATE_DATE;
newStkRow.UPDATE_DATE = newRow.UPDATE_DATE;
newStkRow.CREATE_ID = newRow.CREATE_ID;
newStkRow.UPDATE_ID = newRow.UPDATE_ID;
clientDb.crl_dept_stk.Addcrl_dept_stkRow(newStkRow);
}
}
maxStockInId = (Int64.Parse(maxStockInId) + 1).ToString();
// update stockOut
PosClientDb.crl_stk_outRow row = clientDb.crl_stk_out.Newcrl_stk_outRow();
database.AssignValue(row, stockOut, master.Columns);
clientDb.crl_stk_out.Addcrl_stk_outRow(row);
stkOutTableAdapter.Update(clientDb.crl_stk_out);
}
deptStkInAdapter.Update(clientDb.crl_dept_stk_in);
deptStkInDetAdapter.Update(clientDb.crl_dept_stk_in_det);
deptStkTableAdapter.Update(clientDb.crl_dept_stk);
return "";
}
private string SyncCommonInformation(SyncToDepartmentObject syncToDept)
{
PosDatabase database = PosDatabase.Instance;
PosClientDb clientDb = new PosClientDb();
crl_deptTableAdapter crlDeptTableAdapter = new crl_deptTableAdapter();
crlDeptTableAdapter.Fill(clientDb.crl_dept);
// sync department information
database.ReflectUpdateTable(clientDb.crl_dept, syncToDept.DepartmentList);
crlDeptTableAdapter.Update(clientDb.crl_dept);
// sync product information
crl_catTableAdapter catTableAdapter = new crl_catTableAdapter();
catTableAdapter.Fill(clientDb.crl_cat);
database.ReflectUpdateTable(clientDb.crl_cat,syncToDept.Category);
catTableAdapter.Update(clientDb.crl_cat);
crl_prd_typTableAdapter prdTypTableAdapter = new crl_prd_typTableAdapter();
prdTypTableAdapter.Fill(clientDb.crl_prd_typ);
database.ReflectUpdateTable(clientDb.crl_prd_typ, syncToDept.ProductType);
prdTypTableAdapter.Update(clientDb.crl_prd_typ);
crl_ex_prd_colorTableAdapter crlExPrdColorTableAdapter = new crl_ex_prd_colorTableAdapter();
crlExPrdColorTableAdapter.Fill(clientDb.crl_ex_prd_color);
database.ReflectUpdateTable(clientDb.crl_ex_prd_color, syncToDept.ProductColor);
crlExPrdColorTableAdapter.Update(clientDb.crl_ex_prd_color);
crl_ex_prd_sizeTableAdapter prdSizeTableAdapter = new crl_ex_prd_sizeTableAdapter();
prdSizeTableAdapter.Fill(clientDb.crl_ex_prd_size);
database.ReflectUpdateTable(clientDb.crl_ex_prd_size, syncToDept.ProductSize);
prdSizeTableAdapter.Update(clientDb.crl_ex_prd_size);
crl_prd_mstTableAdapter crlPrdMstTableAdapter = new crl_prd_mstTableAdapter();
crlPrdMstTableAdapter.Fill(clientDb.crl_prd_mst);
database.ReflectUpdateTable(clientDb.crl_prd_mst, syncToDept.ProductMaster);
crlPrdMstTableAdapter.Update(clientDb.crl_prd_mst);
crl_prdTableAdapter crlPrdTableAdapter = new crl_prdTableAdapter();
crlPrdTableAdapter.Fill(clientDb.crl_prd);
database.ReflectUpdateTable(clientDb.crl_prd, syncToDept.Product);
crlPrdTableAdapter.Update(clientDb.crl_prd);
// sync price information
crl_mn_priceTableAdapter crlMnPriceTableAdapter = new crl_mn_priceTableAdapter();
crlMnPriceTableAdapter.Fill(clientDb.crl_mn_price);
database.ReflectUpdateTable(clientDb.crl_mn_price, syncToDept.Prices);
crlMnPriceTableAdapter.Update(clientDb.crl_mn_price);
var crl_stk_def_statAdapter = new crl_stk_def_statTableAdapter();
crl_stk_def_statAdapter.Fill(clientDb.crl_stk_def_stat);
database.ReflectUpdateTable(clientDb.crl_stk_def_stat,syncToDept.StockDefinitionStatus);
crl_stk_def_statAdapter.Update(clientDb.crl_stk_def_stat);
return "";
}