public ActionResult Save(Models.SBEntityModel model) { try { if (ModelState.IsValid) { CLayer.SBEntity data = new CLayer.SBEntity(); long cid = 0; long.TryParse(User.Identity.GetUserId(), out cid); data.Name = model.Name; data.Address = model.Address; data.GSTStateId = model.GSTState; data.GSTNo = model.GSTNo; data.StateId = data.GSTStateId; data.CountryId = Models.SBEntityModel.COUNTRY_INDIA; data.EntityId = model.EntityId; data.Phone = model.Phone; data.UserId = cid; BLayer.SBEntity.Save(data); } } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(RedirectToAction("Index")); }
public ActionResult Edit(long id) { Models.SBEntityModel model = new Models.SBEntityModel(); try { CLayer.SBEntity data = BLayer.SBEntity.Get(id); if (data == null) { model.LoadState(); model.EntityId = 0; return(View("_Edit", model)); } model.EntityId = data.EntityId; model.Name = data.Name; model.Address = data.Address; model.GSTState = data.GSTStateId; model.GSTNo = data.GSTNo; model.Phone = data.Phone; model.LoadState(); }catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(View("_Edit", model)); }
public long Save(CLayer.SBEntity data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pEntityId", DataPlug.DataType._BigInt, data.EntityId)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, data.Name)); param.Add(Connection.GetParameter("pAddress", DataPlug.DataType._Varchar, data.Address)); param.Add(Connection.GetParameter("pGSTNo", DataPlug.DataType._Varchar, data.GSTNo)); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, data.CountryId)); param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._BigInt, data.StateId)); param.Add(Connection.GetParameter("pGSTStateId", DataPlug.DataType._BigInt, data.GSTStateId)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, data.UserId)); param.Add(Connection.GetParameter("pPhone", DataPlug.DataType._Varchar, data.Phone)); object result = Connection.ExecuteQueryScalar("SBEntity_Save", param); return(Connection.ToLong(result)); }
public CLayer.SBEntity Get(long id) { CLayer.SBEntity result = null; DataTable dt = Connection.GetSQLTable("Select * from SBEntity Where EntityId=" + id.ToString()); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; result = new CLayer.SBEntity(); result.EntityId = Connection.ToLong(dr["EntityId"]); result.Name = Connection.ToString(dr["Name"]); result.Address = Connection.ToString(dr["Address"]); result.CountryId = Connection.ToInteger(dr["CountryId"]); result.GSTNo = Connection.ToString(dr["GSTNo"]); result.StateId = Connection.ToInteger(dr["StateId"]); result.GSTStateId = Connection.ToInteger(dr["GSTStateId"]); result.Phone = Connection.ToString(dr["Phone"]); } return(result); }
public static long Save(CLayer.SBEntity data) { DataLayer.SBEntity s = new DataLayer.SBEntity(); return(s.Save(data)); }