public List<cls_Partner> GetAllListNewPartner(System.Data.SqlClient.SqlConnection connection)
{
List<cls_Partner> PartnerList = new List<cls_Partner>();
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "SELECT TOP 1 * FROM Partner WHERE FL_ACTIVE = 1 ORDER BY PartnerID DESC";
using (DataTable dt = DB_Gateway.ExecuteDataTable(cmd, connection))
{
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
cls_Partner objPartner = new cls_Partner();
objPartner.TransferToClass(dr);
PartnerList.Add(objPartner);
}
}
}
}
if (connection != null) connection.Close();
return PartnerList;
}
public List<cls_Partner> GetAllByModulId(System.Data.SqlClient.SqlConnection connection, int ModuleId)
{
List<cls_Partner> PartnerList = new List<cls_Partner>();
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = @" SELECT * FROM Partner WHERE FL_ACTIVE = 1 and VKN in ( SELECT distinct VKN_TCKN FROM PartnerModules WHERE ModuleId = @ModuleId )";
cmd.Parameters.AddWithValue("@ModuleId", ModuleId);
using (DataTable dt = DB_Gateway.ExecuteDataTable(cmd, connection))
{
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
cls_Partner objPartner = new cls_Partner();
objPartner.TransferToClass(dr);
PartnerList.Add(objPartner);
}
}
}
}
if (connection != null) connection.Close();
return PartnerList;
}
public List<cls_Partner> GetAllByVKN(string connectionString, string VKN)
{
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
List<cls_Partner> result = new List<cls_Partner>();
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "SELECT * FROM Partner WHERE VKN = @pVKN";
cmd.Parameters.AddWithValue("@pVKN", VKN);
using (DataTable dt = DB_Gateway.ExecuteDataTable(cmd, connection))
{
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
cls_Partner pa = new cls_Partner();
pa.TransferToClass(dr);
result.Add(pa);
}
}
}
if (connection != null) connection.Close();
return result;
}
}
}
public List<cls_Partner> GetAll(System.Data.SqlClient.SqlConnection connection, GlobalEnum.FL_ACTIVE pFL_ACTIVE)
{
List<cls_Partner> PartnerList = new List<cls_Partner>();
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "Select * FROM Partner " + ((pFL_ACTIVE != GlobalEnum.FL_ACTIVE.ALL) ? "where FL_ACTIVE = @pFL_ACTIVE" : "");
cmd.Parameters.AddWithValue("@pFL_ACTIVE", pFL_ACTIVE);
using (DataTable dt = DB_Gateway.ExecuteDataTable(cmd, connection))
{
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
cls_Partner objPartner = new cls_Partner();
objPartner.TransferToClass(dr);
PartnerList.Add(objPartner);
}
}
}
}
if (connection != null) connection.Close();
return PartnerList;
}