public Contact GetBridgePatient(string firstName, string lastName, DateTime dob, long physicianId)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("FirstName",firstName),
new SqlParameter("LastName",lastName),
new SqlParameter("DOB",dob),
new SqlParameter("PhysicianId",physicianId)
};
var robj = new Contact();
using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(Utility.DBBridgeConnectionString, CommandType.StoredProcedure, "SignUp_GetPatientDetails", sqlParms))
{
while (sqlobj.Read())
{
robj.Id = DBHelper.getInt64(sqlobj, "Id");
robj.FirstName = DBHelper.getString(sqlobj, "FirstName");
robj.LastName = DBHelper.getString(sqlobj, "LastName");
robj.DOB = DBHelper.getDateTime(sqlobj, "DOB");
robj.ReferenceId = DBHelper.getInt64(sqlobj, "ReferenceId");
robj.ProviderId = DBHelper.getInt64(sqlobj, "ProviderID");
robj.PhoneNumber = DBHelper.getString(sqlobj, "PhoneNumber");
robj.Email = DBHelper.getString(sqlobj, "Email");
}
}
return robj;
}
public ProviderList GetProvideList(string action)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("@action",action)
};
var list = new List<IGNITE_MODEL.Contact>();
using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "sp_hick_GetPhysician", sqlParms))
{
while (sqlobj.Read())
{
var providerobj = new IGNITE_MODEL.Contact();
providerobj.FirstName = ecd.DecryptData(DBHelper.getString(sqlobj, "Firstname"), ecd.GetEncryptType()) + " " + ecd.DecryptData(DBHelper.getString(sqlobj, "Lastname"), ecd.GetEncryptType());
providerobj.Id = (DBHelper.getInt64(sqlobj, "ID"));
list.Add(providerobj);
}
}
return new ProviderList
{
Provider_List = list
};
}
public bool CreateIgniteContact(Contact contact)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("FirstName",contact.FirstName),
new SqlParameter("UserName",(Convert.ToString(contact.FirstName).Substring(0, 1) + Convert.ToString(contact.LastName)).ToLower().Trim()),
new SqlParameter("LastName",contact.LastName),
new SqlParameter("DOB",contact.DOB),
new SqlParameter("ProviderId",contact.ProviderId),
new SqlParameter("PhysicianId",contact.PhysicianId),
new SqlParameter("ReferenceId",contact.ReferenceId),
new SqlParameter("PhoneNumber",contact.PhoneNumber),
new SqlParameter("EmailId",contact.Email),
new SqlParameter("Password",contact.Password)
};
int ret = (int)SqlHelper.ExecuteScalar(SqlHelper.ConnectionString, CommandType.StoredProcedure, "SignUp_CreateNewContact", sqlParms.ToArray());
if (ret > 0)
{
return true;
}
return false;
}
