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; }