protected override void FillCard()
{
if (_Id == null)
{
FillPaidData();
btnPrint.Enabled = false;
dtDogovorDate.Value = DateTime.Now.Date;
tbDogovorNum.Text = CreateDogNum();
tbDogovorNum.Enabled = false;
return;
}
try
{
using (PriemEntities context = new PriemEntities())
{
PaidData paiddata = (from ec in context.PaidData
where ec.Id == GuidId
select ec).FirstOrDefault();
if (paiddata == null)
{
return;
}
DogovorNum = paiddata.DogovorNum;
DogovorDate = paiddata.DogovorDate;
DogovorTypeId = paiddata.DogovorTypeId;
Qualification = paiddata.Qualification;
Srok = paiddata.Srok;
DateStart = paiddata.DateStart;
DateFinish = paiddata.DateFinish;
ProrektorId = paiddata.ProrektorId;
SumFirstYear = paiddata.SumFirstYear;
PayPeriodId = paiddata.PayPeriodId;
SumFirstPeriod = paiddata.SumFirstPeriod;
AbitParent = paiddata.Parent;
AbitFIORod = paiddata.AbitFIORod;
Customer = paiddata.Customer;
CustomerLico = paiddata.CustomerLico;
CustomerAddress = paiddata.CustomerAddress;
CustomerPassport = paiddata.CustomerPassport;
CustomerPassportAuthor = paiddata.CustomerPassportAuthor;
CustomerReason = paiddata.CustomerReason;
CustomerINN = paiddata.CustomerINN;
CustomerRS = paiddata.CustomerRS;
}
}
catch (DataException de)
{
WinFormsServ.Error("Ошибка при заполнении формы " + de.Message);
}
}
public void Load()
{
if (File.Exists(Application.persistentDataPath + "/adInfo.dat"))
{
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Open(Application.persistentDataPath + "/adInfo.dat", FileMode.Open);
PaidData data = (PaidData)bf.Deserialize(file);
file.Close();
hasPaid = data.hasPaid;
}
}
public void Save()
{
// create a file
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Create(Application.persistentDataPath + "/adInfo.dat");
PaidData data = new PaidData();
data.hasPaid = hasPaid;
// push data to file
bf.Serialize(file, data);
file.Close();
}
public KeyValuePair <bool, string> ProcessExcel(string filePath, int orgId, string username)
{
try
{
var myStringBuilder = new StringBuilder("<b>Excel Import Process Summary:</b><hr/>");
myStringBuilder.AppendLine();
//reading the excel sheet, get the first sheet.
var excelData = new ExcelFileReader(filePath);
string sheetName = excelData.getWorksheetNames().FirstOrDefault();
var albums = excelData.getData(sheetName);
//validating the data first before uploading
var i = 1;
foreach (var row in albums)
{
i++;
myStringBuilder.Append("<b>Row: " + i + "</b> ");
myStringBuilder.AppendLine();
//validating the fieds in the excel sheet
if (row["ClaimNo"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Claim No can not be Empty</span><br/>");
myStringBuilder.AppendLine();
continue;
// return new KeyValuePair<bool, string>(false, myStringBuilder.ToString());
}
var clNo = row["ClaimNo"].ToString().Trim();
var existingData =
_unitOfWork.PaidDataRepository.Get(
filter:
x => x.OrgID == orgId &&
x.ClaimNo.Equals(clNo,
StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
if (existingData != null)
{
myStringBuilder.Append("<span color='red'>-Error Claim No Already Exist</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
if (row["PolicyNo"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Policy No can not be Empty</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
if (row["ClassOfBusiness"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Class Of Business can not be Empty</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
string cob = row["ClassOfBusiness"].ToString().Trim();
var cobEntity = _unitOfWork.ClassOfBusinessRepository.Get(filter: x => x.ClassType.Equals(cob, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
if (cobEntity == null)
{
myStringBuilder.Append("<span color='red'>-Error Class Of Business is not in the system</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
if (row["TypeOfLoss"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Type Of Loss can not be Empty</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
var tol = row["TypeOfLoss"].ToString().Trim();
var tolEntity = _unitOfWork.TypeOfLossRepository.Get(filter: x => x.TypeName.Equals(tol, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
if (tolEntity == null)
{
myStringBuilder.Append("<span color='red'>-Error Type Of Loss is not in the system</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
if (row["DateOfLoss"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Date Of Loss can not be Empty</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
DateTime dateOfLoss;
if (DateTime.TryParse(row["DateOfLoss"].ToString().Trim(), out dateOfLoss) == false)
{
myStringBuilder.Append("<span color='red'>-Error Date Of Loss should be of the correct date type</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
if (row["DateOfPayment"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Date Of Payment can not be Empty</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
DateTime dateOfPayment;
if (DateTime.TryParse(row["DateOfPayment"].ToString().Trim(), out dateOfPayment) == false)
{
myStringBuilder.Append("<span color='red'>-Error Date Of Payment should be of the correct date type</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
//if (dateOfPayment < dateOfLoss)
//{
// myStringBuilder.Append("<span color='red'>-Error Date Of Payment cannot be less than Date of Loss </span><br/>");
// myStringBuilder.AppendLine();
// return new KeyValuePair<bool, string>(false, myStringBuilder.ToString());
//}
if (row["GrossAmount"].ToString().Trim() == "")
{
myStringBuilder.Append("<span color='red'>-Error Gross Amount can not be Empty</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
decimal grossAmount;
if (decimal.TryParse(row["GrossAmount"].ToString().Trim(), out grossAmount) == false)
{
myStringBuilder.Append("<span color='red'>-Error Gross Amount should be of the correct type</span><br/>");
myStringBuilder.AppendLine();
return(new KeyValuePair <bool, string>(false, myStringBuilder.ToString()));
}
myStringBuilder.Append(" Success ").AppendLine();
//add details to the call plan but dont save.
//save when all is done.
var cp = new PaidData
{
OrgID = orgId,
ClaimNo = row["ClaimNo"].ToString().Trim(),
PolicyNo = row["PolicyNo"].ToString().Trim(),
ClassOfBusiness = cobEntity.ID,
DateOfLoss = dateOfLoss,
LossYear = dateOfLoss.Year,
DateOfPayment = dateOfPayment,
PaidYear = dateOfPayment.Year,
DevPeriod = (dateOfPayment.Year - dateOfLoss.Year) + 1,
GrossAmount = grossAmount,
TypeOfLoss = tolEntity.ID,
CreatedBy = username,
CreatedDate = DateTime.Now,
ModifiedBy = username,
ModifiedDate = DateTime.Now
};
_unitOfWork.PaidDataRepository.Insert(cp);
}
_unitOfWork.Save();
myStringBuilder.AppendLine("Excel file successfully imported");
return(new KeyValuePair <bool, string>(true, myStringBuilder.ToString()));
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in ex.EntityValidationErrors)
{
sb.AppendLine(string.Format("- Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().FullName, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
sb.AppendLine(string.Format("-- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"",
ve.PropertyName,
eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName),
ve.ErrorMessage));
}
}
ErrorSignal.FromCurrentContext().Raise(new Exception(sb.ToString()));
return(new KeyValuePair <bool, string>(false, Settings.Default.GenericExceptionMessage));
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
return(new KeyValuePair <bool, string>(false, Settings.Default.GenericExceptionMessage));
}
}
