public static void SearchDoctorsAvailabeTimeByPatient(TextBox textBox, DataGridView dataGridView)
{
DoctorPatientDataContext dp = new DoctorPatientDataContext(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Arwin\documents\visual studio 2015\Projects\CSharpProjects\DoctorPatientPortal\DoctorPatient.mdf;Integrated Security=True;Connect Timeout=30");
DoctorAvailable da = null;
try
{
da = dp.DoctorAvailables.FirstOrDefault(dal => dal.DoctorId == int.Parse(textBox.Text)); /*&& dal.CurrentDateTime==DateTime.Now.AddDays(1)*/
}catch (Exception ex)
{
MessageBox.Show(ex.GetType().Name + ", " + ex.Message, "Query Result");
}
if (da != null)
{
//DateTime dateResult = DateTime.ParseExact(DateTime.Now.AddDays(1).ToShortDateString(), "dd/mmm/yy", CultureInfo.InvariantCulture);
var x = from a in dp.DoctorAvailables where da.DoctorId == int.Parse(textBox.Text) /*&& da.CurrentDateTime == DateTime.Now.AddDays(1).ToShortDateString()*/ select a;
dataGridView.DataSource = x.ToList();
MessageBox.Show("Doctor Available Time Found", "Query Result");
//MessageBox.Show((DateTime.ParseExact(DateTime.Now.AddDays(1).ToString(),"dd-mm-yy")).ToString());
}
if (da == null)
{
MessageBox.Show("Doctor Availabe time not found. Try with another id", "Query Result");
dataGridView.DataSource = null;
textBox.Clear();
}
}
public static void DoctorAvailableTimeSetToDB(string emailID, string fromTime, string toTime, int drID)
{
DoctorPatientDataContext dp = new DoctorPatientDataContext(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Arwin\documents\visual studio 2015\Projects\CSharpProjects\DoctorPatientPortal\DoctorPatient.mdf;Integrated Security=True;Connect Timeout=30");
List <string> fromTimeList = new List <string>();
fromTimeList.Add("8:00 AM");
fromTimeList.Add("9:00 AM");
fromTimeList.Add("10:00 AM");
fromTimeList.Add("11:00 AM");
fromTimeList.Add("12:00 PM");
fromTimeList.Add("1:00 PM");
fromTimeList.Add("2:00 PM");
fromTimeList.Add("3:00 PM");
fromTimeList.Add("4:00 PM");
fromTimeList.Add("5:00 PM");
fromTimeList.Add("6:00 PM");
List <string> toTimeList = new List <string>();
toTimeList.Add("12:00 PM");
toTimeList.Add("1:00 PM");
toTimeList.Add("2:00 PM");
toTimeList.Add("3:00 PM");
toTimeList.Add("4:00 PM");
toTimeList.Add("5:00 PM");
toTimeList.Add("6:00 PM");
toTimeList.Add("7:00 PM");
toTimeList.Add("8:00 PM");
toTimeList.Add("9:00 PM");
string[] arrayList = new string[11];
int i = 0, l = 0;
foreach (string f in fromTimeList)
{
arrayList[i] = f;
i++;
}
for (int j = 0; j < arrayList.Length; j++)
{
if (arrayList[j] == fromTime)
{
l = j;
}
}
for (int m = 0; m < l; m++)
{
arrayList[m] = "";
}
//new area 2
string[] arrayList2 = new string[10];
int i2 = 0, l2 = 0;
foreach (string f in toTimeList)
{
arrayList2[i2] = f;
i2++;
}
for (int kk = 0; kk < arrayList2.Length; kk++)
{
if (arrayList2[kk] == arrayList[arrayList.Length - 1])
{
l2 = arrayList2[kk].Length;
}
}
for (int m = 0; m < l2; m++)
{
arrayList2[m] = "";
}
int s1 = 0;
for (int s = 0; s < arrayList2.Length; s++)
{
if (arrayList2[s] == toTime)
{
s1 = s;
}
}
for (int s3 = arrayList2.Length - 1; s3 > s1; s3--)
{
arrayList2[s3] = "";
}
string dt;
DoctorAvailable ad = null;
try
{
ad = new DoctorAvailable();
ad.DoctorId = drID;
ad.CurrentDateTime = dt = DateTime.Now.AddDays(1).ToShortDateString();
ad.FromTime1 = arrayList[0];
ad.FromTime2 = arrayList[1];
ad.FromTime3 = arrayList[2];
ad.FromTime4 = arrayList[3];
ad.FromTime5 = arrayList[4];
ad.FromTime6 = arrayList[5];
ad.FromTime7 = arrayList[6];
ad.FromTime8 = arrayList[7];
ad.FromTime9 = arrayList[8];
ad.FromTime10 = arrayList[9];
ad.FromTime11 = arrayList[10];
ad.ToTime1 = arrayList2[0];
ad.ToTime2 = arrayList2[1];
ad.ToTime3 = arrayList2[2];
ad.ToTime4 = arrayList2[3];
ad.ToTime5 = arrayList2[4];
ad.ToTime6 = arrayList2[5];
ad.ToTime7 = arrayList2[6];
ad.ToTime8 = arrayList2[7];
ad.ToTime9 = arrayList2[8];
ad.ToTime10 = arrayList2[9];
dp.DoctorAvailables.InsertOnSubmit(ad);
dp.SubmitChanges();
MessageBox.Show("Available time set successfully...", "Query Result");
}
catch (Exception ex)
{
MessageBox.Show("c1" + ex.GetType().Name + ex.Message, "Query Result");
}
}