public ActionResult Edit(ChequeDetail objChequeDetail)
{
if (ModelState.IsValid)
{
ChequeDetailBLL objChequeDetailBLL = new ChequeDetailBLL();
objChequeDetailBLL.UpdateChequeDetail(objChequeDetail);
}
return(RedirectToAction("Index", "ChequeDetail"));
}
public ActionResult Save()
{
ChequeDetailBLL objChequeDetailBLL = new ChequeDetailBLL();
var model = new ChequeDetail
{
BankNameInfo = objChequeDetailBLL.GetBankName()
};
return(View(model));
}
public ActionResult Save(ChequeDetail objChequeDetail)
{
if (ModelState.IsValid)
{
ChequeDetailBLL objChequeDetailBLL = new ChequeDetailBLL();
objChequeDetailBLL.SaveChequeDetailInfo(objChequeDetail);
}
return(RedirectToAction("Index", "ChequeDetail"));
}
public bool AddCheque(ChequeDetail cd)
{
if (ModelState.IsValid)
{
int found = db.ChequeDetails.Count(m => m.cheque_no == cd.cheque_no);
if (found == 0)
{
db.ChequeDetails.Add(cd);
db.SaveChanges();
return(true);
}
}
return(false);
}
public ActionResult ChequeDetail(RenderModel model, string contentId)
{
var parent = model.Content.Parent;
ChequesList chequeList = parent.As <ChequesList>();
var list = ContentHelper.GetById <ChequesList>(parent.Id);
var chqDtl = list.ListOfCheques.FirstOrDefault(c => c.Name.Equals(contentId, System.StringComparison.InvariantCultureIgnoreCase));
ChequeDetail chequeDtl = model.As <ChequeDetail>();
chequeDtl.ChequeDtl = chqDtl;
RenderPage <ChequeDetail> viewModel = new RenderPage <ChequeDetail>(chequeDtl);
return(this.CurrentTemplate(viewModel));
}
public string UpdateChequeDetail(ChequeDetail objChequeDetail)
{
int noRowCount = 0;
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
objDbCommand.AddInParameter("ChequeDetailId", objChequeDetail.ChequeDetailId);
objDbCommand.AddInParameter("ChequeNumber", objChequeDetail.ChequeNumber);
objDbCommand.AddInParameter("BankDetailId", objChequeDetail.BankName);
objDbCommand.AddInParameter("ChequeAmount", objChequeDetail.ChequeAmount);
objDbCommand.AddInParameter("ChequeIssueDate", objChequeDetail.ChequeIssueDateShow);
objDbCommand.AddInParameter("ChequeSubmitDate", objChequeDetail.ChequeSubmitDateShow);
objDbCommand.AddInParameter("ChequeMaturedDate", objChequeDetail.ChequeMaturedDateShow);
objDbCommand.AddInParameter("ChequeStatus", objChequeDetail.ChequeStatusShow);
objDbCommand.AddInParameter("IsActive", objChequeDetail.IsActive);
objDbCommand.AddInParameter("UpdatedBy", SessionUtility.STSessionContainer.UserID);
try
{
noRowCount = objDataAccess.ExecuteNonQuery(objDbCommand, "[dbo].uspUpdateChequeDetail", CommandType.StoredProcedure);
if (noRowCount > 0)
{
objDbCommand.Transaction.Commit();
return("Save Successfully");
}
else
{
objDbCommand.Transaction.Rollback();
return("Save Failed");
}
}
catch (Exception ex)
{
objDbCommand.Transaction.Rollback();
throw new Exception("Database Error Occured", ex);
}
finally
{
objDataAccess.Dispose(objDbCommand);
}
}
public ChequeDetail GetChequeDetail(int id)
{
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted);
DbDataReader objDbDataReader = null;
List <ChequeDetail> objChequeDetailList = new List <ChequeDetail>();
ChequeDetail objChequeDetail = new ChequeDetail();
try
{
objDbCommand.AddInParameter("ChequeDetailId", id);
objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[dbo].[uspGetChequeDetailById]", CommandType.StoredProcedure);
if (objDbDataReader.HasRows)
{
while (objDbDataReader.Read())
{
objChequeDetail = new ChequeDetail();
this.BuildModelForBuildModelForChequeDetail(objDbDataReader, objChequeDetail);
objChequeDetailList.Add(objChequeDetail);
}
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
if (objDbDataReader != null)
{
objDbDataReader.Close();
}
objDataAccess.Dispose(objDbCommand);
}
return(objChequeDetail);
}
private void BuildModelForBuildModelForChequeDetail(DbDataReader objDataReader, ChequeDetail objChequeDetail)
{
DataTable objDataTable = objDataReader.GetSchemaTable();
foreach (DataRow dr in objDataTable.Rows)
{
String column = dr.ItemArray[0].ToString();
switch (column)
{
case "ChequeDetailId":
if (!Convert.IsDBNull(objDataReader["ChequeDetailId"]))
{
objChequeDetail.ChequeDetailId = Convert.ToInt32(objDataReader["ChequeDetailId"]);
}
break;
case "ChequeIssuedBy":
if (!Convert.IsDBNull(objDataReader["ChequeIssuedBy"]))
{
objChequeDetail.ChequeIssuedBy = Convert.ToByte(objDataReader["ChequeIssuedBy"].ToString());
}
break;
case "ChequeIssuedByShow":
if (!Convert.IsDBNull(objDataReader["ChequeIssuedByShow"]))
{
objChequeDetail.ChequeIssuedByShow = objDataReader["ChequeIssuedByShow"].ToString();
}
break;
case "OwnerId":
if (!Convert.IsDBNull(objDataReader["OwnerId"]))
{
objChequeDetail.OwnerId = Convert.ToByte(objDataReader["OwnerId"]);
}
break;
case "OwnerName":
if (!Convert.IsDBNull(objDataReader["OwnerName"]))
{
objChequeDetail.OwnerName = objDataReader["OwnerName"].ToString();
}
break;
case "ChequeNumber":
if (!Convert.IsDBNull(objDataReader["ChequeNumber"]))
{
objChequeDetail.ChequeNumber = objDataReader["ChequeNumber"].ToString();
}
break;
case "BankDetailId":
if (!Convert.IsDBNull(objDataReader["BankDetailId"]))
{
objChequeDetail.BankDetailId = Convert.ToByte(objDataReader["BankDetailId"]);
}
break;
case "BankName":
if (!Convert.IsDBNull(objDataReader["BankName"]))
{
objChequeDetail.BankName = objDataReader["BankName"].ToString();
}
break;
case "ChequeAmount":
if (!Convert.IsDBNull(objDataReader["ChequeAmount"]))
{
objChequeDetail.ChequeAmount = Convert.ToDecimal(objDataReader["ChequeAmount"]);
}
break;
case "ChequeIssueDate":
if (!Convert.IsDBNull(objDataReader["ChequeIssueDate"]))
{
objChequeDetail.ChequeIssueDateShow = string.Format("{0:dd/MM/yyyy}", objDataReader["ChequeIssueDate"]);
}
break;
case "ChequeSubmitDate":
if (!Convert.IsDBNull(objDataReader["ChequeSubmitDate"]))
{
objChequeDetail.ChequeSubmitDateShow = string.Format("{0:dd/MM/yyyy}", objDataReader["ChequeSubmitDate"]);
}
break;
case "ChequeMaturedDate":
if (!Convert.IsDBNull(objDataReader["ChequeMaturedDate"]))
{
objChequeDetail.ChequeMaturedDateShow = string.Format("{0:dd/MM/yyyy}", objDataReader["ChequeMaturedDate"]);
}
break;
case "ChequeStatus":
if (!Convert.IsDBNull(objDataReader["ChequeStatus"]))
{
objChequeDetail.ChequeStatusShow = objDataReader["ChequeStatus"].ToString();
}
break;
//case "ChequeStatusShow":
// if (!Convert.IsDBNull(objDataReader["ChequeStatus"]))
// {
// objChequeDetail.ChequeStatusShow = objDataReader["ChequeStatus"].ToString();
// }
// break;
case "IsActive":
if (!Convert.IsDBNull(objDataReader["IsActive"]))
{
objChequeDetail.IsActive = Convert.ToBoolean(objDataReader["IsActive"].ToString());
}
break;
case "UserStatus":
if (!Convert.IsDBNull(objDataReader["UserStatus"]))
{
objChequeDetail.UserStatus = objDataReader["UserStatus"].ToString();
}
break;
case "CreatedBy":
if (!Convert.IsDBNull(objDataReader["CreatedBy"]))
{
objChequeDetail.CreatedBy = Convert.ToInt16(objDataReader["CreatedBy"]);
}
break;
case "CreatedDate":
if (!Convert.IsDBNull(objDataReader["CreatedDate"]))
{
objChequeDetail.CreatedDate = Convert.ToDateTime(objDataReader["CreatedDate"].ToString());
}
break;
case "UpdatedBy":
if (!Convert.IsDBNull(objDataReader["UpdatedBy"]))
{
objChequeDetail.UpdatedBy = Convert.ToInt16(objDataReader["UpdatedBy"].ToString());
}
break;
case "UpdatedDate":
if (!Convert.IsDBNull(objDataReader["UpdatedDate"]))
{
objChequeDetail.UpdatedDate = Convert.ToDateTime(objDataReader["UpdatedDate"].ToString());
}
break;
case "SortedBy":
if (!Convert.IsDBNull(objDataReader["SortedBy"]))
{
objChequeDetail.SortedBy = Convert.ToByte(objDataReader["SortedBy"].ToString());
}
break;
case "Remarks":
if (!Convert.IsDBNull(objDataReader["Remarks"]))
{
objChequeDetail.Remarks = objDataReader["Remarks"].ToString();
}
break;
default:
break;
}
}
}
public ActionResult AddProperty(Property p, HttpPostedFileBase[] files)
{
//Users oUser=(Users)Session["logged"];
//p.created_by = oUser.Id;
p.created_by = 1;
p.created_date = DateTime.Now;
p.owner_id = 1;
//if (files != null)
//{
// string path="";
// foreach (HttpPostedFileBase file in files)
// {
// string picture = Path.GetFileName(file.FileName);
// path = Path.Combine(Server.MapPath("~/Content/PropertyDox"), picture);
// string[] paths = path.Split('.');
// string time = DateTime.UtcNow.ToString();
// time = time.Replace(" ", "-");
// time = time.Replace(":", "-");
// file.SaveAs(paths[0] + "-" + time + Path.GetExtension(file.FileName));
// }
// p.file=path;
//}
//p.rent = Convert.ToDecimal(Request["rent"]);
//p.commission = Convert.ToDecimal(Request["commission"]);
//p.no_beds = Convert.ToInt32(Request["beds"]);
//p.no_cheques = Convert.ToInt32(Request["cheques"]);
//p.deposite = Convert.ToDecimal(Request["deposite"]);
if (ModelState.IsValid)
{
db.Properties.Add(p);
db.SaveChanges();
int?propertyId = p.id;
var m = PropertyController.GetMonthDifference(p.contract_start_date, p.contract_end_date);
int m_diff = Convert.ToInt32(m / p.no_cheques);
decimal cheque_Amount = p.rent / p.no_cheques;
DateTime dateStart = p.contract_start_date;
ChequeDetail cd;
Random rand = new Random();
for (int i = 0; i < p.no_cheques; i++)
{
cd = new ChequeDetail()
{
cheque_amount = cheque_Amount,
cheque_date = dateStart,
cheque_till = dateStart.AddMonths(m_diff),
cheque_by_id = 2,
appartment_id = propertyId,
cheque_no = rand.Next()
};
var added = new ChequeDetailsController().AddCheque(cd);
//if (added == false)
//{
// new ChequeDetailsController().DelAllPropCheques(propId);
// this.DeleteProperty(propId);
// break;
//}
dateStart = dateStart.AddMonths(m_diff);
}
}
return(RedirectToAction("AddProperty"));
}
