public static ResultObje Saves(List <ParamValue> paramValues, string table)
{
var result = new ResultObje();
try
{
using (var connection = DBHelper.Connection())
{
var param = paramValues.Aggregate(
string.Empty, (current, paramValue) => current + string.Format("{0},", paramValue.Key));
var value = paramValues.Aggregate(
string.Empty, (current, paramValue) => current + string.Format("@{0},", paramValue.Key));
result.id = DataProcessingInsert.Insert(table, param, value, connection, paramValues);
connection.Close();
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
result.Mesaj = ex.Message;
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// The entity management update.
/// </summary>
/// <param name="entity">
/// The entity.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
/// <exception cref="Exception">
/// </exception>
public static ResultObje Update(T entity)
{
var type = typeof(T);
if (type.Name == "Object")
{
type = entity.GetType();
}
var result = new ResultObje();
var pkProperty = type.GetProperties()
.Where(p => p.GetCustomAttributes(typeof(PrimaryKeyAttribute), true).Length > 0)
.FirstOrDefault();
try
{
var table = (entity).GetType().BaseType.Name == "Object" ? entity.GetType().Name : (entity).GetType().BaseType.Name;
string selectSql = string.Format("{0} * {1} {2} {3} {4}= @p1", SqlQueryEnum.SELECT, SqlQueryEnum.FROM,
table, SqlQueryEnum.WHERE, pkProperty.Name);
var adapter = new SqlDataAdapter(selectSql, DBHelper.Connection());
adapter.SelectCommand.Parameters.AddWithValue("@p1", pkProperty.GetValue(entity, null));
var dTable = new System.Data.DataTable();
adapter.Fill(dTable);
var row = dTable.Rows[0];
EntityValue <T> .GetValueRow(entity, dTable, type, ref row);
var cmdBuilder = new SqlCommandBuilder(adapter);
adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
result.success = true;
try
{
adapter.Update(new[] { row });
}
catch (Exception ex)
{
result.success = false;
result.Mesaj = ex.Message;
throw new Exception(ex.Message);
}
}
catch (Exception ex)
{
result.success = false;
result.Mesaj = ex.Message;
throw new Exception("Pk Attribute Olmadığı İçin Kayıt Yapılamaz. HATA KODU: " + ex.Message);
}
return(result);
}
/// <summary>
/// Daha İyi Bir Şekilde Yazılmalı
/// </summary>
/// <param name="entity"></param>
/// <param name="dbTablo"></param>
/// <returns></returns>
public static ResultObje Saves(List <T> entity, object dbTablo = null)
{
var result = new ResultObje();
try
{
using (var connection = DBHelper.Connection())
{
var tblName = entity.FirstOrDefault();
if (tblName != null && dbTablo == null)
{
dbTablo = (tblName).GetType().BaseType.Name == "Object" ? tblName.GetType().Name : (tblName).GetType().BaseType.Name;
}
foreach (var item in entity)
{
var param = string.Empty;
var value = string.Empty;
var paramValues = new List <ParamValue>();
var property = PropertiesTransactions <T> .DefaulRemoveValueProperty(item, dbTablo);
var props = new List <PropertyInfo>(property);
EntityValue <T> .GetValue(item, props, ref param, ref value, ref paramValues);
connection.Open();
result.id = DataProcessingInsert.Insert(dbTablo, param, value, connection, paramValues);
connection.Close();
}
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
result.Mesaj = ex.Message;
throw new Exception(ex.Message);
}
return(result);
}
public static ResultObje Saves(T entity, string dbTablo = null)
{
var result = new ResultObje();
try
{
if (string.IsNullOrEmpty(dbTablo))
{
dbTablo = (entity).GetType().BaseType.Name == "Object" ? entity.GetType().Name : (entity).GetType().BaseType.Name;
}
using (var connection = DBHelper.Connection())
{
var param = string.Empty;
var value = string.Empty;
var paramValues = new List <ParamValue>();
var property = PropertiesTransactions <T> .DefaulRemoveValueProperty(entity, dbTablo);
var props = new List <PropertyInfo>(property);
EntityValue <T> .GetValue(entity, props, ref param, ref value, ref paramValues);
connection.Open();
result.id = DataProcessingInsert.Insert(dbTablo, param, value, connection, paramValues);
connection.Close();
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
result.Mesaj = ex.Message;
throw new Exception(ex.Message);
}
return(result);
}