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")); }