public JsonResult DeleteOrganization(int OrganizationID)
{
string _Del = "";
try
{
Organization location = new Models.Master.Organization();
BL_Organization BLOrg = new BL_Organization();
List <Organization> serch = new List <Organization>();
int DependaincyName = BLOrg.DeleteOrganization(OrganizationID);
if (DependaincyName == 1)
{
_Del = "Doctor Deleted Successfully";
}
else
{
_Del = "You Delete First" + DependaincyName;
}
}
catch (Exception ex)
{
_Del = ex.Message;
}
return(new JsonResult {
Data = _Del, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Organization(Organization location, FormCollection collection)
{
try
{
BL_Organization BLOrg = new BL_Organization();
location.ContactFrom = collection["ContactFrom"];
location.ContactPersonName1 = collection["personNameOne"];
location.ContactPersonName2 = collection["personNameTwo"];
location.Designation1 = collection["designationOne"];
location.Designation2 = collection["designationTwo"];
location.ContactPersonEmail1 = collection["emailIdOne"];
location.ContactPersonEmail2 = collection["emailIdTwo"];
location.ContactPersonPhoneNO1 = collection["phoneNumberOne"];
location.ContactPersonPhoneNO2 = collection["phoneNumberTwo"];
//String[] str1 = str.Split(new char[',']);
if (BLOrg.CheckOrganization(location.OrganizationID, location.OrganizationName))
{
if (location.OrganizationID > 0)
{
if (BLOrg.Edit(location))
{
ModelState.Clear();
TempData["Msg"] = "Organization Updated Successfully !";
}
}
else
{
if (BLOrg.Save(location))
{
ModelState.Clear();
TempData["Msg"] = "Organization Saved Successfully !";
}
}
}
else
{
TempData["Msg"] = "Organization Already Exist's";
}
}
catch (Exception ex)
{
TempData["Msg"] = ex.Message;
return(View());
}
return(RedirectToAction("Organization", "Organization"));
}
public JsonResult ShowAllOrganization()
{
Organization location = new Models.Master.Organization();
BL_Organization BLOrg = new BL_Organization();
List <Organization> serch = new List <Organization>();
DataSet ds = BLOrg.ShowAllOrganization();
foreach (DataRow dr in ds.Tables[0].Rows)
{
serch.Add(new Organization
{
OrganizationName = dr["OrganizationName"].ToString(),
ReferenceCode = dr["ReferenceCode"].ToString(),
OrganizationID = Convert.ToInt32(dr["OrganizationID"].ToString())
});
}
return(new JsonResult {
Data = serch, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult BindCity(string prefix)
{
Organization location = new Models.Master.Organization();
BL_Organization BLOrg = new BL_Organization();
List <Organization> serch = new List <Organization>();
DataSet ds = BLOrg.GetCity(prefix);
foreach (DataRow dr in ds.Tables[0].Rows)
{
serch.Add(new Organization
{
CityID = Convert.ToInt32(dr["CityID"]),
CityName = dr["CityName"].ToString(),
StateID = Convert.ToInt32(dr["StateID"].ToString()),
StateName = dr["StateName"].ToString(),
CountryID = Convert.ToInt32(dr["CountryID"].ToString()),
CountryName = dr["CountryName"].ToString(),
});
}
return(new JsonResult {
Data = serch, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult Edit_Organization(int OrganizationID)
{
BL_Organization BLOrg = new BL_Organization();
List <Organization> serch = new List <Organization>();
DataSet ds = BLOrg.SelectOrganizationByID(OrganizationID);
DataSet ds1 = BLOrg.SelectContactPersonByID(OrganizationID);
Organization obj = new Organization();
DataSet dss = BLOrg.GetCity("%");
DataView dv = new DataView(dss.Tables[0], "CityID='" + ds.Tables[0].Rows[0]["CityID"].ToString() + "'", "", DataViewRowState.CurrentRows);
if (dv.ToTable().Rows.Count > 0)
{
obj.CityName = dv.ToTable().Rows[0]["CityName"].ToString();
obj.StateName = dv.ToTable().Rows[0]["StateName"].ToString();
obj.CountryName = dv.ToTable().Rows[0]["CountryName"].ToString();
}
obj.OrganizationID = Convert.ToInt32(ds.Tables[0].Rows[0]["OrganizationID"].ToString());
obj.OrganizationName = ds.Tables[0].Rows[0]["OrganizationName"].ToString();
obj.OrganizationType = ds.Tables[0].Rows[0]["OrganizationType"].ToString();
obj.EnrollmentStatus = ds.Tables[0].Rows[0]["EnrollmentStatus"].ToString();
if (ds.Tables[0].Rows[0]["ContactFrom"].ToString() == "")
{
obj.ContactFrom = null;
}
else
{
// obj.ContactFrom = Convert.ToDateTime(ds.Tables[0].Rows[0]["ContactFrom"]).ToString("MM/dd/yyyy");
obj.ContactFrom1 = ds.Tables[0].Rows[0]["ContactFrom"].ToString();
}
if (ds.Tables[0].Rows[0]["ContactUpTo"].ToString() == "")
{
obj.ContactUpTo = null;
}
else
{
//obj.ContactUpTo = Convert.ToDateTime(Convert.ToDateTime(ds.Tables[0].Rows[0]["ContactUpTo"]).ToString("MM/dd/yyyy"));
obj.ContactUpTo1 = ds.Tables[0].Rows[0]["ContactUpTo"].ToString();
// obj.ContactUpTo.ToString("yyyy-MM-dd");
}
obj.Address = ds.Tables[0].Rows[0]["Address"].ToString();
obj.CityID = Convert.ToInt32(ds.Tables[0].Rows[0]["CityID"].ToString());
obj.PinCode = ds.Tables[0].Rows[0]["PinCode"].ToString();
obj.StateID = Convert.ToInt32(ds.Tables[0].Rows[0]["StateID"].ToString());
obj.CountryID = Convert.ToInt32(ds.Tables[0].Rows[0]["CountryID"].ToString());
obj.GSTNO = ds.Tables[0].Rows[0]["GSTNO"].ToString();
obj.FaxNo = ds.Tables[0].Rows[0]["FaxNo"].ToString();
obj.PhoneNo1 = ds.Tables[0].Rows[0]["PhoneNo1"].ToString();
obj.MobileNo = ds.Tables[0].Rows[0]["MobileNo"].ToString();
obj.EmailID = ds.Tables[0].Rows[0]["EmailID"].ToString();
obj.URL = ds.Tables[0].Rows[0]["URL"].ToString();
obj.CutForTPA = Convert.ToDecimal(ds.Tables[0].Rows[0]["CutForTPA"].ToString());
DataSet dscon = new DataSet();
dscon = BLOrg.SelectContactPersonByID(OrganizationID);
serch.Add(obj);
foreach (DataRow dr in dscon.Tables[0].Rows)
{
serch.Add(new Organization
{
ContactPersonID = Convert.ToInt32(dr["ContactPersonID"].ToString()),
ContactPersonName1 = dr["ContactPersonName"].ToString(),
Designation1 = dr["Designation"].ToString(),
ContactPersonPhoneNO1 = dr["PhoneNO"].ToString(),
ContactPersonEmail1 = dr["EmailID"].ToString(),
ReferenceCode = dr["ReferenceCode"].ToString(),
});
}
return(new JsonResult {
Data = serch, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}