public LandConcession Add(LandConcession LCC, string userid) { var sqlQuery = @"INSERT INTO LANDCONCESSION (IDCONCESSION, CONCESSIONNAME, PERMISSIONNO, PERMISSIONTYPE, PERMISSIONDATE, STARTDATE, ENDDATE, COUNTRY, PROVINCE, CITY, HECTARAGE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES ('" + LCC.IDCONCESSION + @"', '" + LCC.CONCESSIONNAME + "', '" + LCC.PERMISSIONNO + @"','" + LCC.PERMISSIONTYPE + @"', '" + LCC.PERMISSIONDATE + @"', '" + LCC.STARTDATE + @"', '" + LCC.ENDDATE + @"', '" + LCC.COUNTRY + @"', '" + LCC.PROVINCE + @"', '" + LCC.CITY + @"', '" + LCC.HECTARAGE + @"', '" + LCC.COMPANYSITE + @"'," + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var SID = _db.Query <int>(sqlQuery, LCC).Single(); LCC.SID = SID; return(LCC); }
public LandConcession Update(LandConcession LCC, string userid) { var sqlQuery = string.Format(@"UPDATE LANDCONCESSION SET CONCESSIONNAME = '{0}', PERMISSIONNO = '{1}', PERMISSIONTYPE = '{2}', PERMISSIONDATE = '{3}', STARTDATE = '{4}', ENDDATE = '{5}', COUNTRY = '{6}', PROVINCE = '{7}', CITY = '{8}', HECTARAGE = '{9}', COMPANYSITE = '{10}', UPDATEBY = {11}, UPDATEDATE = '{12}' WHERE SID = {13}", LCC.CONCESSIONNAME, LCC.PERMISSIONNO, LCC.PERMISSIONTYPE, LCC.PERMISSIONDATE, LCC.STARTDATE, LCC.ENDDATE, LCC.COUNTRY, LCC.PROVINCE, LCC.CITY, LCC.HECTARAGE, LCC.COMPANYSITE, Convert.ToInt32(userid), DateTime.Now, LCC.SID); this._db.Execute(sqlQuery, LCC); return(LCC); }
// // GET: /LandConcession/Create public ActionResult Create() { var model = new LandConcession(); model.GetSelectListPermissionType = GetSelectListPermissionType(); model.GetSelectListCountry = GetSelectListCountry(); model.GetSelectListProvince = GetSelectListProvince(); model.GetSelectListCity = GetSelectListCity(); return(View(model)); }
public ActionResult Edit(LandConcession LandConcession) { if (ModelState.IsValid) { LandConcession.COMPANYSITE = int.Parse(Session["companysite"].ToString()); LCC.Update(LandConcession, Session["userid"].ToString()); TempData["successmessage"] = "Saved successfully"; return(RedirectToAction("Index")); } else { LandConcession.GetSelectListPermissionType = GetSelectListPermissionType(); LandConcession.GetSelectListCountry = GetSelectListCountry(); LandConcession.GetSelectListProvince = GetSelectListProvince(); LandConcession.GetSelectListCity = GetSelectListCity(); return(View(LandConcession)); } }