public static async Task <int> AddSiteDB(WebApiProxy proxy, SiteDbModel SiteDBObject, bool IsNewObject = false) { Dictionary <string, object> dicParams = new Dictionary <string, object>(); if (IsNewObject) { dicParams.Add("@Id", -1); } else { dicParams.Add("@Id", SiteDBObject.Id); } dicParams.Add("@Name", SiteDBObject.Name); dicParams.Add("@Server", SiteDBObject.Server); dicParams.Add("@Database", SiteDBObject.Database); dicParams.Add("@UserID", SiteDBObject.UserID); dicParams.Add("@Password", SiteDBObject.Password); dicParams.Add("@Description", SiteDBObject.Description); dicParams.Add("@SiteId", SiteDBObject.SiteId); DataSet dataSet = await proxy.ExecuteDataset("SP_SiteDBAddUp", dicParams); if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count > 0) { if (dataSet.Tables[0].Rows != null && dataSet.Tables[0].Rows.Count > 0) { int SiteDB = Convert.ToInt32(dataSet.Tables[0].Rows[0][0].ToString()); return(SiteDB); } } return(-1); }
public async Task <JsonResult> AddUpdateRecord(SiteDbModel ModelObject) { string Status = string.Empty; await Task.Run(() => { Status = base.BaseAddUpdateRecord(ModelObject, ModelState, proxy).Result; } ); return(Json(new { status = Status })); }
public ActionResult DeleteRecord(int id, int SiteID) { string Status = string.Empty; SiteDbModel modeldata = new SiteDbModel(); modeldata.Id = id; Status = base.BaseDeleteRecord(modeldata, ModelState, proxy); return(RedirectToAction("GetAllSiteDb", new { SiteId = SiteID })); }