public ActionResult UpdateC2C1(HttpPostedFileBase files)
{
if (files != null && files.ContentLength > 0)
{
string extension = System.IO.Path.GetExtension(files.FileName);
if (extension.Equals(".xlsx") || extension.Equals(".xls"))
{
string fileSave = "cii_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + extension;
string path = Server.MapPath("~/temp/" + fileSave);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
files.SaveAs(path);
FileInfo newFile = new FileInfo(path);
var package = new ExcelPackage(newFile);
ExcelWorksheet sheet = package.Workbook.Worksheets[1];
int totalRows = sheet.Dimension.End.Row;
int totalCols = sheet.Dimension.End.Column;
for (int i = 2; i <= totalRows; i++)
{
string c2 = Convert.ToString(sheet.Cells[i, 1].Value);
string c11 = Convert.ToString(sheet.Cells[i, 2].Value);
string c12 = Convert.ToString(sheet.Cells[i, 3].Value);
string[] listC1 = { c11, c12 };
var index = 1;
var checkC2 = db.C2Info.Where(p => p.Code == c2.Trim()).FirstOrDefault();
if (checkC2 != null)
{
foreach (var item in listC1)
{
var check = db.C2C1.Where(p => p.C2Code == c2.Trim() && p.C1Code == c11.Trim()).FirstOrDefault();
if (check == null)
{
var checkC1 = db.C1Info.Where(p => p.Code == item.Trim()).FirstOrDefault();
if (checkC1 != null)
{
var c2c1 = new C2C1()
{
Id = Guid.NewGuid().ToString(),
C1Code = checkC1.Code,
C2Code = checkC2.Code,
Priority = index == 1 ? 1 : 0,
ModifyDate = DateTime.Now
};
db.C2C1.Add(c2c1);
db.SaveChanges();
}
index++;
}
}
}
}
}
}
return(View());
}
public ResultInfo CreateAgencyC2()
{
var log = new MongoHistoryAPI()
{
APIUrl = "/api/agency/createagencyc2",
CreateTime = DateTime.Now,
Sucess = 1
};
var result = new ResultInfo()
{
id = "1",
msg = "success"
};
var requestContent = Request.Content.ReadAsStringAsync().Result;
try
{
var jsonserializer = new JavaScriptSerializer();
var paser = jsonserializer.Deserialize <AgencyCreateRequest>(requestContent);
log.Content = new JavaScriptSerializer().Serialize(paser);
if (!mongoHelper.checkLoginSession(paser.user, paser.token))
{
throw new Exception("Wrong token and user login!");
}
var staff = db.HaiStaffs.Where(p => p.UserLogin == paser.user).FirstOrDefault();
if (staff == null)
{
throw new Exception("Chỉ nhân viên công ty mới được quyền tạo");
}
/*
* if (checkC1 == null)
* checkC1 = db.C1Info.Where(p => p.Code == "0000000000").FirstOrDefault();
*/
var agencyCode = GetAgencyCodeTemp(staff.HaiBranch.Code);
CInfoCommon cInfo = new CInfoCommon()
{
Id = Guid.NewGuid().ToString(),
AddressInfo = paser.address,
BranchCode = staff.HaiBranch.Code,
BusinessLicense = paser.businessLicense,
CRank = paser.rank,
CDeputy = paser.deputy,
CName = paser.name,
CreateTime = DateTime.Now,
ProvinceName = paser.province,
DistrictName = paser.district,
Phone = paser.phone,
IdentityCard = paser.identityCard,
CType = "CII",
TaxCode = paser.taxCode,
Lat = paser.lat,
Lng = paser.lng,
CCode = agencyCode,
WardName = paser.ward,
Country = paser.country
};
db.CInfoCommons.Add(cInfo);
db.SaveChanges();
C2Info c2 = new C2Info()
{
Id = Guid.NewGuid().ToString(),
StoreName = paser.name,
Deputy = paser.deputy,
IsActive = 0,
Code = agencyCode,
InfoId = cInfo.Id,
CStatus = 1
};
db.C2Info.Add(c2);
db.SaveChanges();
// db.Entry(staff).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
var staffC2 = new StaffWithC2()
{
C2Id = c2.Id,
StaffId = staff.Id,
GroupChoose = paser.group
};
db.StaffWithC2.Add(staffC2);
db.SaveChanges();
var checkC1 = db.C1Info.Where(p => p.Code == paser.c1Id).FirstOrDefault();
// import c1
if (checkC1 != null)
{
var c2C1Add = new C2C1()
{
C1Code = checkC1.Code,
C2Code = agencyCode,
Id = Guid.NewGuid().ToString(),
Priority = 1,
ModifyDate = DateTime.Now
};
db.C2C1.Add(c2C1Add);
db.SaveChanges();
}
// save info
var agencyImage = new SaveAgencyShopImage()
{
Id = Guid.NewGuid().ToString(),
AddressFull = paser.address,
Cinfo = cInfo.Id,
Country = paser.country,
District = paser.district,
Lat = paser.lat,
Province = paser.province,
CreateTime = DateTime.Now,
StaffId = staff.Id,
Lng = paser.lng,
Ward = paser.ward,
ImagePath = paser.image
};
db.SaveAgencyShopImages.Add(agencyImage);
}
catch (Exception e)
{
result.id = "0";
result.msg = e.Message;
log.Sucess = 0;
}
log.ReturnInfo = new JavaScriptSerializer().Serialize(result);
mongoHelper.createHistoryAPI(log);
return(result);
}
