public bool Update(string vkn, GlobalEnum.Modul modul, GlobalEnum.PARTNER_PARAMETERS parameter, string value)
{
using (SqlConnection connection = new SqlConnection(GlobalSettings.OrganizationConnectionString))
{
connection.Open();
using (System.Data.SqlClient.SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = @" UPDATE ParameterValues
SET Value = @Value
WHERE VKN = @VKN and ModulId = @ModulId AND TypeID=@TypeId";
cmd.Parameters.AddWithValue("@Value", value);
cmd.Parameters.AddWithValue("@ModulId", (int)modul);
cmd.Parameters.AddWithValue("@VKN", vkn);
cmd.Parameters.AddWithValue("@TypeId", (int)parameter);
int sonuc = cmd.ExecuteNonQuery();
if (sonuc > 1)
return true;
}
}
return false;
}
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;
}
public List<ParameterValues> GetAllParameterValuesForEledger(string connection, GlobalEnum.Modul pModulID, string pVKN, string pDataType = "")
{
var ParameterValueList = new List<ParameterValues>();
using (var con = new SqlConnection(connection))
{
if (con.State != System.Data.ConnectionState.Open)
con.Open();
using (var cmd = con.CreateCommand())
{
cmd.CommandText = @"SELECT TypeID, ParameterID, TopParameterID, VKN, ModulId, DataType, ApplicationType
,Value, Description, Secured, Required, FL_ACTIVE, Versiyon
FROM ParameterValues
WHERE ModulID = @ModulID AND VKN = @VKN";
if (!string.IsNullOrEmpty(pDataType))
{
cmd.CommandText += @" AND DataType = @DataType";
cmd.Parameters.AddWithValue("@DataType", pDataType);
}
cmd.Parameters.AddWithValue("@VKN", pVKN);
cmd.Parameters.AddWithValue("@ModulID", (int)pModulID);
cmd.CommandText += @" ORDER BY TypeID";
using (DataTable dt = DB_Gateway.ExecuteDataTable(cmd, con))
{
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
ParameterValues parameterValue = new ParameterValues();
parameterValue.TransferToClass(dr);
ParameterValueList.Add(parameterValue);
}
}
}
}
}
return ParameterValueList;
}
public List<ParameterValues> GetAllByModulIDTypeID(GlobalEnum.Modul ModulID, GlobalEnum.PARTNER_PARAMETERS TypeID)
{
var list = new List<ParameterValues>();
using (var con = new SqlConnection(GlobalSettings.OrganizationConnectionString))
{
if (con.State != System.Data.ConnectionState.Open)
con.Open();
using (var cmd = con.CreateCommand())
{
cmd.CommandText = @"SELECT ParameterValues.Value,Partner.VKN ,ParameterValues.Secured
FROM ParameterValues
INNER JOIN Partner ON Partner.VKN = ParameterValues.VKN
WHERE Partner.FL_ACTIVE = 1 AND Partner.Active = 1
AND ParameterValues.TypeID = @TypeID
AND ParameterValues.ModulID = @ModulID
AND ParameterValues.FL_ACTIVE = 1";
cmd.Parameters.AddWithValue("@TypeID", (int)TypeID);
cmd.Parameters.AddWithValue("@ModulID", (int)ModulID);
using (DataTable dt = DB_Gateway.ExecuteDataTable(cmd, con))
{
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
ParameterValues value = new ParameterValues();
value.TransferToClass(dr);
list.Add(value);
}
}
}
}
}
return list;
}
public static string GetAppSetting(GlobalEnum.AppSettings appSetting)
{
return GetAppSetting(appSetting.ToString());
}
public static string getApplicationSystemSettingsStr(GlobalEnum.AppConfig key)
{
return getApplicationSystemSettingsStr(key.ToString());
}
public static bool getApplicationSystemSettingsBool(GlobalEnum.AppConfig key, bool byDefault = false)
{
string value = getApplicationSystemSettingsStr(key);
if (value == null)
return byDefault;
bool result = byDefault;
Boolean.TryParse(value.ToLower(), out result);
return result;
}
