public DbDataReader GETCities(string StateCode)
{
try
{
return(DB.ExecuteStoredProcedureForReader("usp_GetCities", Global.ConnectionString().ToString(), _parameterManager.Get("@inStateCode", StateCode)));
}
catch (Exception ex) { throw ex; }
}
public DbDataReader InsertDoctorProfile(DoctorInsertModel req)
{
try
{
return(DB.ExecuteStoredProcedureForReader("USP_Doctors_InsertUpdate", Global.ConnectionString().ToString(),
_parameterManager.Get("@inFirstName", req.FirstName)
, _parameterManager.Get("@inLastName", req.LastName)
, _parameterManager.Get("@inEmail", req.Email)
, _parameterManager.Get("@inPhoneNumer", req.PhoneNumber)
, _parameterManager.Get("@inAddress", req.Address)
, _parameterManager.Get("@inCountry", req.Country)
, _parameterManager.Get("@inState", req.State)
, _parameterManager.Get("@inPincode", req.Pincode)
, _parameterManager.Get("@inImage", req.Image)
, _parameterManager.Get("@inPassword", req.Password)
, _parameterManager.Get("@inUserType", UserTypes.Doctor)
, _parameterManager.Get("@inDoctorTypes", String.Join(",", req.DoctorTypes))
, _parameterManager.Get("@inMode", Mode.Insert)
, _parameterManager.Get("@inID", 0)
));
}
catch (Exception ex)
{
throw ex;
}
}