public ActionResult StateWindowOpen(int?stateId)
{
StateMasterModel.State model = new StateMasterModel.State();
if (stateId > 0)
{
var StateIdParam = new SqlParameter
{
ParameterName = "StateId",
DbType = DbType.Int32,
Value = stateId
};
model = context.Database.SqlQuery <StateMasterModel.State>("Sp_StateMaster_GetAllState @StateId", StateIdParam).FirstOrDefault();
}
return(PartialView("_StateAddEdit", model));
}
public async Task <ActionResult> StateSave([DataSourceRequest] DataSourceRequest request, StateMasterModel.State model)
{
string message = string.Empty;
int result = 0;
try
{
var StateIdParam = new SqlParameter
{
ParameterName = "StateId",
DbType = DbType.Int32,
Value = model.StateId
};
var StateNameParam = new SqlParameter
{
ParameterName = "StateName",
DbType = DbType.String,
Value = model.StateName
};
var IsActiveParam = new SqlParameter
{
ParameterName = "IsActive",
DbType = DbType.Boolean,
Value = model.IsActive
};
result = context.Database.SqlQuery <int>("SP_StateMaster_StateInsertUpdate @StateId,@StateName,@IsActive", StateIdParam, StateNameParam, IsActiveParam).FirstOrDefault();
}
catch (Exception ex)
{
message = CommonHelper.GetErrorMessage(ex);
}
return(Json(new { id = result }, JsonRequestBehavior.AllowGet));
}
