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