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; }