public async Task <ActionResult> DistWindowOpen(int?distId)
{
StateMasterModel.District model = new StateMasterModel.District();
if (distId > 0)
{
var str1 = "";
var DistIdParam = new SqlParameter
{
ParameterName = "DistId",
DbType = DbType.Int32,
Value = distId
};
var StringDistParam = new SqlParameter
{
ParameterName = "StringDist",
DbType = DbType.String,
Value = str1
};
model = context.Database.SqlQuery <StateMasterModel.District>("Sp_DistMaster_GetAllDist @DistId,@StringDist", DistIdParam, StringDistParam).FirstOrDefault();
}
return(PartialView("_DistrictAddEdit", model));
}
public async Task <ActionResult> DistSave([DataSourceRequest] DataSourceRequest request, StateMasterModel.District model)
{
string message = string.Empty;
int result = 0;
try
{
var DistIdParam = new SqlParameter
{
ParameterName = "DistId",
DbType = DbType.Int32,
Value = model.DistId
};
var StateIdParam = new SqlParameter
{
ParameterName = "StateId",
DbType = DbType.Int32,
Value = model.StateId
};
var DistNameParam = new SqlParameter
{
ParameterName = "DistName",
DbType = DbType.String,
Value = model.DistName
};
var IsActiveParam = new SqlParameter
{
ParameterName = "IsActive",
DbType = DbType.Boolean,
Value = model.DistIsActive
};
result = context.Database.SqlQuery <int>("SP_DistrictMaster_DistrictInsertUpdate @DistId,@StateId,@DistName,@IsActive", DistIdParam, StateIdParam, DistNameParam, IsActiveParam).FirstOrDefault();
}
catch (Exception ex)
{
message = CommonHelper.GetErrorMessage(ex);
}
//return Json(new[] { model }.ToDataSourceResult(request));
return(Json(new { id = result }, JsonRequestBehavior.AllowGet));
}
