public long Save(CLayer.HSNCode data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCodeId", DataPlug.DataType._BigInt, data.CodeId)); param.Add(Connection.GetParameter("pService", DataPlug.DataType._Varchar, data.NatureOfService)); param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, data.Code)); object result = Connection.ExecuteQueryScalar("HSNCode_Save", param); return(Connection.ToLong(result)); }
public CLayer.HSNCode Get(long id) { CLayer.HSNCode result = null; DataTable dt = Connection.GetSQLTable("Select * from HSNCode Where CodeId=" + id.ToString()); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; result = new CLayer.HSNCode(); result.CodeId = Connection.ToLong(dr["CodeId"]); result.NatureOfService = Connection.ToString(dr["NatureOfService"]); result.Code = Connection.ToString(dr["HSNCode"]); result.Status = Connection.ToInteger(dr["Status"]); } return(result); }
public ActionResult Edit(long id) { Models.HSNCodeModel model = new Models.HSNCodeModel(); try { CLayer.HSNCode data = BLayer.HSNCode.Get(id); if (data == null) { model.CodeId = 0; return(View("_Edit", model)); } model.CodeId = data.CodeId; model.NatureOfService = data.NatureOfService; model.HSNCode = data.Code; } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(View("_Edit", model)); }
public ActionResult Save(Models.HSNCodeModel model) { try { if (ModelState.IsValid) { CLayer.HSNCode data = new CLayer.HSNCode(); long cid = 0; long.TryParse(User.Identity.GetUserId(), out cid); data.CodeId = model.CodeId; data.NatureOfService = model.NatureOfService; data.Code = model.HSNCode; BLayer.HSNCode.Save(data); } } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(RedirectToAction("Index")); }
public static long Save(CLayer.HSNCode data) { DataLayer.HSNCode hsn = new DataLayer.HSNCode(); return(hsn.Save(data)); }