public ActionResult UpdateBlock(BlockMaster model)
{
db.BlockMasters.Add(model);
db.SaveChanges();
TempData[Constants.SuccessAlert] = "Block Updated Successfully";
return(RedirectToAction(nameof(UpdateBlock)));
}
public ActionResult CreateAndAddBlockUsage(BlockMaster blockmaster)
{
if (ModelState.IsValid)
{
blockmaster.COMPANYSITE = int.Parse(Session["companysite"].ToString());
BlockMaster blo = BM.Add(blockmaster, Session["userid"].ToString());
var model = BM.Find(blo.SID);
Session["SID_BLOCKMASTER"] = blo.SID;
model.GetSelectListLandConcession = GetSelectListLandConcession(model.LANDCONCESSION);
model.GetSelectListBlockOrganization = GetSelectListBlockOrganization(model.BLOCKORGANIZATION);
model.GetSelectListSoilType = GetSelectListSoilType(model.SOILTYPE);
model.GetSelectListVegetation = GetSelectListVegetation(model.VEGETATION);
model.GetSelectListTopograph = GetSelectListTopograph(model.TOPOGRAPH);
return(View("Edit", model));
}
else
{
blockmaster.GetSelectListLandConcession = GetSelectListLandConcession();
blockmaster.GetSelectListBlockOrganization = GetSelectListBlockOrganization();
blockmaster.GetSelectListSoilType = GetSelectListSoilType();
blockmaster.GetSelectListVegetation = GetSelectListVegetation();
blockmaster.GetSelectListTopograph = GetSelectListTopograph();
return(View(blockmaster));
}
}
public BlockMaster Add(BlockMaster BLO, string userid)
{
var sqlQuery = @"INSERT INTO BLOCKMASTER (IDBLOCKMASTER, BLOCKMASTERNAME, LANDCONCESSION, BLOCKORGANIZATION, SOILTYPE, VEGETATION, TOPOGRAPH, HECTARAGE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
('" + BLO.IDBLOCKMASTER + @"', '" + BLO.BLOCKMASTERNAME + "', '" + BLO.LANDCONCESSION + "', '" + BLO.BLOCKORGANIZATION + "', '" + BLO.SOILTYPE + "', '" + BLO.VEGETATION + "', '" + BLO.TOPOGRAPH + "', '" + BLO.HECTARAGE + "', '" + BLO.COMPANYSITE + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query <int>(sqlQuery, BLO).Single();
BLO.SID = SID;
return(BLO);
}
//
// GET: /BlockMaster/Create
public ActionResult Create()
{
var model = new BlockMaster();
model.GetSelectListLandConcession = GetSelectListLandConcession();
model.GetSelectListBlockOrganization = GetSelectListBlockOrganization();
model.GetSelectListSoilType = GetSelectListSoilType();
model.GetSelectListVegetation = GetSelectListVegetation();
model.GetSelectListTopograph = GetSelectListTopograph();
return(View(model));
}
public ActionResult Create(BlockMaster blockmaster)
{
if (ModelState.IsValid)
{
blockmaster.COMPANYSITE = int.Parse(Session["companysite"].ToString());
BM.Add(blockmaster, Session["userid"].ToString());
TempData["successmessage"] = "Saved successfully";
return(RedirectToAction("Create"));
}
else
{
blockmaster.GetSelectListLandConcession = GetSelectListLandConcession();
blockmaster.GetSelectListBlockOrganization = GetSelectListBlockOrganization();
blockmaster.GetSelectListSoilType = GetSelectListSoilType();
blockmaster.GetSelectListVegetation = GetSelectListVegetation();
blockmaster.GetSelectListTopograph = GetSelectListTopograph();
return(View(blockmaster));
}
}
public BlockMaster Update(BlockMaster BLO)
{
var sqlQuery =
"UPDATE BLOCKMASTER " +
"SET IDBLOCKMASTER = '" + BLO.IDBLOCKMASTER + "', " +
" BLOCKMASTERNAME = '" + BLO.BLOCKMASTERNAME + "', " +
" LANDCONCESSION = '" + BLO.LANDCONCESSION + "', " +
" BLOCKORGANIZATION = '" + BLO.BLOCKORGANIZATION + "', " +
" SOILTYPE = '" + BLO.SOILTYPE + "', " +
" VEGETATION = '" + BLO.VEGETATION + "', " +
" TOPOGRAPH = '" + BLO.TOPOGRAPH + "', " +
" HECTARAGE = '" + BLO.HECTARAGE + "', " +
" COMPANYSITE = '" + BLO.COMPANYSITE + "', " +
" UPDATEBY = '" + Convert.ToInt32(BLO.UPDATEBY) + "', " +
" UPDATEDATE = '" + BLO.UPDATEDATE + "' " +
"WHERE SID = " + BLO.SID + "";
this._db.Execute(sqlQuery, BLO);
return(BLO);
}
public ActionResult Edit(BlockMaster blockmaster, int id)
{
if (ModelState.IsValid)
{
blockmaster.SID = id;
blockmaster.COMPANYSITE = int.Parse(Session["companysite"].ToString());
blockmaster.UPDATEBY = int.Parse(Session["userid"].ToString());
blockmaster.UPDATEDATE = DateTime.Now;
BM.Update(blockmaster);
return(View("Index", BM.GetAllByCompanySite(int.Parse(Session["companysite"].ToString()))));
}
else
{
blockmaster.GetSelectListLandConcession = GetSelectListLandConcession(blockmaster.LANDCONCESSION);
blockmaster.GetSelectListBlockOrganization = GetSelectListBlockOrganization(blockmaster.BLOCKORGANIZATION);
blockmaster.GetSelectListSoilType = GetSelectListSoilType(blockmaster.SOILTYPE);
blockmaster.GetSelectListVegetation = GetSelectListVegetation(blockmaster.VEGETATION);
blockmaster.GetSelectListTopograph = GetSelectListTopograph(blockmaster.TOPOGRAPH);
return(View(blockmaster));
}
}
// Use this for initialization
void Awake()
{
s = this;
justCreatedBlockTypes = new List <string> ();
}