public static PsReponse UpdateDMKyThuat(PSDanhMucKyThuatXN kt)
{
PsReponse res = new PsReponse();
try
{
ProcessDataSync cn = new ProcessDataSync();
db = cn.db;
db.Connection.Open();
db.Transaction = db.Connection.BeginTransaction();
var kyt = db.PSDanhMucKyThuatXNs.FirstOrDefault(p => p.IDKyThuatXN == kt.IDKyThuatXN);
if (kyt != null)
{
kyt.isLocked = kt.isLocked;
kyt.STT = kt.STT;
kyt.TenKyThuat = kt.TenKyThuat;
kyt.TenHienThiKyThuat = kt.TenHienThiKyThuat;
db.SubmitChanges();
}
else
{
PSDanhMucKyThuatXN kyth = new PSDanhMucKyThuatXN();
kyth.isLocked = kt.isLocked;
kyth.STT = kt.STT;
kyth.TenKyThuat = Encoding.UTF8.GetString(Encoding.Default.GetBytes(kt.TenKyThuat));
kyth.TenHienThiKyThuat = Encoding.UTF8.GetString(Encoding.Default.GetBytes(kt.TenHienThiKyThuat));
kyth.IDKyThuatXN = kt.IDKyThuatXN;
db.PSDanhMucKyThuatXNs.InsertOnSubmit(kyth);
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 GetDMKyThuat()
{
PsReponse res = new PsReponse();
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(linkGetDanhMucKyThuat), token);
if (result.Result)
{
string json = result.ValueResult;
JavaScriptSerializer jss = new JavaScriptSerializer();
ObjectModel.RootObjectAPI Repo = jss.Deserialize <ObjectModel.RootObjectAPI>(json);
if (Repo != null)
{
if (Repo.TotalCount > 0)
{
foreach (var item in Repo.Items)
{
PSDanhMucKyThuatXN kt = new PSDanhMucKyThuatXN();
kt = cn.CovertDynamicToObjectModel(item, kt);
UpdateDMKyThuat(kt);
}
}
}
else
{
res.Result = false;
res.StringError = result.ErorrResult;
}
}
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 Kỹ Thuật từ server \r\n " + ex.Message;
}
return(res);
}