public static PsReponse UpdatePhieuSangLoc(List <PSPhieuSangLoc> lstpsl)
{
PsReponse res = new PsReponse();
try
{
ProcessDataSync cn = new ProcessDataSync();
db = cn.db;
var account = db.PSPhieuSangLocs.FirstOrDefault();
db.Connection.Open();
db.Transaction = db.Connection.BeginTransaction();
foreach (var psl in lstpsl)
{
var psldb = db.PSPhieuSangLocs.FirstOrDefault(p => p.IDPhieu == psl.IDPhieu);
if (psldb != null)
{
var term = psl.RowIDPhieu;
psldb = psl;
psldb.RowIDPhieu = term;
db.SubmitChanges();
}
else
{
PSPhieuSangLoc newpsl = new PSPhieuSangLoc();
newpsl = psl;
newpsl.RowIDPhieu = 0;
newpsl.isDongBo = true;
db.PSPhieuSangLocs.InsertOnSubmit(newpsl);
db.SubmitChanges();
}
}
db.Transaction.Commit();
db.Connection.Close();
res.Result = true;
}
catch (Exception ex)
{
db.Transaction.Rollback();
db.Connection.Close();
res.Result = false;
res.StringError = ex.ToString();
}
return(res);
}
public static PsReponse GetPhieuSangLoc()
{
PsReponse res = new PsReponse();
res.Result = true;
try
{
ProcessDataSync cn = new ProcessDataSync();
db = cn.db;
var account = db.PSAccount_Syncs.FirstOrDefault();
if (account != null)
{
string token = cn.GetToken(account.userName, account.passWord);
if (!string.IsNullOrEmpty(token))
{
var result = cn.GetRespone(cn.CreateLink(linkGetPhieuSangLoc), token);
if (result.Result)
{
string json = result.ValueResult;
JavaScriptSerializer jss = new JavaScriptSerializer();
ObjectModel.RootObjectAPI psl = jss.Deserialize <ObjectModel.RootObjectAPI>(json);
//List<PSPatient> patient = jss.Deserialize<List<PSPatient>>(json);
List <PSPhieuSangLoc> lstpsl = new List <PSPhieuSangLoc>();
if (psl.TotalCount > 0)
{
foreach (var item in psl.Items)
{
PSPhieuSangLoc term = new PSPhieuSangLoc();
term = cn.CovertDynamicToObjectModel(item, term);
lstpsl.Add(term);
}
//UpdatePatient(patient);
UpdatePhieuSangLoc(lstpsl);
res.Result = true;
}
}
else
{
res.Result = false;
res.StringError = result.ErorrResult;
}
}
else
{
res.Result = false;
res.StringError = "Kiểm tra lại kết nối mạng hoặc tài khoản đồng bộ!";
}
}
else
{
res.Result = false;
res.StringError = "Chưa có tài khoản đồng bộ!";
}
}
catch (Exception ex)
{
res.Result = false;
res.StringError = DateTime.Now.ToString() + "Lỗi khi get dữ liệu Danh Mục Mapping Kỹ Thuật - Dịch Vụ từ server \r\n " + ex.Message;
}
return(res);
}