public static List <AccountContact> GetAccountContactListByAccountId(int accountId)
{
List <AccountContact> list = new List <AccountContact>();
Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement");
string sqlCommand = "GetAccountContactListByAccountId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
AccountContact insightSupplierContact = new AccountContact();
insightSupplierContact.AccountContactId = Convert.ToInt32(dataReader["AccountContactId"]);
insightSupplierContact.AccountId = accountId;
insightSupplierContact.FirstName = dataReader["FirstName"].ToString();
insightSupplierContact.LastName = dataReader["LastName"].ToString();
insightSupplierContact.ContactNumber = dataReader["ContactNumber"].ToString();
insightSupplierContact.Email = dataReader["Email"].ToString();
insightSupplierContact.Position = dataReader["Position"].ToString();
insightSupplierContact.AccountContactLinkId = Convert.ToInt32(dataReader["AccountContactLinkId"]);
list.Add(insightSupplierContact);
}
}
return(list);
}
public static AccountContact GetAccountContactByAccountContactId(int accountContactId)
{
Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement");
string sqlCommand = "GetAccountContactByAccountContactId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@AccountContactId", DbType.Int32, accountContactId);
db.AddOutParameter(dbCommand, "@FirstName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@LastName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@ContactNumber", DbType.String, 50);
db.AddOutParameter(dbCommand, "@Email", DbType.String, 100);
db.AddOutParameter(dbCommand, "@Position", DbType.String, 50);
db.ExecuteNonQuery(dbCommand);
AccountContact insightSupplierContact = new AccountContact();
insightSupplierContact.FirstName = db.GetParameterValue(dbCommand, "FirstName").ToString();
insightSupplierContact.LastName = db.GetParameterValue(dbCommand, "LastName").ToString();
insightSupplierContact.ContactNumber = db.GetParameterValue(dbCommand, "ContactNumber").ToString();
insightSupplierContact.Email = db.GetParameterValue(dbCommand, "Email").ToString();
insightSupplierContact.Position = db.GetParameterValue(dbCommand, "Position").ToString();
return(insightSupplierContact);
}
