public static System.Collections.Generic.List <AED_Redning> GetRedningListCompany(int CompanyID)
{
System.Collections.Generic.List <AED_Redning> result = new System.Collections.Generic.List <AED_Redning>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByCompany));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(AED_Redning.GetRedning(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static int Insert(AED_Redning R)
{
DBAccess db = new DBAccess();
AddParms(ref db, R);
SqlParameter objParam = new SqlParameter("@ID", 0);
objParam.Direction = ParameterDirection.Output;
db.Parameters.Add(objParam);
int retval = db.ExecuteNonQuery(_SQLInsert);
if (retval == 1)
{
int res = Funktioner.ToInt(objParam.Value.ToString());
R.ID = res;
AddLog(Status: "AED_Redning", Logtext: string.Format("Create AED_Redning: ID:{0}", R.ID), Metode: "Insert");
return(res);
}
else
{
AddLog(Status: "AED_Redning", Logtext: string.Format("Failure to Create AED_Redning:"), logtype: LogTypeEnum.Error, Metode: "Insert");
return(-1);
}
}
public static System.Collections.Generic.List <AED_Redning> GetRedningList(int AED_FK)
{
System.Collections.Generic.List <AED_Redning> result = new System.Collections.Generic.List <AED_Redning>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("AED_FK", AED_FK);
SqlDataReader dr = default(SqlDataReader);
//Try
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByAED));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(AED_Redning.GetRedning(ID));
}
}
dr.Close();
//Catch ex As Exception
//Throw ex
//End Try
return(result);
}
public static int Delete(int ID)
{
AED_Redning R = new AED_Redning();
R.ID = ID;
return(Delete(R));
}
public static int Delete(AED_Redning R)
{
DBAccess db = new DBAccess();
db.AddInt("ID", R.ID);
int retval = db.ExecuteNonQuery(_SQLDelete);
AddLog(Status: "AED_Redning", Logtext: string.Format("Delete AED_Redning: ID:{0}", R.ID), Metode: "Delete");
return(retval);
}
private static void AddParms(ref DBAccess db, AED_Redning c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("AED_FK", with_1.AED_FK);
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("RedningType", with_1.RedningType);
db.AddDateTime("RedningDate", with_1.RedningDate);
db.AddNVarChar("RedningNote", with_1.RedningNote, -1);
AddParmsStandard(db, c);
}
private static void Populate(System.Data.SqlClient.SqlDataReader dr, AED_Redning c)
{
var with_1 = c;
with_1.Status = (RescueTekniq.BOL.AEDStatusEnum)(dr.DBtoInt("Status"));
with_1.AED_FK = System.Convert.ToInt32(dr.DBtoInt("AED_FK"));
with_1.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID"));
with_1.RedningType = System.Convert.ToInt32(dr.DBtoInt("RedningType"));
with_1.RedningDate = System.Convert.ToDateTime(dr.DBtoDate("RedningDate"));
with_1.RedningNote = dr.DBtoString("RedningNote");
PopulateStandard(dr, c);
}
public static int Save(AED_Redning R)
{
int retval = 0;
if (R.ID > 0)
{
retval = Update(R);
}
else
{
retval = Insert(R);
}
return(retval);
}
public static int Update(int ID, AEDStatusEnum Status, int AED_FK, int CompanyID, int RedningType, DateTime RedningDate, string RedningNote)
{
AED_Redning c = new AED_Redning(ID);
c.Status = Status;
c.AED_FK = AED_FK;
c.CompanyID = CompanyID;
c.RedningType = RedningType;
c.RedningDate = RedningDate;
c.RedningNote = RedningNote;
return(Update(c));
}
public static AED_Redning GetRedning(int ID)
{
AED_Redning c = new AED_Redning();
DBAccess db = new DBAccess();
db.AddInt("ID", ID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}