public async Task <IActionResult> Edit(int id, [Bind("ID,UserID,Quantity,Price")] Proforma1 proforma1) { if (id != proforma1.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(proforma1); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProformaExists(proforma1.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(proforma1)); }
public async Task <IActionResult> Create([Bind("ID,UserID,Quantity,Price")] Proforma1 proforma1) { if (ModelState.IsValid) { _context.Add(proforma1); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(proforma1)); }
//To Insert Proforma1 Details to Db public bool InsertProforma1Details(Proforma1 entity) { bool val = false; IDataReader dr = null; try { dbManager.Open(); dbManager.BeginTransaction(); dbManager.CreateParameters(28); dbManager.AddParameters(0, "", GetDBNullOrValue(entity.districts.DistrictCode), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(1, "", GetDBNullOrValue(entity.mandals.MandalCode), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(2, "", GetDBNullOrValue(entity.villages.VillageCode), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(3, "", GetDBNullOrValue(entity.WlRsrBaseSurveyNo), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(4, "", GetDBNullOrValue(entity.WlRsrSubDivNo), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(5, "", GetDBNullOrValue(entity.WlRsrExtent), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(6, "", GetDBNullOrValue(entity.OriginalBaseSurveyNo), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(7, "", GetDBNullOrValue(entity.OriginalSubDivNo), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(8, "", GetDBNullOrValue(entity.OriginalExtent), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(9, "", GetDBNullOrValue(entity.OriginalRsrExtentType), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(10, "", GetDBNullOrValue(entity.OriginalClasfctn), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(11, "", GetDBNullOrValue(entity.OriginalLandNature), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(12, "", GetDBNullOrValue(entity.WebLandLandNature), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(13, "", GetDBNullOrValue(entity.PattadarCategory), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(14, "", GetDBNullOrValue(entity.IsExtentSame), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(15, "", GetDBNullOrValue(entity.IsClassificationSame), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(16, "", GetDBNullOrValue(entity.IsLandNatureSame), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(17, "", GetDBNullOrValue(entity.IsRecordTallied), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(18, "", GetDBNullOrValue(entity.ExtentDiffEntered), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(19, "", GetDBNullOrValue(entity.RectificationReasonType), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(20, "", GetDBNullOrValue(entity.PendingReasonType), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(21, "", GetDBNullOrValue(entity.WeblandClasfctn), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(22, "", GetDBNullOrValue(entity.WebLandRsrRemarks), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(23, "", GetDBNullOrValue(entity.OriginalRsrRemarks), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(24, "", GetDBNullOrValue(entity.FilePath), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(25, "", GetDBNullOrValue(entity.BaseFrom), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(26, "", GetDBNullOrValue(entity.Recordstatus), ParameterDirection.Input, DaoConstants.InParamSize); dbManager.AddParameters(27, "", GetDBNullOrValue(entity.RecordApprovedStatus), ParameterDirection.Input, DaoConstants.InParamSize); int iResult = Convert.ToInt32(dbManager.ExecuteNonQuery(CommandType.StoredProcedure, "USP_InsertScrollingTextInfo")); if (iResult > 0) { dbManager.CommitTransaction(); val = true; } else { dbManager.RollBackTransaction(); val = false; } return(val); } catch (Exception ex) { if (dr != null) { dr.Close(); } val = false; //Errorlog.WriteToErrorLog(ex, "", "", "Class : CommonDal, Method : InsertScrollingText,SP : USP_InsertScrollingTextInfo"); dbManager.RollBackTransaction(); return(false); } finally { if (dr != null) { dr.Close(); } if (entity != null) { dbManager.Dispose(); dbManager = null; } } }