public JsonResult isDuplicateRecordExistInCircle(int CircleID, string CircleCode)
{
List <MstCircle> lstMstCircle = new List <MstCircle>();
try
{
DataTable dtMstCircle = objDbTrx.isDuplicateRecordExistInCircle(CircleID, CircleCode);
if (dtMstCircle.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtMstCircle.Rows.Count; iCnt++)
{
MstCircle objMstCircle = new MstCircle();
objMstCircle.DistrictId = Convert.ToInt16(dtMstCircle.Rows[iCnt]["DISTRICT_ID"].ToString());
objMstCircle.DistrictName = dtMstCircle.Rows[iCnt]["DISTRICT"].ToString();
objMstCircle.CircleCode = dtMstCircle.Rows[iCnt]["CIRCLE_CODE"].ToString();
objMstCircle.CircleName = dtMstCircle.Rows[iCnt]["CIRCLE_NAME"].ToString();
objMstCircle.CircleId = Convert.ToInt16(dtMstCircle.Rows[iCnt]["ID"].ToString());
lstMstCircle.Add(objMstCircle);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(lstMstCircle, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
List <MstCircle> lstMstCircle = new List <MstCircle>();
try
{
DataTable dtMstCircle = objDbTrx.GetCircleMasterDetails();
if (dtMstCircle.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtMstCircle.Rows.Count; iCnt++)
{
MstCircle objMstCircle = new MstCircle();
objMstCircle.DistrictId = Convert.ToInt16(dtMstCircle.Rows[iCnt]["DISTRICT_ID"].ToString());
objMstCircle.DistrictName = dtMstCircle.Rows[iCnt]["DISTRICT"].ToString();
objMstCircle.CircleCode = dtMstCircle.Rows[iCnt]["CIRCLE_CODE"].ToString();
objMstCircle.CircleName = dtMstCircle.Rows[iCnt]["CIRCLE_NAME"].ToString();
objMstCircle.CircleId = Convert.ToInt16(dtMstCircle.Rows[iCnt]["ID"].ToString());
lstMstCircle.Add(objMstCircle);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(View(lstMstCircle));
}
public ActionResult CircleUpdate(Int16?DataUniqueId)
{
if (DataUniqueId != null)
{
DataTable dtCircleInfo = new DataTable();
dtCircleInfo = objDbTrx.GetCircleDtilById(Convert.ToInt16(DataUniqueId));
MstCircle objCircle = new MstCircle();
objCircle.CircleId = Convert.ToInt16(dtCircleInfo.Rows[0]["ID"]);
objCircle.DistrictId = Convert.ToInt16(dtCircleInfo.Rows[0]["DISTRICT_ID"]);
objCircle.CircleCode = dtCircleInfo.Rows[0]["CIRCLE_CODE"].ToString();
objCircle.CircleName = dtCircleInfo.Rows[0]["CIRCLE_NAME"].ToString();
return(View(objCircle));
}
return(View());
}
public ActionResult CircleUpdate(MstCircle objCircle)
{
try
{
if (objCircle.CircleId == null || objCircle.CircleId <= 0)
{
bool isUpdated = objDbTrx.InsertInMstCircle(objCircle);
TempData["Message"] = "Information Saved Successfully";
}
else
{
bool isUpdated = objDbTrx.UpdateInMstCircle(objCircle);
TempData["Message"] = "Information Updated Successfully";
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(RedirectToAction("Index", "MstCircle"));
}
public JsonResult GetCircleAddressDetails(string CircleID)
{
MstCircle LstMstCircle = new MstCircle();
try
{
DataTable dt = objDbTrx.GetCircleMasterDetailsByCircleId(Convert.ToInt32(CircleID));
if (dt.Rows.Count > 0)
{
LstMstCircle.CirclAddress = Convert.ToString(dt.Rows[0]["CIRCLE_ADDRESS"]) + "\n" + dt.Rows[0]["CIRCLE_PINCODE"];
}
else
{
LstMstCircle.CirclAddress = "";
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(LstMstCircle));
}
public JsonResult GetDistrictDetails()
{
List <MstCircle> ObjMstCircle = new List <MstCircle>();
try
{
DataTable dt = objDbTrx.GetDistrictDetails();
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
MstCircle objCircle = new MstCircle();
objCircle.DistrictId = Convert.ToInt16(dt.Rows[iCnt]["ID"].ToString());
objCircle.DistrictName = dt.Rows[iCnt]["DISTRICT"].ToString();
ObjMstCircle.Add(objCircle);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(ObjMstCircle));
}
