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