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