public static List <InsightSupplierContact> GetInsightSupplierContactListNotLinkedByInsightSupplierId(int insightSupplierId)
{
List <InsightSupplierContact> list = new List <InsightSupplierContact>();
Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement");
string sqlCommand = "GetInsightSupplierContactListNotLinkedByInsightSupplierId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@InsightSupplierId", DbType.Int32, insightSupplierId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
InsightSupplierContact insightSupplierContact = new InsightSupplierContact();
insightSupplierContact.InsightSupplierContactId = Convert.ToInt32(dataReader["InsightSupplierContactId"]);
//insightSupplierContact.AccountId = Convert.ToInt32(dataReader["AccountId"]);
insightSupplierContact.FirstName = dataReader["FirstName"].ToString();
insightSupplierContact.LastName = dataReader["LastName"].ToString();
insightSupplierContact.Landline = dataReader["Landline"].ToString();
insightSupplierContact.Mobile = dataReader["Mobile"].ToString();
insightSupplierContact.Email = dataReader["Email"].ToString();
insightSupplierContact.Position = dataReader["Position"].ToString();
insightSupplierContact.Address = dataReader["Address"].ToString();
insightSupplierContact.Region = dataReader["Region"].ToString();
insightSupplierContact.Gift = Convert.ToInt32(dataReader["Gift"]);
//insightSupplierContact.AccessMethod = dataReader["AccessMethod"].ToString();
insightSupplierContact.Position = dataReader["Position"].ToString();
list.Add(insightSupplierContact);
}
}
return(list);
}
public static List <InsightSupplierContact> GetInsightSupplierContactList()
{
List <InsightSupplierContact> list = new List <InsightSupplierContact>();
Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement");
string sqlCommand = "GetInsightSupplierContactList";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
InsightSupplierContact insightSupplierContact = new InsightSupplierContact();
insightSupplierContact.InsightSupplierContactId = Convert.ToInt32(dataReader["InsightSupplierContactId"]);
//insightSupplierContact.AccountDescription = dataReader["AccountName"].ToString();
insightSupplierContact.FirstName = dataReader["FirstName"].ToString();
insightSupplierContact.LastName = dataReader["LastName"].ToString();
//insightSupplierContact.Landline = dataReader["Landline"].ToString();
//insightSupplierContact.Mobile = dataReader["Mobile"].ToString();
//insightSupplierContact.Email = dataReader["Email"].ToString();
//insightSupplierContact.Address = dataReader["Address"].ToString();
//insightSupplierContact.Region = dataReader["Region"].ToString();
//insightSupplierContact.Gift = Convert.ToInt32(dataReader["Gift"]);
//insightSupplierContact.Position = dataReader["Position"].ToString();
//insightSupplierContact.InsightSupplierContactLinkId = Convert.ToInt32(dataReader["InsightSupplierContactLinkId"]);
//insightSupplierContact.AccessMethod = dataReader["AccessMethod"].ToString();
//insightSupplierContact.LicenseKey = dataReader["LicenseKey"].ToString();
//insightSupplierContact.Control = dataReader["Control"].ToString();
//insightSupplierContact.Username = dataReader["Username"].ToString();
//insightSupplierContact.Password = dataReader["Password"].ToString();
list.Add(insightSupplierContact);
}
}
return(list);
}
public static InsightSupplierContact GetInsightSupplierContactByInsightSupplierContactLinkId(int insightSupplierContactLinkId)
{
Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement");
string sqlCommand = "GetInsightSupplierContactByInsightSupplierContactLinkId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@InsightSupplierContactLinkId", DbType.Int32, insightSupplierContactLinkId);
db.AddOutParameter(dbCommand, "@InsightSupplierContactId", DbType.Int32, 4);
db.ExecuteNonQuery(dbCommand);
InsightSupplierContact insightSupplierContact = new InsightSupplierContact();
insightSupplierContact.InsightSupplierContactId = Convert.ToInt32(db.GetParameterValue(dbCommand, "InsightSupplierContactId"));
return(insightSupplierContact);
}
public static InsightSupplierContact GetInsightSupplierContactByInsightSupplierContactId(int insightSupplierContactId)
{
Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement");
string sqlCommand = "GetInsightSupplierContactByInsightSupplierContactId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@InsightSupplierContactId", DbType.Int32, insightSupplierContactId);
//db.AddOutParameter(dbCommand, "@AccountId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@FirstName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@LastName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@Landline", DbType.String, 50);
db.AddOutParameter(dbCommand, "@Mobile", DbType.String, 50);
db.AddOutParameter(dbCommand, "@Email", DbType.String, 100);
db.AddOutParameter(dbCommand, "@Address", DbType.String, 50);
db.AddOutParameter(dbCommand, "@RegionId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Gift", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@AccessMethodId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Position", DbType.String, 50);
db.AddOutParameter(dbCommand, "@LicenseId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@QlikviewVersionId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Username", DbType.String, 100);
db.AddOutParameter(dbCommand, "@Password", DbType.String, 100);
db.ExecuteNonQuery(dbCommand);
InsightSupplierContact insightSupplierContact = new InsightSupplierContact();
//insightSupplierContact.AccountId = Convert.ToInt32(db.GetParameterValue(dbCommand, "AccountId"));
insightSupplierContact.FirstName = db.GetParameterValue(dbCommand, "FirstName").ToString();
insightSupplierContact.LastName = db.GetParameterValue(dbCommand, "LastName").ToString();
insightSupplierContact.Landline = db.GetParameterValue(dbCommand, "Landline").ToString();
insightSupplierContact.Mobile = db.GetParameterValue(dbCommand, "Mobile").ToString();
insightSupplierContact.Email = db.GetParameterValue(dbCommand, "Email").ToString();
insightSupplierContact.Address = db.GetParameterValue(dbCommand, "Address").ToString();
insightSupplierContact.RegionId = Convert.ToInt32(db.GetParameterValue(dbCommand, "RegionId"));
insightSupplierContact.Gift = Convert.ToInt32(db.GetParameterValue(dbCommand, "Gift"));
insightSupplierContact.AccessMethodId = Convert.ToInt32(db.GetParameterValue(dbCommand, "AccessMethodId"));
insightSupplierContact.Position = db.GetParameterValue(dbCommand, "Position").ToString();
insightSupplierContact.LicenseId = Convert.ToInt32(db.GetParameterValue(dbCommand, "LicenseId"));
insightSupplierContact.QlikviewVersionId = Convert.ToInt32(db.GetParameterValue(dbCommand, "QlikviewVersionId"));
insightSupplierContact.Username = db.GetParameterValue(dbCommand, "Username").ToString();
insightSupplierContact.Password = db.GetParameterValue(dbCommand, "Password").ToString();
return(insightSupplierContact);
}