public URUNS GetElementById(Guid URUN_ID, TransactionManager transactionManager)
{
URUNS cURUNSS = null;
SqlDataReader reader = null;
string selectsql = "select * from URUNS WITH (NOLOCK) WHERE URUN_ID=@URUN_ID";
SqlCommand cmd = new SqlCommand(selectsql);
cmd.Parameters.Add("@URUN_ID", SqlDbType.UniqueIdentifier, 16);
cmd.Parameters["@URUN_ID"].Value = URUN_ID;
fAssignNull(cmd);
if (transactionManager != null)
{
cmd.Connection = transactionManager.Connection;
cmd.Transaction = transactionManager.TransactionObject;
reader = cmd.ExecuteReader();
cURUNSS = fReadToClass(ref reader);
}
else
{
using (SqlConnection conn = new SqlConnection(this._connectionString))
{
conn.Open();
cmd.Connection = conn;
reader = cmd.ExecuteReader();
cURUNSS = fReadToClass(ref reader);
}
}
return(cURUNSS);
}
public URUNS GetElementByKod(string[] _KeyFields, object[] _Values, TransactionManager transactionManager)
{
if (_KeyFields == null || _KeyFields.Length == 0)
{
return(null);
}
if (_Values == null || _Values.Length == 0)
{
return(null);
}
if (_KeyFields.Length != _Values.Length)
{
return(null);
}
URUNS cURUNSS = null;
SqlDataReader reader = null;
string selectsql = "select top 1 * from URUNS WITH (NOLOCK) WHERE ";
string wherestr = "";
for (int _i = 0; _i <= _KeyFields.Length - 1; _i++)
{
if (wherestr.Trim() != "")
{
wherestr += " AND ";
}
wherestr += _KeyFields[_i] + "=@" + _KeyFields[_i];
}
selectsql += wherestr;
SqlCommand cmd = new SqlCommand(selectsql);
for (int _z = 0; _z <= _Values.Length - 1; _z++)
{
cmd.Parameters.Add(new SqlParameter("@" + _KeyFields[_z], _Values[_z]));
}
fAssignNull(cmd);
if (transactionManager != null)
{
cmd.Connection = transactionManager.Connection;
cmd.Transaction = transactionManager.TransactionObject;
reader = cmd.ExecuteReader();
cURUNSS = fReadToClass(ref reader);
}
else
{
using (SqlConnection conn = new SqlConnection(this._connectionString))
{
conn.Open();
cmd.Connection = conn;
reader = cmd.ExecuteReader();
cURUNSS = fReadToClass(ref reader);
}
}
return(cURUNSS);
}
public void fKaydetURUNS(URUNS cURUNSS, TransactionManager transactionManager)
{
if (cURUNSS.State == 1)
{
updateURUNS(cURUNSS, transactionManager);
}
else
{
insertURUNS(cURUNSS, transactionManager);
}
}
public URUNS fReadToClass(ref SqlDataReader reader)
{
URUNS cURUNSS = null;
if (reader.Read())
{
if (reader != null && !reader.IsClosed)
{
cURUNSS = new URUNS();
if (!reader.IsDBNull(0))
{
cURUNSS.URUN_ID = reader.GetGuid(0);
}
if (!reader.IsDBNull(1))
{
cURUNSS.URUN_BASLIK = reader.GetString(1);
}
if (!reader.IsDBNull(2))
{
cURUNSS.URUN_ICERIK = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
cURUNSS.URUN_MD = reader.GetDateTime(3);
}
if (!reader.IsDBNull(4))
{
cURUNSS.URUN_CD = reader.GetDateTime(4);
}
cURUNSS.State = 1;
}
}
reader.Close();
return(cURUNSS);
}
private void updateURUNS(URUNS cURUNSS, TransactionManager transactionManager)
{
try
{
SqlCommand cmd = new SqlCommand("usp_UpdateURUNS");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@URUN_ID", SqlDbType.UniqueIdentifier);
cmd.Parameters["@URUN_ID"].Value = cURUNSS.URUN_ID;
cmd.Parameters.Add("@URUN_BASLIK", SqlDbType.NVarChar);
cmd.Parameters["@URUN_BASLIK"].Value = cURUNSS.URUN_BASLIK;
cmd.Parameters.Add("@URUN_ICERIK", SqlDbType.NVarChar);
cmd.Parameters["@URUN_ICERIK"].Value = cURUNSS.URUN_ICERIK;
fAssignNull(cmd);
if (transactionManager != null)
{
cmd.Connection = transactionManager.Connection;
cmd.Transaction = transactionManager.TransactionObject;
cmd.ExecuteNonQuery();
}
else
{
using (SqlConnection conn = new SqlConnection(this._connectionString))
{
conn.Open();
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
}
}
catch
{
throw;
}
}
