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));
}
