public JsonResult SaveInstituteSpoc(mTravelPlanInstituteSpoc _obj)
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
try
{
_obj.InstituteID = Session["InstituteID"].ToString();
_obj.CreatedIP = Session["localIP"].ToString();
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.INSERT_UPDATE_StudentTravelInstituteSpoc(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "1")
{
Message = "Details has been saved successfully!";
Code = "success";
}
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
}
catch (NullReferenceException ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
public DataSet INSERT_UPDATE_StudentTravelInstituteSpoc(mTravelPlanInstituteSpoc _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("INSERT_UPDATE_StudentTravelInstituteSpoc", _cn);
_cmd.Parameters.AddWithValue("@ID", _obj.ID);
_cmd.Parameters.AddWithValue("@ProgramLevel", _obj.ProgramLevel);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@StudentIDs", _obj.StudentIDs);
_cmd.Parameters.AddWithValue("@NameOfSpoc", _obj.NameOfSpoc);
_cmd.Parameters.AddWithValue("@Mobile", _obj.Mobile);
_cmd.Parameters.AddWithValue("@Email", _obj.Email);
_cmd.Parameters.AddWithValue("@DocumentName1", _obj.DocumentName1);
_cmd.Parameters.AddWithValue("@OtherDocumentName1", _obj.OtherDocumentName1);
_cmd.Parameters.AddWithValue("@DoumentPath1", _obj.DoumentPath1);
_cmd.Parameters.AddWithValue("@DocumentName2", _obj.DocumentName2);
_cmd.Parameters.AddWithValue("@OtherDocumentName2", _obj.OtherDocumentName2);
_cmd.Parameters.AddWithValue("@DoumentPath2", _obj.DoumentPath2);
_cmd.Parameters.AddWithValue("@DocumentName3", _obj.DocumentName3);
_cmd.Parameters.AddWithValue("@OtherDocumentName3", _obj.OtherDocumentName3);
_cmd.Parameters.AddWithValue("@DoumentPath3", _obj.DoumentPath3);
_cmd.Parameters.AddWithValue("@DocumentName4", _obj.DocumentName4);
_cmd.Parameters.AddWithValue("@OtherDocumentName4", _obj.OtherDocumentName4);
_cmd.Parameters.AddWithValue("@DoumentPath4", _obj.DoumentPath4);
_cmd.Parameters.AddWithValue("@DocumentName5", _obj.DocumentName5);
_cmd.Parameters.AddWithValue("@OtherDocumentName5", _obj.OtherDocumentName5);
_cmd.Parameters.AddWithValue("@DoumentPath5", _obj.DoumentPath5);
_cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP);
_cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
