public bool Update(UserCardExpense model)
{
throw new NotImplementedException();
}
public bool Delete(UserCardExpense model)
{
model.LastModified = DateTime.Now;
return(userCardExpenseRepository.Update(model));
}
public bool Add(UserCardExpense model)
{
return(userCardExpenseRepository.Add(model));
}
private ExcelFileProcess InsertData(DataTable dt, string fileName, IEnumerable <UserCard> userCards)
{
logger.DebugFormat("Inserting Expense Sheet Data from File [{0}]", fileName);
foreach (DataRow row in dt.Rows)
{
UserCardExpense userCardExp = new UserCardExpense();
// UserCard userCard = userCardManagement.GetUserCardByAccountNumber(Convert.ToString(row[UserCardExpenseEnum.Account_Number]));
UserCard userCard = userCards.Where(x => x.CardNumber.ToLower() == Convert.ToString(row[UserCardExpenseEnum.Account_Number]).ToLower()).FirstOrDefault();
if (userCard == null)
{
logger.DebugFormat(string.Format(Resources.Messages.MSG_GENERIC_UPLOAD_USERCARD_ERROR, Convert.ToString(row[UserCardExpenseEnum.Account_Number]), Convert.ToString(row[UserCardExpenseEnum.Card_Member])));
return(new ExcelFileProcess {
Message = string.Format(Resources.Messages.MSG_GENERIC_UPLOAD_USERCARD_ERROR, Convert.ToString(row[UserCardExpenseEnum.Account_Number]), Convert.ToString(row[UserCardExpenseEnum.Card_Member])), Response = true, MessageType = MessageClass.Error
});
}
userCardExp.UserCardID = userCard.UserCardID;
userCardExp.Date = Convert.ToDateTime(row[UserCardExpenseEnum.Date]);
userCardExp.RecieptNumber = Convert.ToString(row[UserCardExpenseEnum.Receipt_Number]);
userCardExp.Description = Convert.ToString(row[UserCardExpenseEnum.Description]);
userCardExp.BillType = Convert.ToString(row[UserCardExpenseEnum.BE_NBE]);
userCardExp.Amount = Convert.ToDecimal(row[UserCardExpenseEnum.Amount]);
userCardExp.IsSalesRelated = Convert.ToString(row[UserCardExpenseEnum.Sales_Related]).ToLower() == "yes";
userCardExp.TransactionType = Convert.ToString(row[UserCardExpenseEnum.Transaction_Type]);
userCardExp.Remarks = Convert.ToString(row[UserCardExpenseEnum.Remarks]);
userCardExp.ExpenseHead = Convert.ToString(row[UserCardExpenseEnum.Expense_Head]);
userCardExp.PaymentDetail = Convert.ToString(row[UserCardExpenseEnum.Payment_Detail]);
if (!string.IsNullOrWhiteSpace(Convert.ToString(row[UserCardExpenseEnum.Client_Number])))
{
Company company = companyManagement.GetCompanyByNumber(Convert.ToInt64(row[UserCardExpenseEnum.Client_Number]));
Guid companyId = Guid.NewGuid();
if (company == null)
{
logger.DebugFormat("Company Not Found Creating New Company With Name [{0}] and Number [{1}] and ID [{2}]", Convert.ToString(row[UserCardExpenseEnum.Client]), Convert.ToInt64(row[UserCardExpenseEnum.Client_Number]), companyId);
CreateNewCompany(Convert.ToString(row[UserCardExpenseEnum.Client]), Convert.ToInt64(row[UserCardExpenseEnum.Client_Number]), companyId);
}
else
{
companyId = company.CompanyID;
}
userCardExp.ClientID = companyId;
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(row[UserCardExpenseEnum.Consultant_Number])))
{
Consultant consultant = consultantManagement.GetConsultantByNumber(Convert.ToInt32(row[UserCardExpenseEnum.Consultant_Number]));
Guid consultantId = Guid.NewGuid();
if (consultant == null)
{
logger.DebugFormat("Consultant Not Found Creating New Consultant With Name [{0}] and Number [{1}] and ID [{2}]", Convert.ToString(row[UserCardExpenseEnum.Consultant]), Convert.ToInt64(row[UserCardExpenseEnum.Consultant_Number]), consultantId);
CreateNewConsultant(Convert.ToString(row[UserCardExpenseEnum.Consultant]), Convert.ToInt32(row[UserCardExpenseEnum.Consultant_Number]), consultantId);
}
else
{
consultantId = consultant.ConsultantID;
}
userCardExp.ConsultantID = consultantId;
}
userCardExpenseManagement.Add(userCardExp);
}
userCardExpenseManagement.SaveUserCardExpense();
logger.DebugFormat("Successfully Inserted Expense Sheet Data from File [{0}]", fileName);
return(new ExcelFileProcess {
Message = string.Format(Resources.Messages.MSG_GENERIC_UPLOAD_SUCCESS, fileName), Response = true, MessageType = MessageClass.Success
});
}
