public etblBankDetail GetBankDetailByPropId()
{
etblBankDetail objBank = new etblBankDetail();
try
{
objBank = BL_tblBankDetailM.GetSingleRecordById(Convert.ToInt32(Session["PropId"].ToString()));
}
catch (Exception)
{
throw;
}
return(objBank);
}
//Get Single Record
public static etblBankDetail GetSingleRecordById(int id)
{
etblBankDetail eobj = new etblBankDetail();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobj = db.tblBankDetailMs.SingleOrDefault(u => u.iPropId == id);
if (dbobj != null)
{
eobj = (etblBankDetail)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj);
}
else
{
eobj.iPropId = id;
}
}
return(eobj);
}
//Add new record
public static int AddRecord(etblBankDetail eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblBankDetailM dbuser = (OneFineRate.tblBankDetailM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblBankDetailM());
db.tblBankDetailMs.Add(dbuser);
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Add new record
public static int AddOrUpdateRecord(etblBankDetail eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var existingRecord = db.tblBankDetailMs.Find(eobj.iPropId);
if (existingRecord != null)
{
existingRecord.dCommission = eobj.dCommission;
existingRecord.dtActionDate = eobj.dtActionDate;
existingRecord.dtModifyDate = eobj.dtModifyDate;
existingRecord.iActionBy = eobj.iActionBy;;
existingRecord.iModifyBy = eobj.iModifyBy;
existingRecord.sBaneficiariesName = eobj.sBaneficiariesName;
existingRecord.sBankAccountNo = eobj.sBankAccountNo;
existingRecord.sBankName = eobj.sBankName;
existingRecord.sBranchAddress = eobj.sBranchAddress;
existingRecord.sBranchName = eobj.sBranchName;
existingRecord.sFEmailId = eobj.sFEmailId;
existingRecord.sFFaxNo = eobj.sFFaxNo;
existingRecord.sFName = eobj.sFName;
existingRecord.sFPhoneNo = eobj.sFPhoneNo;
existingRecord.sIfscCode = eobj.sIfscCode;
existingRecord.sMicrCode = eobj.sMicrCode;
existingRecord.sRegisteredEntityName = eobj.sRegisteredEntityName;
existingRecord.sGstinNumber = eobj.sGstinNumber;
existingRecord.iStateId = eobj.iStateId;
existingRecord.sPanNumber = eobj.sPanNumber;
existingRecord.sEntityType = eobj.sEntityType;
//if (string.IsNullOrEmpty(existingRecord.sCancelledCheque) && !string.IsNullOrEmpty(eobj.sCancelledCheque))
//{
// existingRecord.sCancelledCheque = eobj.sCancelledCheque;
//}
//if (string.IsNullOrEmpty(existingRecord.sLetterhead_BankAccount) && !string.IsNullOrEmpty(eobj.sLetterhead_BankAccount))
//{
// existingRecord.sLetterhead_BankAccount = eobj.sLetterhead_BankAccount;
//}
//if (string.IsNullOrEmpty(existingRecord.sPanCard) && !string.IsNullOrEmpty(eobj.sPanCard))
//{
// existingRecord.sPanCard = eobj.sPanCard;
//}
if (!string.IsNullOrEmpty(eobj.sCancelledCheque))
{
existingRecord.sCancelledCheque = eobj.sCancelledCheque;
}
if (!string.IsNullOrEmpty(eobj.sLetterhead_BankAccount))
{
existingRecord.sLetterhead_BankAccount = eobj.sLetterhead_BankAccount;
}
if (!string.IsNullOrEmpty(eobj.sPanCard))
{
existingRecord.sPanCard = eobj.sPanCard;
}
db.Entry(existingRecord).State = System.Data.Entity.EntityState.Detached;
db.Entry(existingRecord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 2;
}
else
{
retval = AddRecord(eobj);
}
}
catch (DbEntityValidationException e)
{
string validationMessage = string.Empty;
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
validationMessage += ve.ErrorMessage;
}
}
throw new DbEntityValidationException(validationMessage);
}
}
return(retval);
}
public ActionResult Add(etblBankDetail bank)
{
if (ModelState.IsValid)
{
try
{
bank.dtActionDate = DateTime.UtcNow;
if (Session["UserDetails"] != null)
{
bank.iActionBy = Convert.ToInt16(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId);
}
var containerName = Convert.ToInt32(Session["PropId"].ToString()).ToString();
if (bank.CancelledCheque != null)
{
using (MemoryStream target = new MemoryStream())
{
bank.CancelledCheque.InputStream.CopyTo(target);
byte[] data = target.ToArray();
// Since old file will automatically replaced by new one (as their name is same ) , So no need to delete exiting one.
var absoluteUrl = clsUtils.fnUploadFileINBlobStorage(containerName, "cancelledcheque" + Path.GetExtension(bank.CancelledCheque.FileName), data, false);
bank.sCancelledCheque = containerName + "/cancelledcheque" + Path.GetExtension(bank.CancelledCheque.FileName);
}
}
if (bank.PanCard != null)
{
using (MemoryStream target = new MemoryStream())
{
bank.PanCard.InputStream.CopyTo(target);
byte[] data = target.ToArray();
var absoluteUrl = clsUtils.fnUploadFileINBlobStorage(containerName, "pancard" + Path.GetExtension(bank.PanCard.FileName), data, false);
bank.sPanCard = containerName + "/pancard" + Path.GetExtension(bank.PanCard.FileName);
}
}
if (bank.Letterhead_BankAccount != null)
{
using (MemoryStream target = new MemoryStream())
{
bank.Letterhead_BankAccount.InputStream.CopyTo(target);
byte[] data = target.ToArray();
var absoluteUrl = clsUtils.fnUploadFileINBlobStorage(containerName, "letterheadbankaccount" + Path.GetExtension(bank.Letterhead_BankAccount.FileName), data, false);
bank.sLetterhead_BankAccount = containerName + "/letterheadbankaccount" + Path.GetExtension(bank.Letterhead_BankAccount.FileName);
}
}
var returnValue = BL_tblBankDetailM.AddOrUpdateRecord(bank);
if (returnValue == 1)
{
TempData["msg"] = "Details has been added";
}
else if (returnValue == 2)
{
TempData["msg"] = "Details has been modified";
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["ERROR"] = ex.Message;
}
}
else
{
TempData["ERROR"] = "Validation failed ! Please correct the errors and try again.";
}
return(View("BankDetail", bank));
}
