protected void btnSave_Click(object sender, EventArgs e) { DoctorsProcess4 dp4 = new DoctorsProcess4(); if (Session["DoctorEmail"] != null) { dp4.DoctorEmail = Session["DoctorEmail"].ToString(); dp4.Days = ddlDay.Text; if (CheckBox1.Checked) { dp4.TConsult = "Text Consult"; dp4.TPrice = Convert.ToInt32(txtTamount.Text); dp4.TStartTime = ddTstartTime.SelectedItem.Value; dp4.TEndTime = ddTEndTime.SelectedItem.Value; } if (CheckBox2.Checked) { dp4.PConsult = "Phone Consult"; dp4.PPrice = Convert.ToInt32(txtPAmount.Text); dp4.PStartTime = ddPstartTime.SelectedItem.Value; dp4.PEndTime = ddPendTime.SelectedItem.Value; } if (CheckBox3.Checked) { dp4.VConsult = "Video Consult"; dp4.VPrice = Convert.ToInt32(txtVAmount.Text); dp4.VStartTime = ddVstartTime.SelectedItem.Value; dp4.VEndTime = ddVendTime.SelectedItem.Value; } int rowCount = _dpManager.SaveProcess4(dp4); if (rowCount > 0) { successPanel.Visible = true; warningPanel.Visible = false; alertText.InnerHtml = "Saved Successfully"; } else { warningPanel.Visible = true; successPanel.Visible = false; errorName.InnerHtml = "Warning"; errorText.InnerHtml = "Failed.Please Try Again!"; } } }
internal int SaveProcess4(DoctorsProcess4 dp4) { connection.Open(); command = new SqlCommand("sp_consulting", connection); command.Parameters.Add("@doctorEmail", SqlDbType.NVarChar).Value = dp4.DoctorEmail; command.Parameters.Add("@days", SqlDbType.NVarChar).Value = dp4.Days; command.Parameters.Add("@tConsult", SqlDbType.NVarChar).Value = dp4.TConsult; command.Parameters.Add("@tPrice", SqlDbType.Int).Value = dp4.TPrice; command.Parameters.Add("@tStartTime", SqlDbType.NVarChar).Value = dp4.TStartTime; command.Parameters.Add("@tEndTime", SqlDbType.NVarChar).Value = dp4.TEndTime; command.Parameters.Add("@pConsult", SqlDbType.NVarChar).Value = dp4.PConsult; command.Parameters.Add("@pPrice", SqlDbType.Int).Value = dp4.PPrice; command.Parameters.Add("@pStartTime", SqlDbType.NVarChar).Value = dp4.PStartTime; command.Parameters.Add("@pEndtime", SqlDbType.NVarChar).Value = dp4.PEndTime; command.Parameters.Add("@vConsult", SqlDbType.NVarChar).Value = dp4.VConsult; command.Parameters.Add("@vPrice", SqlDbType.Int).Value = dp4.VPrice; command.Parameters.Add("@vStartTime", SqlDbType.NVarChar).Value = dp4.VStartTime; command.Parameters.Add("@vEndtime", SqlDbType.NVarChar).Value = dp4.VEndTime; command.CommandType = CommandType.StoredProcedure; row = command.ExecuteNonQuery(); connection.Close(); return(row); }
internal int SaveProcess4(DoctorsProcess4 dp4) { return(_dpGateway.SaveProcess4(dp4)); }