public void updateContact(Contacts contacts)
{
if (contacts.contact_Id == null)
{
// db.ContactsList.Add(contacts);
// db.chqBookAuto_Users.InsertOnSubmit(obj);
db.ContactsList.Add(contacts);//..InsertOnSubmit(contacts);
}
else
{
// db.Entry(contacts).State = EntityState.Modified;
}
db.SaveChanges();
}
public ActionResult Approve(Contacts contacts, string id)
{
string myuser = User.Identity.Name;
string userHostAddress = HttpContext.Request.UserHostAddress;
var model = _userManager.FindById(id);
contacts.approved = 1;
if (ModelState.IsValid)
{
db.Entry(contacts).State = EntityState.Modified;
db.SaveChanges();;
return RedirectToAction("Index");
_getVals.LogAudit(User.Identity.GetUserName(), "Approved", Request.UserHostName, "Approved Contact Details for Customer: " + contacts.Customer_Name, "Approval", "Contacts");
}
return View(contacts);
}
public bool IsContact(Contacts contacts)
{
bool returnType = false;
try
{
// string returnStr = db.ContactsList.Single(p => p.AccountNo == contacts.AccountNo).Customer_No.ToString();
try
{
//string returnStr = db.ContactsList.Single(p => p.AccountNo.Contains(contacts.AccountNo) &&
// p.Address_Line1.Contains( contacts.Address_Line1) && p.Email_address1.Contains(contacts.Email_address1)
// && p.Account_Currency.Contains(contacts.Account_Currency) && p.Customer_Name.Contains(contacts.Customer_Name)
// && p.Customer_No.Contains( p.Customer_No)
// ).Customer_No.ToString();
// string returnStr = db.ContactsList.Single(p => p.AccountNo.Contains(contacts.AccountNo)
string returnStr = db.ContactsList.Single(p => p.Customer_No.Contains(contacts.Customer_No)
// &&
// p.Email_address1.Contains(contacts.Email_address1)
// && p.Account_Currency.Contains(contacts.Account_Currency) && p.Customer_Name.Contains(contacts.Customer_Name)
&& p.Customer_No.Contains(p.Customer_No)
).Customer_No.ToString();
returnType = true;
}
catch (Exception ed) { }
try
{
//string returnStr = db.ContactsList.Single(p => p.AccountNo == contacts.AccountNo &&
// p.Email_address1 == contacts.Email_address1
// && p.Account_Currency == contacts.Account_Currency && p.Customer_Name == contacts.Customer_Name
// && p.Customer_No == contacts.Customer_No
// ).Customer_No.ToString();
//returnType = true;
}
catch (Exception ed) { }
// returnType = true;
}
catch (Exception e)
{
}
return returnType;
}
public Contacts setContact(string AccountNo, string Customer_No, string Customer_Name, string Account_Currency,
string Email_address, string Address_Line1, string Address_Line2, string Address_Line3, string CellNo, string approved, string EditedId, string user_Id)
{
Contacts contact = new Contacts();
// contact.contact_Id
contact.AccountNo = AccountNo;
contact.Customer_No = Customer_No;
contact.Customer_Name = Customer_Name;
contact.Account_Currency = Account_Currency;
contact.Email_address1 = Email_address;
contact.Address_Line1 = Address_Line1;
contact.Address_Line2 = Address_Line2;
contact.Address_Line3 = Address_Line3;
contact.CellNo = CellNo;
//contact.approved =
//contact.EditedId
return contact;
}
// public ReportResult showLetter(int idx=11)
public ActionResult showLetter(ChkBook_collectorDetail collectionForm)
{
int idx = collectionForm.checkbookId;
ReportGenerator reportGen = new ReportGenerator();
string rname = "";//userManager.getReportbyName(pgId);
ViewBag.msgTitle = rname;
ViewBag.Title = rname;
// Customize the Text Fields
ReportsMap rep = new ReportsMap();
rep.fieldId = 1;
rep.field1 = "";
rep.field2 = "";
rep.field3 = "";
rep.field4 = "";
rep.field5 = "";
var reportList = new List<ReportsMap>();
reportList.Add(rep);
var report = new Report(reportList.ToReportSource());
string data1 = "---", data2 = "", data3 = "", data4 = "";
//Read File
string fileName = fngetSystemParamter("COLLECTION LETTER TEMPLATE");
string agent = collectionForm.FullNames;
Document myDocument = new Document(PageSize.A4.Rotate());
try
{
string fileLocation = HttpContext.Server.MapPath(".") + @"\Letter\" + "collection.pdf";
if (!Directory.Exists(HttpContext.Server.MapPath(".") + @"\Letter\"))
{
Directory.CreateDirectory(HttpContext.Server.MapPath(".") + @"\Letter\");
}
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
PdfWriter.GetInstance(myDocument, new FileStream(fileLocation, FileMode.OpenOrCreate));
myDocument.Open();
Contacts contactObj = new Contacts();//"0100047012"
chqBook_CheckBookFieldDec chkBkFields = db.chqBook_CheckBookFieldDecs.Single(p => p.checkbookId == idx);
List<Contacts> contactsList = db.ContactsList.Where(p => p.Customer_No == chkBkFields.acc_no).ToList<Contacts>();
int i = 0;
foreach (Contacts contactmodel in contactsList)
{
if (i == 0)
{
contactObj = contactmodel;
}
i++;
}
string[] lines = System.IO.File.ReadAllLines(fileName);
string[] data;
string printData = "";
string footerText = "";
int footerCount = 0;
foreach (string lin in lines)
{
string tempData = lin;
if (lin.Contains("<<date>>"))
{
tempData = DateTime.Now.ToString("MMMM") + " " + DateTime.Today.Day.ToString() + " , " + DateTime.Today.Year.ToString(); ; //lin.Replace("<<Flex_Name>>", contactObj.Customer_Name);
}
if (lin.Contains("<<Flex_Name>>"))
{
tempData = lin.Replace("<<Flex_Name>>", contactObj.Customer_Name);
}
if (lin.Contains("<<Address_Line_1>>"))
{
tempData = lin.Replace("<<Address_Line_1>>", contactObj.Address_Line1);
}
if (lin.Contains("<<Address_Line_2>>"))
{
tempData = lin.Replace("<<Address_Line_2>>", contactObj.Address_Line2);
}
if (lin.Contains("<<SERIES>>"))
{
tempData = lin.Replace("<<SERIES>>", collectionForm.Series);
}
if (tempData.Contains("<<NO_OF_BOOKS>>"))
{
tempData = tempData.Replace("<<NO_OF_BOOKS>>", collectionForm.no_of_books);
}
if (lin.Contains("<<Account_No>>"))
{
tempData = lin.Replace("<<Account_No>>", chkBkFields.acc_no);
}
if (lin.Contains("<<AGENT>>"))
{
tempData = lin.Replace("<<AGENT>>", agent);
}
if (tempData.Contains("<<ISSUED>>"))
{
tempData = tempData.Replace("<<ISSUED>>", System.DateTime.Now.ToString("dd-MMM-yyyy"));
}
if (tempData.Contains("Citibank, N.A."))
{
footerCount = 1;
}
if (footerCount == 0)
{
printData = printData + tempData + "\n";
}
else
{
footerText = footerText + tempData + "\n";
}
}
// }
report.TextFields.Header = printData;
report.TextFields.Footer = footerText;
myDocument.Add(new Paragraph(printData));
myDocument.Add(new Paragraph(footerText));
//myDocument.Close();
report.RenderHints.BooleanCheckboxes = true;
report.RenderHints.BooleansAsYesNo = true;
report.RenderHints.FreezeRows = 9;
report.RenderHints.FreezeColumns = 2;
// Customize the data fields
report.DataFields["fieldId"].Hidden = true;
// report.DataFields["field1"].Hidden = true;
report.DataFields["field1"].HeaderText = " ";// .DataFormatString="{0:c}";
report.DataFields["field2"].Hidden = true;
report.DataFields["field3"].Hidden = true;
report.DataFields["field4"].Hidden = true;
report.DataFields["field5"].Hidden = true;
report.DataFields["field6"].Hidden = true;
}
catch (DocumentException de)
{
Console.Error.WriteLine(de.Message);
}
finally
{
myDocument.Close();
}
// // Return the ReportResult
// // the type of report that is rendered will be determined by the extension in the URL (.pdf, .xls, .html, etc)
//return new ReportResult();
return RedirectToAction("CollectionLetterpdf");
}
private bool validateContacts(Contacts contacts)
{
bool returnType = false;
return returnType;
}
public ActionResult Edite(CustomerDetails CustomerDetails, int id, Contacts Conts,string Id)
{
string myuser = User.Identity.Name;
string userHostAddress = HttpContext.Request.UserHostAddress;
var model = _userManager.FindById(Id);
Conts.EditedId = User.Identity.GetUserName();
if (ModelState.IsValid)
{
// chkContacts(contacts);
db.ContactsList.Add(chkContacts(Conts));
db.SaveChanges();
}
Contacts bookStatus = db.ContactsList.Single(p => p.contact_Id == Conts.contact_Id);
CustomerDetails CustomerDetail = db.CustomerDetails.Single(p => p.CustomerDetailsId == id);
bookStatus.Customer_Name = CustomerDetails.CUST_NAME_1;
bookStatus.Customer_No = CustomerDetails.AccountNo;
bookStatus.Address_Line1 = CustomerDetails.CUST_NAME_2;
bookStatus.Address_Line2 = CustomerDetails.STREET_ADDR;
bookStatus.Address_Line3 = CustomerDetails.CITY_CTY_ADDR;
bookStatus.Email_address1 = CustomerDetails.Email_address1;
bookStatus.Email_address2 = CustomerDetails.Email_address2;
bookStatus.AccountNo = CustomerDetails.Customer_No;
db.ContactsList.Add(chkContacts(bookStatus));
db.Entry(bookStatus).State = EntityState.Modified;
db.SaveChanges();
_getVals.LogAudit(User.Identity.GetUserName(), "Edit Contact", Request.UserHostName, "Edited Contact Details of {" + Conts.Customer_Name + "\t" + Conts.Customer_No + " : Edited By User { " + User.Identity.GetUserName() + " } " + model.UserName, "Edit", "Contacts");
return RedirectToAction("Index");
}
private Contacts chkContacts(Contacts contacts)
{
if (contacts.Address_Line1 == null)
{
contacts.Address_Line1 = "";
}
if (contacts.Address_Line2 == null)
{
contacts.Address_Line2 = "";
}
if (contacts.Address_Line3 == null)
{
contacts.Address_Line3 = "";
}
return contacts;
}
public ActionResult Edit(Contacts contacts,string id)
{
string myuser = User.Identity.Name;
string userHostAddress = HttpContext.Request.UserHostAddress;
var model = _userManager.FindById(id);
contacts.EditedId = User.Identity.GetUserName();
if (ModelState.IsValid)
{
db.Entry(contacts).State = EntityState.Modified;
db.SaveChanges();
_getVals.LogAudit(User.Identity.GetUserName(), "Edit Contact", Request.UserHostName, "Edited Contact Details of {" + contacts.Customer_Name + "\t" + contacts.Customer_No + " : Edited By User { " + User.Identity.GetUserName() + " } " + model.UserName, "Edit", "Contacts");
return RedirectToAction("Index");
}
return View(contacts);
}
private List<Contacts2> getContactList2(List<Contacts> contact)
{
List<Contacts2> conList = new List<Contacts2>();
foreach (Contacts con in contact)
{
List<Contacts> contobj = db.ContactsList.ToList<Contacts>();
Contacts contac = new Contacts();
foreach (Contacts tempcontact in contobj)
{
contac = tempcontact;
}
Contacts2 temp = new Contacts2();
temp.Customer_Name = con.Customer_Name;
temp.BaseNumber = con.AccountNo;
// temp.BaseNumber = contact.AccountNo;
temp.Customer_No = con.Customer_No;
temp.Email_address1 = con.Email_address1;
temp.Email_address2 = con.Email_address2;
//report.Add(temp);
}
return conList;
}
private List<CollecetdCheckBook_ReportsMap> generateCollecetedChkBkRequestReports(List<chqBook_CheckBookFieldDec> cheqBkReports)
{
var report = new List<CollecetdCheckBook_ReportsMap>();
var pros = new List<chqbook_processedstatus>();
foreach (chqBook_CheckBookFieldDec chkBk in cheqBkReports)
{
List<Contacts> contactObj = db.ContactsList.Where(c => c.Customer_No == chkBk.acc_no).ToList<Contacts>();
var contact = new Contacts();
foreach (Contacts tempContact in contactObj)
{
contact = tempContact;
}
// CheckBook_ReportsMap temp = new CheckBook_ReportsMap();
string collectingAgent = "";
string dateCollected = "";
try
{
ChkBook_collectorDetail collectingAgentDetails = db.collectorDetails.Single(dc => dc.checkbookId == chkBk.checkbookId);
collectingAgent = collectingAgentDetails.FullNames;
dateCollected = collectingAgentDetails.DateCollected.ToString();
}
catch (Exception ex)
{
}
var temp = new CollecetdCheckBook_ReportsMap();
temp.AccountName = contact.Customer_Name;
temp.AccountNumber = chkBk.acc_no;
temp.BaseNumber = contact.AccountNo;
temp.RunNumber = chkBk.runNumber;
//temp.StartSerial = chkBk.ckStartSerial;
//temp.RequestDate = chkBk.OysDate;
//temp.RequestDate = chkBk.fileCreationDate;//chkBk.OysDate;
//temp.DateReceived = chkBk.dateReceived;
temp.CollectingAgent = collectingAgent;
temp.DateCollected = dateCollected;
report.Add(temp);
}
return report;
}
private List<CheckBook_ReportsMap> generateAllDestroyedChkBkRequestReports(List<chqBook_CheckBookFieldDec> cheqBkReports)
{
List<CheckBook_ReportsMap> report = new List<CheckBook_ReportsMap>();
foreach (chqBook_CheckBookFieldDec chkBk in cheqBkReports)
{
List<Contacts> contactObj = db.ContactsList.Where(c => c.Customer_No == chkBk.acc_no).ToList<Contacts>();
Contacts contact = new Contacts();
foreach (Contacts tempContact in contactObj)
{
contact = tempContact;
}
CheckBook_ReportsMap temp = new CheckBook_ReportsMap();
temp.AccountName = chkBk.personalisation;
temp.AccountNumber = chkBk.acc_no;
// temp.BaseNumber = contact.AccountNo;
temp.RunNumber = chkBk.runNumber;
temp.StartSerial = chkBk.ckStartSerial;
temp.RequestDate = chkBk.fileCreationDate;
report.Add(temp);
}
return report;
}
private List<Contacts2> generatallcontacts(List<Contacts> cheqBkReports)
{
var report = new List<Contacts2>();
foreach (Contacts chkBk in cheqBkReports)
{
var contactObj = _repository.Fetch<Contacts>().Where(p => p.contact_Id != 0).ToList();
var UserRole = new Contacts();
foreach (Contacts tempContact in contactObj)
{
UserRole = tempContact;
}
var temp = new Contacts2();
temp.Customer_Name = chkBk.Customer_Name;
temp.Customer_No = chkBk.Customer_No;
temp.BaseNumber = chkBk.AccountNo;
temp.Email_address1 = chkBk.Email_address1;
temp.Email_address2 = chkBk.Email_address2;
temp.Address_Line1 = chkBk.Address_Line1;
temp.Address_Line2 = chkBk.Address_Line2;
report.Add(temp);
}
return report;
}
