public JsonResult Update(TerritoriesModel mdterr)
{
bool result = false;
object[] message = new object[3];
int RetCode = 1;
string RetMesg = "";
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
try
{
mdterr.Activity = "UPDATE";
if (mdterr != null & ModelState.IsValid)
{
result = data.UpdDelTerri(mdterr, ref RetCode, ref RetMesg);
message[0] = RetMesg;
message[1] = RetCode;
}
}
catch (Exception ex)
{
result = false;
throw ex;
}
//ViewData["TerritoriesList"] = result;
return(Json(new { mess = RetMesg, code = RetCode }, JsonRequestBehavior.AllowGet));
//return View();
}
public JsonResult Create(TerritoriesModel mdterr)
{
object[] message = new object[3];
DataTable dt = new DataTable();
int RetCode = 1;
string RetMesg = "";
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
try
{
mdterr.Activity = "INSERT";
if (mdterr != null & ModelState.IsValid)
{
dt = data.InsertTerri(mdterr, ref RetCode, ref RetMesg);
message[0] = RetMesg;
message[1] = RetCode;
}
//if(dt.Rows.Count > 0)
//{
// message[2] = dt;
//}
}
catch (Exception ex)
{
dt = null;
throw ex;
}
return(Json(new { mess = message }, JsonRequestBehavior.AllowGet));
//return View();
}
public ActionResult Territories()
{
int RetCode = 1;
string RetMesg = "";
DataSet ds = new DataSet();
List <TerritoriesModel> result = new List <TerritoriesModel>();
TerritoriesModel mdterr = new TerritoriesModel();
mdterr.Activity = "SELECT";
mdterr.ProvinceId = "";
mdterr.DistrictId = "";
mdterr.WardsId = "";
try
{
result = data.TerritoriesGet(mdterr, ref RetCode, ref RetMesg);
}
catch (Exception ex)
{
result = null;
throw ex;
}
ViewData["TerritoriesList"] = result;
return(View());
}
/// <summary>
/// Delete/Update Territories
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
#region Update/Delete Territories
public bool UpdDelTerri(TerritoriesModel mdterr, ref int RetCode, ref string RetMesg)
{
bool result = false;
List <string> error = new List <string>();
DataSet ds = new DataSet();
try
{
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@Activity", SqlDbType.NVarChar, 20);
para[0].Direction = ParameterDirection.Input;
para[0].Value = mdterr.Activity;
para[1] = new SqlParameter("@ProvincesName", SqlDbType.NVarChar, 50);
para[1].Direction = ParameterDirection.Input;
para[1].Value = mdterr.ProvinceName;
para[2] = new SqlParameter("@DistrictName", SqlDbType.NVarChar, 50);
para[2].Direction = ParameterDirection.Input;
para[2].Value = mdterr.DistrictName;
para[3] = new SqlParameter("@WardsName", SqlDbType.NVarChar, 50);
para[3].Direction = ParameterDirection.Input;
para[3].Value = mdterr.WardsName;
para[4] = new SqlParameter("@ProvincesId", SqlDbType.NVarChar, 2);
para[4].Direction = ParameterDirection.Input;
para[4].Value = mdterr.ProvinceId;
para[5] = new SqlParameter("@DistrictId", SqlDbType.NVarChar, 3);
para[5].Direction = ParameterDirection.Input;
para[5].Value = mdterr.DistrictId;
para[6] = new SqlParameter("@WardsId", SqlDbType.NVarChar, 5);
para[6].Direction = ParameterDirection.Input;
para[6].Value = mdterr.WardsId;
para[7] = new SqlParameter("@RetCode", SqlDbType.Int);
para[7].Direction = ParameterDirection.Output;
para[7].Value = DBNull.Value;
para[8] = new SqlParameter("@RetMesg", SqlDbType.NVarChar, 100);
para[8].Direction = ParameterDirection.Output;
para[8].Value = DBNull.Value;
helper.ExecuteNonQuery(CConfig.SP_TERRITORIES, para, CommandType.StoredProcedure);
RetCode = Int32.Parse(para[7].Value.ToString());
RetMesg = para[8].Value.ToString();
result = true;
}
catch (Exception ex)
{
RetCode = -1;
RetMesg = ex.Message;
result = false;
}
return(result);
}
public DataTable InsertTerri(TerritoriesModel mdterr, ref int RetCode, ref string RetMesg)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@Activity", SqlDbType.NVarChar, 20);
para[0].Direction = ParameterDirection.Input;
para[0].Value = mdterr.Activity;
para[1] = new SqlParameter("@ProvincesName", SqlDbType.NVarChar, 50);
para[1].Direction = ParameterDirection.Input;
para[1].Value = mdterr.ProvinceName;
para[2] = new SqlParameter("@DistrictName", SqlDbType.NVarChar, 50);
para[2].Direction = ParameterDirection.Input;
para[2].Value = mdterr.DistrictName;
para[3] = new SqlParameter("@WardsName", SqlDbType.NVarChar, 50);
para[3].Direction = ParameterDirection.Input;
para[3].Value = mdterr.WardsName;
para[4] = new SqlParameter("@ProvincesId", SqlDbType.NVarChar, 2);
para[4].Direction = ParameterDirection.Input;
para[4].Value = mdterr.ProvinceId;
para[5] = new SqlParameter("@DistrictId", SqlDbType.NVarChar, 3);
para[5].Direction = ParameterDirection.Input;
para[5].Value = mdterr.DistrictId;
para[6] = new SqlParameter("@WardsId", SqlDbType.NVarChar, 5);
para[6].Direction = ParameterDirection.Input;
para[6].Value = mdterr.WardsId;
para[7] = new SqlParameter("@RetCode", SqlDbType.Int);
para[7].Direction = ParameterDirection.Output;
para[7].Value = DBNull.Value;
para[8] = new SqlParameter("@RetMesg", SqlDbType.NVarChar, 100);
para[8].Direction = ParameterDirection.Output;
para[8].Value = DBNull.Value;
ds = helper.ExecuteQuery(CConfig.SP_TERRITORIES, para, CommandType.StoredProcedure);
RetCode = Int32.Parse(para[7].Value.ToString());
RetMesg = para[8].Value.ToString();
}
catch (Exception ex)
{
RetCode = -1;
RetMesg = ex.Message;
ds = null;
throw ex;
}
return(ds.Tables[0]);
}
/// <summary>
/// Get Territories
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
#region Get Territories
public List <TerritoriesModel> TerritoriesGet(TerritoriesModel mdterr, ref int RetCode, ref string RetMesg)
{
List <TerritoriesModel> result = new List <TerritoriesModel>();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[6];
para[0] = new SqlParameter("@Activity", SqlDbType.NVarChar, 20);
para[0].Direction = ParameterDirection.Input;
para[0].Value = mdterr.Activity;
para[1] = new SqlParameter("@ProvincesId", SqlDbType.NVarChar, 2);
para[1].Direction = ParameterDirection.Input;
para[1].Value = mdterr.ProvinceId;
para[2] = new SqlParameter("@DistrictId", SqlDbType.NVarChar, 3);
para[2].Direction = ParameterDirection.Input;
para[2].Value = mdterr.DistrictId;
para[3] = new SqlParameter("@WardsId", SqlDbType.NVarChar, 5);
para[3].Direction = ParameterDirection.Input;
para[3].Value = mdterr.WardsId;
para[4] = new SqlParameter("@RetCode", SqlDbType.Int);
para[4].Direction = ParameterDirection.Output;
para[4].Value = DBNull.Value;
para[5] = new SqlParameter("@RetMesg", SqlDbType.NVarChar, 100);
para[5].Direction = ParameterDirection.Output;
para[5].Value = DBNull.Value;
ds = helper.ExecuteQuery(CConfig.SP_TERRITORIES, para, CommandType.StoredProcedure);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
result.Add(new TerritoriesModel
{
ProvinceId = row["ProvinceId"].ToString().Trim(),
ProvinceName = row["ProvinceName"].ToString().Trim(),
DistrictId = row["DistrictId"].ToString().Trim(),
DistrictName = row["DistrictName"].ToString().Trim(),
WardsId = row["WardsId"].ToString().Trim(),
WardsName = row["WardsName"].ToString().Trim()
});
}
}
else
{
result = null;
}
RetCode = Int32.Parse(para[4].Value.ToString());
RetMesg = "Có " + dt.Rows.Count + " thông tin được tìm thấy.";
}
catch (Exception ex)
{
RetCode = -1;
RetMesg = ex.Message;
result = null;
}
return(result);
}
