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