public static string UpdateInquary(object obj_Inquiry)
{
//_Inquiry a = obj_Inquiry;
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
_Inquiry objCustomer = jsonSerializer.Deserialize <_Inquiry>(obj_Inquiry.ToString());
SqlParameter[] PM = new SqlParameter[11];
SqlParameter[] PM1 = new SqlParameter[1];
// for DEleting Calendar inquiries
PM1[0] = new SqlParameter("@InquiryID", SqlDbType.VarChar);
PM1[0].Value = objCustomer._ID;
PM[0] = new SqlParameter("@Date", SqlDbType.VarChar);
PM[0].Value = objCustomer._Date;
PM[1] = new SqlParameter("@ContactName", SqlDbType.VarChar);
PM[1].Value = objCustomer._ContactName;
PM[2] = new SqlParameter("@ContactPhone", SqlDbType.VarChar);
PM[2].Value = objCustomer._ContactPhone;
PM[3] = new SqlParameter("@Email", SqlDbType.VarChar);
PM[3].Value = objCustomer._Email;
PM[4] = new SqlParameter("@Source", SqlDbType.VarChar);
PM[4].Value = objCustomer._Source;
PM[5] = new SqlParameter("@Notes", SqlDbType.VarChar);
PM[5].Value = objCustomer._Notes;
#region "Inquiry Student Object for usp_CreateInquary"
DataTable dtIS = new DataTable();
dtIS.Columns.Add("ID");
dtIS.Columns.Add("InquiryID");
dtIS.Columns.Add("Grade");
dtIS.Columns.Add("Subjects");
dtIS.Columns.Add("School");
dtIS.Columns.Add("Notes");
dtIS.Columns.Add("StudentName");
for (int x = 0; x < objCustomer.obj_InquiryStudent.Count; x++)
{
DataRow dr = dtIS.NewRow();
dr[0] = objCustomer.obj_InquiryStudent[x]._ID;
dr[1] = objCustomer.obj_InquiryStudent[x]._InquiryID;
dr[2] = objCustomer.obj_InquiryStudent[x]._Grade;
dr[3] = objCustomer.obj_InquiryStudent[x]._Subjects;
dr[4] = objCustomer.obj_InquiryStudent[x]._School;
dr[5] = objCustomer.obj_InquiryStudent[x]._Notes;
dr[6] = objCustomer.obj_InquiryStudent[x]._StudentName;
dtIS.Rows.Add(dr);
}
PM[6] = new SqlParameter("@typeInquiryStudent", SqlDbType.Structured);
PM[6].Value = dtIS;
#endregion
#region "Assessment Object for usp_CreateInquary"
DataTable dtAssesment = new DataTable();
dtAssesment.Columns.Add("ID");
dtAssesment.Columns.Add("InquiryID");
dtAssesment.Columns.Add("Date");
dtAssesment.Columns.Add("ContactName");
dtAssesment.Columns.Add("StudentName");
dtAssesment.Columns.Add("Subjects");
dtAssesment.Columns.Add("Grade");
dtAssesment.Columns.Add("Time");
for (int x = 0; x < objCustomer.obj_Assessment.Count; x++)
{
DataRow dr = dtAssesment.NewRow();
dr[0] = objCustomer.obj_Assessment[x]._ID;
dr[1] = objCustomer.obj_Assessment[x]._InquiryID;
dr[2] = objCustomer.obj_Assessment[x]._Date;
dr[3] = objCustomer.obj_Assessment[x]._ContactName;
dr[4] = objCustomer.obj_Assessment[x]._StudentName;
dr[5] = objCustomer.obj_Assessment[x]._Subjects;
dr[6] = objCustomer.obj_Assessment[x]._Grade;
dr[7] = objCustomer.obj_Assessment[x]._Time;
dtAssesment.Rows.Add(dr);
}
PM[7] = new SqlParameter("@typeAssessments", SqlDbType.Structured);
PM[7].Value = dtAssesment;
#endregion
#region "Meetings Object for usp_CreateInquary"
DataTable dtMeeting = new DataTable();
dtMeeting.Columns.Add("ID");
dtMeeting.Columns.Add("InquiryID");
dtMeeting.Columns.Add("Date");
dtMeeting.Columns.Add("ContactName");
dtMeeting.Columns.Add("ContactNumber");
dtMeeting.Columns.Add("Contactemail");
dtMeeting.Columns.Add("StudentNames");
dtMeeting.Columns.Add("Time");
for (int x = 0; x < objCustomer.obj_Meetings.Count; x++)
{
DataRow dr = dtMeeting.NewRow();
dr[0] = objCustomer.obj_Meetings[x]._ID;
dr[1] = objCustomer.obj_Meetings[x]._InquiryID;
dr[2] = objCustomer.obj_Meetings[x]._Date;
dr[3] = objCustomer.obj_Meetings[x]._ContactName;
dr[4] = objCustomer.obj_Meetings[x]._ContactNumber;
dr[5] = objCustomer.obj_Meetings[x]._Contactemail;
dr[6] = objCustomer.obj_Meetings[x]._StudentName;
dr[7] = objCustomer.obj_Meetings[x]._Time;
dtMeeting.Rows.Add(dr);
}
PM[8] = new SqlParameter("@typeMeetings", SqlDbType.Structured);
PM[8].Value = dtMeeting;
PM[9] = new SqlParameter("@Inquiryid", SqlDbType.VarChar);
PM[9].Value = objCustomer._ID;
#endregion
PM[10] = new SqlParameter("@FranchiseID", SqlDbType.VarChar);
PM[10].Value = HttpContext.Current.Session["FranchiseID"].ToString();
DataSet dsResult = new DataSet();
DataSet dsResult2 = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
dsResult = gf.Filldatasetvalue(PM, "usp_UpdateInquary", dsResult, null);
dsResult2 = gf.Filldatasetvalue(PM1, "USP_GetCalendarIds", dsResult2, null);
string[] Ids = dsResult2.Tables[0].Rows[0][0].ToString().Split(',');
var APIPath = HttpContext.Current.Server.MapPath("~/Api/") + "\\CalendarAPI123.json";
foreach (string str in Ids)
{
if (str.Trim() != "")
{
var background = new Thread(() => CreateEvent.DeleteEvent(APIPath, str));
background.IsBackground = true;
background.Start();
}
}
string Time = (DateTime.Now.Hour % 12).ToString() + ":" + DateTime.Now.Minute.ToString() + "" + (((DateTime.Now.Hour % 12) >= 1) ? "PM" : "AM");
DateTime start;
DateTime end;
DateTime start1;
DateTime end1;
DateTime start2;
DateTime end2;
DateTime.TryParseExact(objCustomer._Date + ((Time == "") ? " 12:00 AM" : " " + ((Time.Length < 7) ? "0" + Time : Time).ToString().Replace("AM", " AM").Replace("PM", " PM")), "MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture,
DateTimeStyles.None, out start);
end = start.AddMinutes(5);
var addr = HttpContext.Current.Session["Address"].ToString();
string Gmail = Convert.ToString(HttpContext.Current.Session["GmailId"]);
//try
//{
// //var background = new Thread(() => CreateEvent.CreatEevent(1000,
// // start, end,
// // Gmail + "," + objCustomer._Email,
// // "New Inquiry Request", addr
// // , APIPath, objCustomer._ContactName, int.Parse(objCustomer._ID.ToString())));
// //background.IsBackground = true;
// //background.Start();
//}
//catch
//{
//}
for (int x = 0; x < objCustomer.obj_Assessment.Count; x++)
{
Time = objCustomer.obj_Assessment[x]._Time;
if (Time != "")
{
DateTime.TryParseExact(objCustomer.obj_Assessment[x]._Date + ((Time == "") ? " 12:00 AM" : " " + ((Time.Length < 7) ? "0" + Time : Time).ToString().Replace("AM", " AM").Replace("PM", " PM")), "MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture,
DateTimeStyles.None, out start1);
end1 = start1.AddHours(1);
String CEmail = objCustomer._Email;
String Name = objCustomer.obj_Assessment[x]._StudentName;
String InquiryId = objCustomer._ID.ToString();
try
{
var background = new Thread(() => CreateEvent.CreatEevent((x + 1) * 1000,
start1, end1,
Gmail + "," + CEmail,
"New Assessment Request", addr
, APIPath, Name,
int.Parse(InquiryId)));
background.IsBackground = true;
background.Start();
}
catch
{
}
}
}
for (int x = 0; x < objCustomer.obj_Meetings.Count; x++)
{
if (Time != "")
{
Time = objCustomer.obj_Meetings[x]._Time;
DateTime.TryParseExact(objCustomer.obj_Meetings[x]._Date + ((Time == "") ? " 12:00 AM" : " " + ((Time.Length < 7) ? "0" + Time : Time).ToString().Replace("AM", " AM").Replace("PM", " PM")), "MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture,
DateTimeStyles.None, out start2);
String CEmail = objCustomer.obj_Meetings[x]._Contactemail;
String Name = objCustomer.obj_Meetings[x]._StudentName;
String InquiryId = objCustomer._ID.ToString();
end2 = start2.AddHours(1);
try
{
var background = new Thread(() => CreateEvent.CreatEevent((x + 1) * 2000,
start2, end2,
Gmail + "," + CEmail,
"New Meeting Request", addr
, APIPath, Name,
int.Parse(InquiryId)));
background.IsBackground = true;
background.Start();
}
catch
{
}
}
}
return(dsResult.Tables[0].Rows[0][0].ToString());//dsResult;
}
public DataTable CreateInquary(_Inquiry _InquiryObj)
{
DataTable dt = new DataTable();
return(dt);
}
public string CreateInquary(object obj_Inquiry)
{
//_Inquiry a = obj_Inquiry;
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
_Inquiry objCustomer = jsonSerializer.Deserialize <_Inquiry>(obj_Inquiry.ToString());
SqlParameter[] PM = new SqlParameter[8];
PM[0] = new SqlParameter("@Date", SqlDbType.DateTime);
PM[0].Value = objCustomer._Date;
PM[1] = new SqlParameter("@ContactName", SqlDbType.VarChar);
PM[1].Value = objCustomer._ContactName;
PM[2] = new SqlParameter("@Email", SqlDbType.VarChar);
PM[2].Value = objCustomer._Email;
PM[3] = new SqlParameter("@Source", SqlDbType.VarChar);
PM[3].Value = objCustomer._Source;
PM[4] = new SqlParameter("@Notes", SqlDbType.VarChar);
PM[4].Value = objCustomer._Notes;
#region "Inquiry Student Object for usp_CreateInquary"
DataTable dtIS = new DataTable();
dtIS.Columns.Add("ID");
dtIS.Columns.Add("InquiryID");
dtIS.Columns.Add("Grade");
dtIS.Columns.Add("Subjects");
dtIS.Columns.Add("School");
dtIS.Columns.Add("Notes");
dtIS.Columns.Add("StudentName");
for (int x = 0; x < objCustomer.obj_InquiryStudent.Count; x++)
{
DataRow dr = dtIS.NewRow();
dr[0] = objCustomer.obj_InquiryStudent[x]._ID;
dr[1] = objCustomer.obj_InquiryStudent[x]._InquiryID;
dr[2] = objCustomer.obj_InquiryStudent[x]._Grade;
dr[3] = objCustomer.obj_InquiryStudent[x]._Subjects;
dr[4] = objCustomer.obj_InquiryStudent[x]._School;
dr[5] = objCustomer.obj_InquiryStudent[x]._Notes;
dr[6] = objCustomer.obj_InquiryStudent[x]._StudentName;
dtIS.Rows.Add(dr);
}
PM[5] = new SqlParameter("@typeInquiryStudent", SqlDbType.Structured);
PM[5].Value = dtIS;
#endregion
#region "Assessment Object for usp_CreateInquary"
DataTable dtAssesment = new DataTable();
dtAssesment.Columns.Add("ID");
dtAssesment.Columns.Add("InquiryID");
dtAssesment.Columns.Add("Date");
dtAssesment.Columns.Add("ContactName");
dtAssesment.Columns.Add("StudentName");
dtAssesment.Columns.Add("Subjects");
dtAssesment.Columns.Add("Grade");
for (int x = 0; x < objCustomer.obj_Assessment.Count; x++)
{
DataRow dr = dtAssesment.NewRow();
dr[0] = objCustomer.obj_Assessment[x]._ID;
dr[1] = objCustomer.obj_Assessment[x]._InquiryID;
dr[2] = objCustomer.obj_Assessment[x]._Date;
dr[3] = objCustomer.obj_Assessment[x]._ContactName;
dr[4] = objCustomer.obj_Assessment[x]._StudentName;
dr[5] = objCustomer.obj_Assessment[x]._Subjects;
dr[6] = objCustomer.obj_Assessment[x]._Grade;
dtAssesment.Rows.Add(dr);
}
PM[6] = new SqlParameter("@typeAssessments", SqlDbType.Structured);
PM[6].Value = dtAssesment;
#endregion
#region "Meetings Object for usp_CreateInquary"
DataTable dtMeeting = new DataTable();
dtMeeting.Columns.Add("ID");
dtMeeting.Columns.Add("InquiryID");
dtMeeting.Columns.Add("Date");
dtMeeting.Columns.Add("ContactName");
dtMeeting.Columns.Add("ContactNumber");
dtMeeting.Columns.Add("Contactemail");
dtMeeting.Columns.Add("StudentNames");
for (int x = 0; x < objCustomer.obj_Meetings.Count; x++)
{
DataRow dr = dtMeeting.NewRow();
dr[0] = objCustomer.obj_Meetings[x]._ID;
dr[1] = objCustomer.obj_Meetings[x]._InquiryID;
dr[2] = objCustomer.obj_Meetings[x]._Date;
dr[3] = objCustomer.obj_Meetings[x]._ContactName;
dr[4] = objCustomer.obj_Meetings[x]._ContactNumber;
dr[5] = objCustomer.obj_Meetings[x]._Contactemail;
dr[6] = objCustomer.obj_Meetings[x]._StudentName;
dtMeeting.Rows.Add(dr);
}
PM[7] = new SqlParameter("@typeMeetings", SqlDbType.Structured);
PM[7].Value = dtMeeting;
#endregion
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
dsResult = gf.Filldatasetvalue(PM, "usp_CreateInquary", dsResult, null);
return("Added Successfully");//dsResult;
}
