internal static List <GirisLog> GetGirisLogByKullaniciByTransaction(int kullanici)
{
List <GirisLog> returnValue = new List <GirisLog>();
SqlDataReader sqlDataReader = null;
try
{
string query = @"SELECT [Fk_Kullanici],[ProgramNo],[GirisTarihi],[LogId] FROM [dbo].[GIRIS_LOG] WHERE [Fk_Kullanici]=@Kullanici";
sqlDataReader = SqlHelper.GetDataReaderByTransaction(query, new DinamikSqlParameter("@Kullanici", kullanici));
while (sqlDataReader.Read())
{
GirisLog obj = new GirisLog();
obj.LogId = Convert.ToInt64(sqlDataReader["LogId"]);
obj.Kullanici = Convert.ToInt32(sqlDataReader["Fk_Kullanici"]);
obj.ProgramNo = Convert.ToByte(sqlDataReader["ProgramNo"]);
obj.GirisTarihi = Convert.ToDateTime(sqlDataReader["GirisTarihi"]);
returnValue.Add(obj);
}
return(returnValue);
}
catch (Exception ex)
{
CommonHelper.WriteLog("GetGirisLogByKullaniciByTransaction()", string.Format("HATA: {0}", ex.Message));
throw ex;
}
finally
{
if (sqlDataReader != null)
{
if (!sqlDataReader.IsClosed)
{
sqlDataReader.Close();
}
sqlDataReader.Dispose();
}
}
}
internal static void UpdateGirisLog(GirisLog girisLog)
{
try
{
string query = @"UPDATE [dbo].[GIRIS_LOG]
SET [Fk_Kullanici]=@Kullanici,[ProgramNo]=@ProgramNo,[GirisTarihi]=@GirisTarihi
WHERE [LogId]=@LogId";
List <DinamikSqlParameter> parameters = new List <DinamikSqlParameter>();
parameters.Add(new DinamikSqlParameter("@LogId", girisLog.LogId));
parameters.Add(new DinamikSqlParameter("@Kullanici", girisLog.Kullanici));
parameters.Add(new DinamikSqlParameter("@ProgramNo", girisLog.ProgramNo));
parameters.Add(new DinamikSqlParameter("@GirisTarihi", girisLog.GirisTarihi));
SqlHelper.ExecuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
CommonHelper.WriteLog("UpdateGirisLog()", string.Format("HATA: {0}", ex.Message));
throw ex;
}
}
public static long InsertGirisLog(GirisLog girisLog)
{
try
{
string query = @"INSERT INTO [dbo].[GIRIS_LOG]([Fk_Kullanici],[ProgramNo],[GirisTarihi])
VALUES(@Kullanici,@ProgramNo,@GirisTarihi);
SELECT @@IDENTITY";
List <DinamikSqlParameter> parameters = new List <DinamikSqlParameter>();
parameters.Add(new DinamikSqlParameter("@Kullanici", girisLog.Kullanici));
parameters.Add(new DinamikSqlParameter("@ProgramNo", girisLog.ProgramNo));
parameters.Add(new DinamikSqlParameter("@GirisTarihi", girisLog.GirisTarihi));
object objId = SqlHelper.GetScalarValue(query, parameters.ToArray());
return(objId == null || objId == DBNull.Value ? (long)0 : Convert.ToInt32(objId));
}
catch (Exception ex)
{
CommonHelper.WriteLog("InsertGirisLog()", string.Format("HATA: {0}", ex.Message));
throw ex;
}
}
internal static GirisLog GetGirisLogById(long logId)
{
SqlDataReader sqlDataReader = null;
try
{
string query = @"SELECT [Fk_Kullanici],[ProgramNo],[GirisTarihi],[LogId] FROM [dbo].[GIRIS_LOG] WHERE [LogId]=@LogId";
sqlDataReader = SqlHelper.GetDataReader(query, new DinamikSqlParameter("@LogId", logId));
if (sqlDataReader.Read())
{
GirisLog obj = new GirisLog();
obj.LogId = Convert.ToInt64(sqlDataReader["LogId"]);
obj.Kullanici = Convert.ToInt32(sqlDataReader["Fk_Kullanici"]);
obj.ProgramNo = Convert.ToByte(sqlDataReader["ProgramNo"]);
obj.GirisTarihi = Convert.ToDateTime(sqlDataReader["GirisTarihi"]);
return(obj);
}
return(null);
}
catch (Exception ex)
{
CommonHelper.WriteLog("GetGirisLogById()", string.Format("HATA: {0}", ex.Message));
throw ex;
}
finally
{
if (sqlDataReader != null)
{
if (!sqlDataReader.IsClosed)
{
sqlDataReader.Close();
}
sqlDataReader.Dispose();
}
}
}