public JsonResult DepartmentExists(string DepartmentName, int?DepartmentID)
{
if (DepartmentID != null)
{
if (_DbWorkPermitSystemEntities.tbl_DepartmentMaster.Any(x => x.DepartmentName == DepartmentName))
{
tbl_DepartmentMaster existingDepartment = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Single(x => x.DepartmentName == DepartmentName);
if (existingDepartment.DepartmentID != DepartmentID)
{
return(Json(false));
}
else
{
return(Json(true));
}
}
else
{
return(Json(true));
}
}
else
{
return(Json(!_DbWorkPermitSystemEntities.tbl_DepartmentMaster.Any(x => x.DepartmentName == DepartmentName)));
}
}
public async void GetAllDesignationByDepartment(string sDepartmentID)
{
try
{
string Url = StatusModel.Url + "GetDesignationMasterByDepartment";
WebHelpper _objHelper = new WebHelpper();
tbl_DesignationMaster _objDesignationMaster = new tbl_DesignationMaster();
tbl_DepartmentMaster _objDepartmentMaster = new tbl_DepartmentMaster();
_objDepartmentMaster.DepartmentID = Convert.ToInt32(sDepartmentID);
var PostString = JsonConvert.SerializeObject(_objDepartmentMaster);
var request = await _objHelper.MakePostRequest(Url, PostString, true);
ResultAllDesignationMaster = JsonConvert.DeserializeObject <List <tbl_DesignationMaster> >(request);
DesignationByDepartment = new string[ResultAllDesignationMaster.Count + 1];
int i = 1;
DesignationByDepartment[0] = "--Select Designation--";
foreach (var item in ResultAllDesignationMaster)
{
DesignationByDepartment[i] = item.DesignationName;
i++;
}
ArrayAdapter _adapterDesignationByDepartment = new ArrayAdapter(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, DesignationByDepartment);
txt_EmployeeDesignationID.Adapter = _adapterDesignationByDepartment;
}
catch (Exception e)
{
string ErrorMsg = e.ToString();
Toast.MakeText(this, ErrorMsg, ToastLength.Long).Show();
}
}
public ActionResult Create(DepartmentMasterModel collection)
{
CheckViewBagData();
if (ModelState.IsValid)
{
var data = new tbl_DepartmentMaster()
{
DepartmentName = collection.DepartmentName,
DepartmentCreateDate = DateTime.Now
};
if (!_DbWorkPermitSystemEntities.tbl_DepartmentMaster.Any(p => p.DepartmentName == collection.DepartmentName))
{
try
{
_DbWorkPermitSystemEntities.tbl_DepartmentMaster.Add(data);
_DbWorkPermitSystemEntities.SaveChanges();
List <string> Desig = new List <string> {
"Activity Owner", "Area Owner"
};
foreach (var item in Desig)
{
var DesignationData = new tbl_DesignationMaster()
{
DepartmentID = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Where(p => p.DepartmentName == collection.DepartmentName).Select(p => p.DepartmentID).FirstOrDefault(),
DesignationName = item,
DesignationCreateDate = DateTime.Now
};
_DbWorkPermitSystemEntities.tbl_DesignationMaster.Add(DesignationData);
_DbWorkPermitSystemEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
else
{
ViewBag.Errormessage = "Fail";
}
}
return(View());
}
public JsonResult AddDepartmentMaster(tbl_DepartmentMaster collection)
{
try
{
_DbWorkPermitSystemEntities.tbl_DepartmentMaster.Add(collection);
_DbWorkPermitSystemEntities.SaveChanges();
ResultModel _objResult = new ResultModel();
_objResult.success = 1;
_objResult.msg = "Save Successfully";
return(Json(_objResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ResultModel _objResult = new ResultModel();
_objResult.success = 0;
_objResult.msg = ex.ToString();
return(Json(_objResult, JsonRequestBehavior.AllowGet));
}
}
public async void GetAllDepartment()
{
try
{
string Url = StatusModel.Url + "GetDepartmentMaster";
WebHelpper _objHelper = new WebHelpper();
tbl_DepartmentMaster _objDepartmentMaster = new tbl_DepartmentMaster();
//using (var client = new WebClient())
//{
// client.Headers.Add(HttpRequestHeader.ContentType, "application/json");
// var responce = client.UploadString(new Uri(Url), "GET");
// ResultAllDepartmentMaster = JsonConvert.DeserializeObject < List<tbl_DepartmentMaster>>(responce);
//}
var request = await _objHelper.MakeGetRequest(Url);
ResultAllDepartmentMaster = JsonConvert.DeserializeObject <List <tbl_DepartmentMaster> >(request);
Department = new string[ResultAllDepartmentMaster.Count + 1];
int i = 1;
Department[0] = "--Select Department--";
foreach (var item in ResultAllDepartmentMaster)
{
Department[i] = item.DepartmentName;
i++;
}
ArrayAdapter _adapterDepartment = new ArrayAdapter(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, Department);
txt_EmployeeDepartmentID.Adapter = _adapterDepartment;
}
catch (Exception e)
{
string ErrorMsg = e.ToString();
Toast.MakeText(this, ErrorMsg, ToastLength.Long).Show();
}
}
