public void InsertFeedbackDtlsDAL(FeedbackBE objBE, string UserId, string ConnKey)
{
using (SqlConnection con = new SqlConnection(ConnKey))
{
using (SqlCommand cmd = new SqlCommand("Feedback_Insert", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UniqueInsId", SqlDbType.VarChar).Value = objBE.UniqueInsId;
cmd.Parameters.Add("@VisitDate", SqlDbType.Date).Value = objBE.VisitDate;
cmd.Parameters.Add("@RegNo", SqlDbType.VarChar).Value = objBE.RegNo;
cmd.Parameters.Add("@VisitId", SqlDbType.VarChar).Value = objBE.VisitId;
cmd.Parameters.Add("@RegFee_Paid", SqlDbType.VarChar).Value = objBE.RegFeePaid;
cmd.Parameters.Add("@TestFee_Paid", SqlDbType.VarChar).Value = objBE.TestFeePaid;
cmd.Parameters.Add("@OtherAmt_Paid", SqlDbType.VarChar).Value = objBE.OtherAmtPaid;
cmd.Parameters.Add("@Reg_ServiceQuality", SqlDbType.VarChar).Value = objBE.Reg_ServiceQuality;
cmd.Parameters.Add("@Doctor_ServiceQuality", SqlDbType.VarChar).Value = objBE.Doctor_ServiceQuality;
cmd.Parameters.Add("@Phar_ServiceQuality", SqlDbType.VarChar).Value = objBE.Phar_ServiceQuality;
cmd.Parameters.Add("@Free_DrugIssued", SqlDbType.VarChar).Value = objBE.Free_DrugIssued;
cmd.Parameters.Add("@Drugs_Pfrmoutside", SqlDbType.VarChar).Value = objBE.Drugs_Pfrmoutside;
cmd.Parameters.Add("@CleanlinessInHosp", SqlDbType.VarChar).Value = objBE.CleanlinessInHosp;
cmd.Parameters.Add("@Overall_Experience", SqlDbType.VarChar).Value = objBE.Overall_Experience;
cmd.Parameters.Add("@ExcessRegFeeTaken", SqlDbType.VarChar).Value = objBE.ExcessRegFeeTaken;
cmd.Parameters.Add("@ExcessRegFee", SqlDbType.VarChar).Value = objBE.ExcessRegFee;
cmd.Parameters.Add("@ExcessTestFeeTaken", SqlDbType.VarChar).Value = objBE.ExcessTestFeeTaken;
cmd.Parameters.Add("@ExcessTestFee", SqlDbType.VarChar).Value = objBE.ExcessTestFee;
cmd.Parameters.Add("@FreeDrugsNotIssued", SqlDbType.VarChar).Value = objBE.FreeDrugsNotIssued;
cmd.Parameters.Add("@LoggedIn_UserId", SqlDbType.VarChar).Value = UserId;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public void CloseFeedbackDAL(FeedbackBE objBE, string UserId, string ConnKey)
{
using (SqlConnection con = new SqlConnection(ConnKey))
{
using (SqlCommand cmd = new SqlCommand("Feedback_Close", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UniqueInsId", SqlDbType.VarChar).Value = objBE.UniqueInsId;
cmd.Parameters.Add("@VisitDate", SqlDbType.Date).Value = objBE.VisitDate;
cmd.Parameters.Add("@RegNo", SqlDbType.VarChar).Value = objBE.RegNo;
cmd.Parameters.Add("@VisitId", SqlDbType.VarChar).Value = objBE.VisitId;
cmd.Parameters.Add("@CloseFb_Reason", SqlDbType.VarChar).Value = objBE.VisitId;
cmd.Parameters.Add("@LoggedIn_UserId", SqlDbType.VarChar).Value = UserId;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public void CloseFeedbackBAL(FeedbackBE objBE, string UserId, string ConnKey)
{
objDL.CloseFeedbackDAL(objBE, UserId, ConnKey);
}
public void InsertFeedbackDtlsBAL(FeedbackBE objBE, string UserId, string ConnKey)
{
objDL.InsertFeedbackDtlsDAL(objBE, UserId, ConnKey);
}
