public async Task AddUserToOrganizationAsyncTest(string orgName)
{
var options = new DbContextOptionsBuilder <UsersContext>()
.UseInMemoryDatabase(databaseName: "AddUserToOrganizationAsync")
.Options;
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
repository.Initialize();
context.Organizations.Add(new OrganizationDTO {
Name = orgName
});
context.SaveChanges();
}
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
var user = repository.GetUsers().FirstOrDefault();
var org = repository.GetOrganizations().FirstOrDefault(o => o.Name == orgName);
await repository.AddUserToOrganizationAsync(user.UserId, org.OrganizationId, CancellationToken.None);
var userTest = context.Users.Include(u => u.Organization).FirstOrDefault();
Assert.Equal(orgName, userTest.Organization.Name);
}
}
public async Task AddUserAsyncTest(string fName, string lName, string mName, string eMail, string phone)
{
var options = new DbContextOptionsBuilder <UsersContext>()
.UseInMemoryDatabase(databaseName: "AddUserAsync")
.Options;
var userId = 0;
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
userId = await repository.AddUserAsync(new UserDTO
{
FirstName = fName,
LastName = lName,
MiddleName = mName,
EMail = eMail,
PhoneNumber = phone
}, CancellationToken.None);
}
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
var user = repository.GetUsers().FirstOrDefault(f => f.UserId == userId);
Assert.Equal(fName, user.FirstName);
Assert.Equal(lName, user.LastName);
Assert.Equal(mName, user.MiddleName);
Assert.Equal(eMail, user.EMail);
Assert.Equal(phone, user.PhoneNumber);
}
}
public async void UpdateUserAsyncTest(string fName, string lName, string mName, string eMail, string phone)
{
var options = new DbContextOptionsBuilder <UsersContext>()
.UseInMemoryDatabase(databaseName: "UpdateUser")
.Options;
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
repository.Initialize();
}
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
var user = repository.GetUsers().FirstOrDefault();
user.FirstName = fName;
user.LastName = lName;
user.MiddleName = mName;
user.EMail = eMail;
user.PhoneNumber = phone;
await repository.UpdateUserAsync(user, CancellationToken.None);
var userTest = repository.GetUsers().FirstOrDefault();
Assert.Equal(fName, userTest.FirstName);
Assert.Equal(lName, userTest.LastName);
Assert.Equal(mName, userTest.MiddleName);
Assert.Equal(eMail, userTest.EMail);
Assert.Equal(phone, userTest.PhoneNumber);
}
}
public void GetOrganizationsTest(string orgName)
{
var options = new DbContextOptionsBuilder <UsersContext>()
.UseInMemoryDatabase(databaseName: "GetOrganizations")
.Options;
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
repository.Initialize();
context.Organizations.Add(new OrganizationDTO
{
Name = orgName
});
context.SaveChanges();
}
using (var context = new UsersContext(options))
{
var repository = new ReceiverRepository(context);
var result = repository.GetOrganizations();
Assert.NotNull(result.FirstOrDefault(f => f.Name == orgName));
Assert.True(result.Count() == 5);
}
}
public List <FrayteUser> GetReceiverList()
{
List <FrayteUser> lstReceivers = new List <FrayteUser>();
lstReceivers = new ReceiverRepository().GetReceiverList();
return(lstReceivers);
}
public FrayteShipperReceiver GetReceiverDetail(int receiverId)
{
FrayteShipperReceiver receiverDetail = new FrayteShipperReceiver();
receiverDetail = new ReceiverRepository().GetReceiverDetail(receiverId);
return(receiverDetail);
}
public static ReceiverEntity GetReceiverById(long gid)
{
ReceiverEntity result = new ReceiverEntity();
ReceiverRepository mr = new ReceiverRepository();
ReceiverInfo info = mr.GetReceiverByKey(gid);
result = TranslateReceiverEntity(info);
return(result);
}
public static int Remove(long gid)
{
ReceiverRepository mr = new ReceiverRepository();
int i = mr.Remove(gid);
//List<ReceiverInfo> miList = mr.GetAllReceiver();//刷新缓存
//Cache.Add("ReceiverALL", miList);
return(i);
}
public IHttpActionResult SaveReceiverOtherAddress(FrayteAddress receiverOtherAddress)
{
FrayteResult result = new ReceiverRepository().SaveReceiverOtherAddress(receiverOtherAddress);
if (result != null && result.Status)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public IHttpActionResult RemoveReceiverShippers(ReceiverShipper receiverShipper)
{
FrayteResult result = new ReceiverRepository().RemoveReceiverShippers(receiverShipper);
if (result.Status)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public static ReceiverEntity GetReceiverEntityById(long cid)
{
ReceiverEntity result = new ReceiverEntity();
ReceiverRepository mr = new ReceiverRepository();
ReceiverInfo info = mr.GetReceiverByKey(cid);
if (info != null)
{
result = TranslateReceiverEntity(info);
//获取联系人信息
result.listContact = ContactService.GetContactByRule(UnionType.Receiver.ToString(), info.ReceiverID);
}
return(result);
}
public string LoadCatGeneric(string listPocos, string dataUser, string tableName)
{
ReceiverRepository _IReciverRepository = new ReceiverRepository();
string ids = "";
try
{
ids=_IReciverRepository.GetSpUpsertServerRows(listPocos, tableName);
}
catch (Exception ex)
{
ids = ex.Message;
}
return ids;
}
public IHttpActionResult DeleteReceiver(int receiverId)
{
FrayteResult result = new FrayteResult();
result = new ReceiverRepository().DeleteReceiver(receiverId);
if (result != null)
{
return(Ok(result));
}
else
{
return(NotFound());
}
}
public static List <ReceiverEntity> GetReceiverInfoPager(PagerInfo pager)
{
List <ReceiverEntity> all = new List <ReceiverEntity>();
ReceiverRepository mr = new ReceiverRepository();
List <ReceiverInfo> miList = mr.GetAllReceiverInfoPager(pager);
if (!miList.IsEmpty())
{
foreach (ReceiverInfo mInfo in miList)
{
ReceiverEntity carEntity = TranslateReceiverEntity(mInfo);
all.Add(carEntity);
}
}
return(all);
}
public static List <ReceiverEntity> GetReceiverInfoByRule(string name, string receiverType, int customerID, int status, PagerInfo pager)
{
List <ReceiverEntity> all = new List <ReceiverEntity>();
ReceiverRepository mr = new ReceiverRepository();
List <ReceiverInfo> miList = mr.GetReceiverInfoByRule(name, receiverType, customerID, status, pager);
if (!miList.IsEmpty())
{
foreach (ReceiverInfo mInfo in miList)
{
ReceiverEntity storeEntity = TranslateReceiverEntity(mInfo);
all.Add(storeEntity);
}
}
return(all);
}
public IHttpActionResult SaveReceiver(FrayteShipperReceiver receiverDetail)
{
FrayteResult result = new ReceiverRepository().SaveReceiver(receiverDetail);
// Link Receiver To Shipper
ReceiverShipper receiverShipper = new ReceiverShipper();
receiverShipper.ReceiverId = receiverDetail.UserId;
new ReceiverRepository().SaveReceiverShippers(receiverShipper);
if (result != null)
{
return(Ok(result));
}
else
{
return(NotFound());
}
}
public static List <ReceiverEntity> GetReceiverByKeys(string ids)
{
List <ReceiverEntity> all = new List <ReceiverEntity>();
ReceiverRepository mr = new ReceiverRepository();
List <ReceiverInfo> miList = mr.GetReceiverByKeys(ids);
if (!miList.IsEmpty())
{
foreach (ReceiverInfo mInfo in miList)
{
ReceiverEntity entity = TranslateReceiverEntity(mInfo);
all.Add(entity);
}
}
return(all);
}
/// <summary>
///
/// </summary>
/// <param name="name">名称</param>
/// <param name="no">编号</param>
/// <param name="receiverType">收货类型</param>
/// <param name="status">状态 1：使用中 0：已删除</param>
/// <returns></returns>
public static List <ReceiverEntity> GetReceiverByRule(string name, string no, string receiverType, int status)
{
List <ReceiverEntity> all = new List <ReceiverEntity>();
ReceiverRepository mr = new ReceiverRepository();
List <ReceiverInfo> miList = mr.GetReceiverByRule(name, no, receiverType, status);
if (!miList.IsEmpty())
{
foreach (ReceiverInfo mInfo in miList)
{
ReceiverEntity ReceiverEntity = TranslateReceiverEntity(mInfo);
all.Add(ReceiverEntity);
}
}
return(all);
}
public static List <ReceiverEntity> GetReceiverAll(bool isRead = true)
{
List <ReceiverEntity> all = new List <ReceiverEntity>();
ReceiverRepository mr = new ReceiverRepository();
List <ReceiverInfo> miList = Cache.Get <List <ReceiverInfo> >("ReceiverALL");
if (miList.IsEmpty())
{
miList = mr.GetAllReceiver();
Cache.Add("ReceiverALL", miList);
}
if (!miList.IsEmpty())
{
foreach (ReceiverInfo mInfo in miList)
{
ReceiverEntity ReceiverEntity = TranslateReceiverEntity(mInfo, isRead);
all.Add(ReceiverEntity);
}
}
return(all);
}
public static List <ReceiverEntity> GetReceiverByCustomerID(int customerID)
{
List <ReceiverEntity> all = new List <ReceiverEntity>();
ReceiverRepository mr = new ReceiverRepository();
List <ReceiverInfo> miList = null;//Cache.Get<List<ReceiverInfo>>("GetReceiverByCustomerID" + customerID);
if (miList.IsEmpty())
{
miList = mr.GetReceiverByCustomerID(customerID);
Cache.Add("GetReceiverByCustomerID" + customerID, miList);
}
if (!miList.IsEmpty())
{
foreach (ReceiverInfo mInfo in miList)
{
ReceiverEntity ReceiverEntity = TranslateReceiverEntity(mInfo, false);
all.Add(ReceiverEntity);
}
}
return(all);
}
static void SendEmail()
{
Console.WriteLine("Кому отправить сообщение?");
using (var receiversRepository = new ReceiverRepository())
using (var mailsRepository = new MailsRepository())
{
Mail mail = new Mail();
int ineration = 1;
var receivers = receiversRepository.GetAll();
foreach (var receiver in receivers)
{
Console.WriteLine(ineration + ": " + receiver.FullName);
}
int receiverNumber;
if (int.TryParse(Console.ReadLine(), out receiverNumber) && receivers.Count >= receiverNumber)
{
mail.Receiver = receivers.ElementAt(receiverNumber - 1);
mail.ReceiverId = receivers.ElementAt(receiverNumber - 1).Id;
}
else
{
return;
}
Console.WriteLine("Введите тему сообщения");
mail.Theme = Console.ReadLine();
Console.WriteLine("Введите сообщениe");
mail.Text = Console.ReadLine();
mailsRepository.Add(mail);
}
}
public IHttpActionResult UploadReceivers()
{
List <FrayteShipperReceiver> frayteReceivers = new List <FrayteShipperReceiver>();
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
HttpFileCollection files = httpRequest.Files;
HttpPostedFile file = files[0];
if (!string.IsNullOrEmpty(file.FileName))
{
string connString = "";
string filename = DateTime.Now.ToString("MM_dd_yyyy_hh_mm_ss_") + file.FileName;
string filepath = HttpContext.Current.Server.MapPath("~/UploadFiles/" + filename);
file.SaveAs(filepath);
connString = new ShipmentRepository().getExcelConnectionString(filename, filepath);
OleDbConnection oledbConn = new OleDbConnection(connString);
try
{
oledbConn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
DataSet ds = new DataSet();
oleda.Fill(ds, "Receivers");
var exceldata = ds.Tables[0];
if (exceldata != null && exceldata.Rows.Count > 0)
{
if (new ReceiverRepository().CheckValidExcel(exceldata))
{
frayteReceivers = new ReceiverRepository().GetReceivers(exceldata);
foreach (var receiver in frayteReceivers)
{
FrayteResult result = new ReceiverRepository().SaveReceiver(receiver);
}
}
else
{
return(BadRequest("Excel file not valid"));
}
}
oledbConn.Close();
if ((System.IO.File.Exists(filepath)))
{
System.IO.File.Delete(filepath);
}
}
catch
{
}
finally
{
oledbConn.Close();
if ((System.IO.File.Exists(filepath)))
{
System.IO.File.Delete(filepath);
}
}
}
}
return(Ok(frayteReceivers));
}
public static bool ModifyReceiver(ReceiverEntity entity)
{
long result = 0;
if (entity != null)
{
ReceiverRepository mr = new ReceiverRepository();
ReceiverInfo ReceiverInfo = TranslateReceiverInfo(entity);
ContactJsonEntity jsonlist = null;
if (!string.IsNullOrEmpty(entity.ContactJson))
{
try
{
jsonlist = (ContactJsonEntity)JsonHelper.FromJson(entity.ContactJson, typeof(ContactJsonEntity));
}
catch (Exception ex)
{
string str = ex.ToString();
}
}
if (entity.ReceiverID > 0)
{
ReceiverInfo.ReceiverID = entity.ReceiverID;
ReceiverInfo.ChangeDate = DateTime.Now;
result = mr.ModifyReceiver(ReceiverInfo);
}
else
{
ReceiverInfo.ChangeDate = DateTime.Now;
ReceiverInfo.CreateDate = DateTime.Now;
result = mr.CreateNew(ReceiverInfo);
}
#region 更新联系人信息
if (jsonlist != null)
{
List <ContactJson> list = jsonlist.listContact;
if (list != null && list.Count > 0)
{
foreach (ContactJson cc in list)
{
ContactRepository cr = new ContactRepository();
ContactInfo contact = new ContactInfo();
contact.ContactName = cc.ContactName;
contact.Mobile = cc.Mobile;
contact.Telephone = cc.Telephone;
contact.Email = cc.Email;
contact.Remark = cc.Remark;
contact.UnionType = UnionType.Receiver.ToString();//客户
if (cc.ContactID > 0)
{
contact.ContactID = cc.ContactID;
contact.UnionID = entity.ReceiverID;
contact.ChangeDate = DateTime.Now;
cr.ModifyContact(contact);
}
else
{
contact.UnionID = entity.ReceiverID > 0 ? entity.ReceiverID : result;
contact.CreateDate = DateTime.Now;
contact.ChangeDate = DateTime.Now;
cr.CreateNew(contact);
}
}
}
}
#endregion
List <ReceiverInfo> miList = mr.GetAllReceiver();//刷新缓存
Cache.Add("ReceiverALL", miList);
Cache.Add("GetReceiverByCustomerID" + entity.CustomerID, miList);
}
return(result > 0);
}
