/// <summary>
/// 保存数据
/// </summary>
public void SaveImportData(IEnumerable <Spl_Person> personList)
{
try
{
DbContexts db = new DbContexts();
foreach (var model in personList)
{
Spl_Person entity = new Spl_Person();
entity.KEY_Id = ResultHelper.NewId;
entity.Name = model.Name;
entity.Sex = model.Sex;
entity.Age = model.Age;
entity.IDCard = model.IDCard;
entity.Phone = model.Phone;
entity.Email = model.Email;
entity.Address = model.Address;
entity.CreateTime = ResultHelper.NowTime.ToString("yyyy-MM-dd HH:mm:ss");
entity.Region = model.Region;
entity.Category = model.Category;
db.Spl_Person.Add(entity);
}
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
//保存头像
public int bao(DTO.UserInfoDto du)
{
var ui = DbContexts.UserInfo.Find(du.Id);
ui.UserHeadPortrait = du.UserHeadPortrait;
return(DbContexts.SaveChanges());
}
/// <summary>
/// 我的微博删除微博
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Remove(int id)
{
var RemoveMymicrobolg = DbContexts.MicroBlog.Find(id);
DbContexts.MicroBlog.Remove(RemoveMymicrobolg);
return(DbContexts.SaveChanges());
}
/// <summary>
/// 找回密码方法
/// </summary>
/// <param name="whereLambda"></param>
/// <returns></returns>
public int ForgetThePwd(DTO.UserInfoDto Uidto)
{
//根据邮箱修改密码
var ForgetThePwdEntity = DbContexts.UserInfo.Where(p => p.UserEmail == Uidto.UserEmail).First();
ForgetThePwdEntity.UserPassword = Uidto.UserPassword;
int i = DbContexts.SaveChanges();
return(i);
}
//保存资料
public int update(DTO.UserInfoDto du)
{
var ui = DbContexts.UserInfo.Find(du.Id);
ui.UserName = du.UserName;
ui.UserEmail = du.UserEmail;
ui.UserAutograph = du.UserAutograph;
ui.UserSex = du.UserSex;
ui.UserRegion = du.UserRegion;
ui.UserBirthday = du.UserBirthday;
return(DbContexts.SaveChanges());
}
public async Task <Response <Countries> > AddCountry(Guid Id, string Country, string IsoCode)
{
var listCountryIsoCodes = dbContexts.Countries.Select(c => c.IsoCode).ToList();
var existingCountry = await dbContexts.Countries.FirstOrDefaultAsync(c => c.IsoCode == IsoCode.ToString());
if (existingCountry != null)
{
return(new Response <Countries>
{
Message = "The country already exist",
Model = existingCountry,
Successful = false
});
}
else if (listCountryIsoCodes.Count == 10)
{
return(new Response <Countries>
{
Message = "The number of countries exceed the limit of 10",
Successful = false
});
}
var newCountry = new Countries()
{
ID = Id,
Country = Country,
IsoCode = IsoCode
};
dbContexts.Add(newCountry);
dbContexts.SaveChanges();
return(new Response <Countries>
{
Message = "Successful",
Model = newCountry,
Successful = true
});
}
/// <summary>
/// 注册方法
/// </summary>
/// <param name="whereLambda"></param>
/// <returns></returns>
public int AddRegister(DTO.UserInfoDto Uidto)
{
//return DbContext.UserInfo.Where(whereLambda).AsQueryable();
Models.UserInfo Userlist = new Models.UserInfo()
{
UserName = Uidto.UserName,
UserEmail = Uidto.UserEmail,
UserPassword = Uidto.UserPassword
};
DbContexts.UserInfo.Add(Userlist);
int i = DbContexts.SaveChanges();
return(i);
}
/// <summary>
/// 发布微博
/// </summary>
/// <param name="Uid"></param>
/// <param name="Mbd"></param>
/// <returns></returns>
public int PublishWeibo(DTO.UserInfoDto Uid, DTO.MicroBlogsDto Mbd)
{
Models.MicroBlog Mb = new Models.MicroBlog()
{
UserID = Uid.Id,
Title = Mbd.Title,
Content_text = Mbd.Content_text,
Content_img = Mbd.Content_img,
Points_number = 0,
Place = Mbd.Place,
Cansee_states = 0
};
DbContexts.MicroBlog.Add(Mb);
return(DbContexts.SaveChanges());
}
/// <summary>
/// 加入异常日志
/// </summary>
/// <param name="ex">异常</param>
public static void WriteException(Exception ex)
{
SysConfigModel siteConfig = new SysConfigBLL().loadConfig(Utils.GetXmlMapPath("Configpath"));
//后台异常开启
if (siteConfig.exceptionstatus == 1)
{
try
{
using (DbContexts db = new DbContexts())
{
SysException model = new SysException()
{
ExceptionId = ResultHelper.NewId,
HelpLink = ex.HelpLink,
Message = ex.Message,
Source = ex.Source,
StackTrace = ex.StackTrace,
TargetSite = ex.TargetSite.ToString(),
Data = ex.Data.ToString(),
CreateTime = ResultHelper.NowTime.ToString()
};
db.SysException.Add(model);
db.SaveChanges();
}
}
catch (Exception ep)
{
string subFold = DateTime.Now.Year + DateTime.Now.Month.ToString("D2");
string fileName = subFold + DateTime.Now.Day.ToString("D2") + ".txt";
string path = System.Web.HttpContext.Current.Server.MapPath("~/LogFile/") + subFold;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string wholePath = path + "\\" + fileName;
using (StreamWriter sw = new StreamWriter(wholePath, true, Encoding.UTF8))
{
sw.WriteLine((ex.Message + "|" + ex.StackTrace + "|" + ep.Message + "|" + DateTime.Now.ToString()).ToString());
sw.Dispose();
sw.Close();
}
return;
}
}
}
/// <summary>
/// 删除发送者的全部消息(非物理删除)
/// </summary>
/// <param name="sender"></param>
public void DeleteMessageAllNotBySender(string sender)
{
using (DbContexts db = new DbContexts())
{
IQueryable <MIS_WebIM_Message> entityList = from r in db.MIS_WebIM_Message
where r.Sender == sender
select r;
if (entityList == null)
{
return;
}
foreach (var entity in entityList)
{
entity.State = "true";
}
db.SaveChanges();
}
}
/// <summary>
/// 增加点赞数
/// </summary>
/// <param name="id"></param>
/// <param name="Points"></param>
public int Points_number(int id)
{
var PreviewBlogEntity = (from mb in DbContexts.MicroBlog where mb.Id == id select new { mb.Points_number });
int num = 0;
foreach (var item in PreviewBlogEntity)
{
num = item.Points_number;
}
num += 1;
var dd = DbContexts.MicroBlog.Find(id);
dd.Points_number = num;
return(DbContexts.SaveChanges());
//Models.MicroBlog mbs = new Models.MicroBlog() {
// Points_number=num
//};
}
/// <summary>
/// 保存数据
/// </summary>
public void SaveImportData(IEnumerable <FIX_CustomerModel> customerList)
{
try
{
var matchAddressList = new List <string>();
DbContexts db = new DbContexts();
foreach (var model in customerList)
{
FIX_CustomerModel entity = new FIX_CustomerModel();
entity.Name = model.Name;
entity.Phone = model.Phone;
entity.Tel = model.Tel;
entity.Address = model.Address;
entity.ONU = model.ONU;
entity.CreateTime = ResultHelper.NowTime.ToString("yyyy-MM-dd HH:mm:ss");
db.FIX_CustomerModel.Add(entity);
var matchingAddress = entity.Address.ToString().Substring(0, entity.Address.ToString().IndexOf("号") + 1);
if (!matchAddressList.Contains(matchingAddress))
{
FIX_MatchingModel matching = new FIX_MatchingModel();
matching.CreatePerson = "System";
matching.CreateTime = DateTime.Now.ToShortDateString();
matching.Address = matchingAddress;
matching.OTM = "0";
matchAddressList.Add(matchingAddress);
db.FIX_MatchingModel.Add(matching);
}
}
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
public async Task <IActionResult> OnPostUploadAsync(IFormFile file)
{
try
{
var fileName = Path.GetFileName(file.FileName);
var fileExtension = Path.GetExtension(fileName);
if (fileExtension != ".csv" && fileExtension != ".CSV")
{
return(BadRequest(new { count = 1, error = "It seems that file is not in format of CSV" }));
}
else
{
var filePath = Path.GetTempFileName();
if (file.Length > 0)
{
using (var stream = new FileStream(filePath, FileMode.Create))
await file.CopyToAsync(stream);
}
var data = ReadCSVFile(filePath);
int counts = 0;
int inserted = 0;
int notinserted = 0;
foreach (var d in data)
{
if (d.address == "" || d.building_type == "" || d.city == "" || d.epl_identifier == "" || d.province == "" || d.site_name == "")
{
notinserted++;
continue;
}
else
{
_context.Buildings.Add(d);
_context.SaveChanges();
inserted++;
}
counts++;
if (data.Count == counts)
{
var myUniqueFileName = "Processed_";
string newname = myUniqueFileName + file.FileName;
var newFileName = newname;
var filepath = new PhysicalFileProvider(Path.Combine(Directory.GetCurrentDirectory(), "Processed", "Processed folder")).Root + $@"\{newFileName}";
using (FileStream fs = System.IO.File.Create(filepath))
{
file.CopyTo(fs);
fs.Flush();
}
}
}
return(Ok(new { Executed = counts, Inserted = inserted, NotInserted = notinserted, path = filePath }));
}
}
catch (Exception e)
{
return(BadRequest(new { count = 1, error = e.InnerException }));
}
}
