public string SaveFromFile(string file)
{
agent = db.agents.FirstOrDefault(s => s.name == db.MobileUsers.FirstOrDefault(a => a.AgentMobileId == User.Identity.Name).AgentName);
string model;
using (System.IO.StreamReader fileStr =
new System.IO.StreamReader(@"D:\order\logPayment\" + file + ".txt"))
{
model = fileStr.ReadToEnd();
}
try
{
using (System.IO.StreamWriter fileLog =
new System.IO.StreamWriter(@"D:\order\logPayment\" + agent.name + ".txt"))
{
fileLog.WriteLine("{0}", model);
}
try
{
var log = new logsString {
id = 0, agent = agent.name, content = model, date = DateTime.Now
};
db.Entry(log).State = EntityState.Added;
db.SaveChanges();
var logs = JsonConvert.DeserializeObject <logsPayment[]>(model);
foreach (var item in logs.ToList())
{
item.timeStampServer = DateTime.Now;
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
var pays = JsonConvert.DeserializeObject <Payment[]>(model);
foreach (var a in pays.ToList())
{
foreach (var c in db.Payments.Where(o => o.agent == a.agent && o.customer == a.customer).ToList())
{
db.Entry(c).State = EntityState.Deleted;
db.SaveChanges();
}
}
foreach (var item in pays)
{
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
return("Записано");
}
catch (Exception ex)
{
return(ex.Message);
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string Save(string model)
{
agent = db.agents.FirstOrDefault(s => s.name == db.MobileUsers.FirstOrDefault(a => a.AgentMobileId == User.Identity.Name).AgentName);
using (System.IO.StreamWriter fileLog =
new System.IO.StreamWriter(@"D:\order\log\" + agent.name + ".txt"))
{
fileLog.WriteLine("{0}", model);
}
try
{
var log = new logsString {
id = 0, agent = agent.name, content = model, date = DateTime.Now
};
db.Entry(log).State = EntityState.Added;
db.SaveChanges();
var logs = JsonConvert.DeserializeObject <log[]>(model);
foreach (var item in logs.ToList())
{
item.timeStampServer = DateTime.Now;
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
var orders = JsonConvert.DeserializeObject <Order[]>(model);
if (!orders.Any())
{
return("Нет данных");
}
foreach (var a in orders.ToList())
{
foreach (var c in db.Orders.Where(o => o.agent == a.agent && o.customer == a.customer && o.number == a.number).ToList())
{
db.Entry(c).State = EntityState.Deleted;
db.SaveChanges();
}
}
foreach (var item in orders)
{
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
return("Записано");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string SaveFromFile(string file)
{
string model;
using (System.IO.StreamReader fileStr =
new System.IO.StreamReader(@"D:\order\log\" + file + ".txt"))
{
model = fileStr.ReadToEnd();
}
try
{
var log = new logsString {
id = 0, agent = "manual", content = model, date = DateTime.Now
};
db.Entry(log).State = EntityState.Added;
db.SaveChanges();
var logs = JsonConvert.DeserializeObject <log[]>(model);
foreach (var item in logs.ToList())
{
item.timeStampServer = DateTime.Now;
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
var orders = JsonConvert.DeserializeObject <Order[]>(model);
foreach (var a in orders.ToList())
{
foreach (var c in db.Orders.Where(o => o.agent == a.agent && o.customer == a.customer && o.number == a.number).ToList())
{
db.Entry(c).State = EntityState.Deleted;
db.SaveChanges();
}
}
foreach (var item in orders)
{
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
return("Записано");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string Save(string model)
{
try
{
agents agent;
var context = System.Web.HttpContext.Current;
agent = (agents)context.Cache["agent"];
var log = new logsString {
id = 0, agent = agent.agent, content = model, date = DateTime.Now
};
db.Entry(log).State = EntityState.Added;
db.SaveChanges();
var logs = new JavaScriptSerializer().Deserialize <log[]>(model);
foreach (var item in logs)
{
item.timeStampServer = DateTime.Now;
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
var orders = new JavaScriptSerializer().Deserialize <Order[]>(model);
foreach (var a in orders.ToList())
{
foreach (var c in db.Orders.Where(o => o.agent == a.agent && o.customer == a.customer && o.number == a.number).ToList())
{
db.Entry(c).State = EntityState.Deleted;
db.SaveChanges();
}
}
foreach (var item in orders)
{
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
return("Записано");
}
catch (Exception ex)
{
return(ex.Message);
}
}
