public static System.Collections.Generic.List <VareGrp> GetVareGrpList()
{
System.Collections.Generic.List <VareGrp> result = new System.Collections.Generic.List <VareGrp>();
int ID = -1;
DBAccess db = new DBAccess();
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAll));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(VareGrp.GetVareGrp(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static string Tags(string tekst, RescueTekniq.BOL.VareGrp item)
{
StringBuilder sb = new StringBuilder();
sb.Append(tekst);
sb.Replace("[VARE.VAREGRP]", item.VareGrpNr);
sb.Replace("[VARE.VAREGRPTEKST]", item.VareGrpTekst);
return(sb.ToString());
}
private static void Populate(SqlDataReader dr, VareGrp c)
{
var with_1 = c;
with_1.ParentID = System.Convert.ToInt32(dr.DBtoInt("ParentID"));
with_1.VareGrpNr = dr.DBtoString("VareGrpNr");
with_1.VareGrpTekst = dr.DBtoString("VareGrpTekst");
with_1.Alias = dr.DBtoString("Alias");
PopulateStandard(dr, c);
}
public static int Update(int ID, int ParentID, string VareGrpNr, string VareGrpTekst)
{
VareGrp c = new VareGrp(ID);
c.ParentID = ParentID;
c.VareGrpNr = VareGrpNr;
c.VareGrpTekst = VareGrpTekst;
return(Update(c));
}
private static void AddParms(ref DBAccess db, VareGrp c)
{
var with_1 = c;
db.AddInt("ParentID", with_1.ParentID);
db.AddNVarChar("VareGrpNr", with_1.VareGrpNr, 50);
db.AddNVarChar("VareGrpTekst", with_1.VareGrpTekst, 50);
db.AddNVarChar("Alias", with_1.Alias, 50);
AddParmsStandard(db, c);
}
public static int Update(VareGrp c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery(_SQLUpdate);
return(retval);
}
public static int Insert(int ParentID, string
VareGrpNr,
string VareGrpTekst)
{
VareGrp c = new VareGrp();
c.ParentID = ParentID;
c.VareGrpNr = VareGrpNr;
c.VareGrpTekst = VareGrpTekst;
return(Insert(c));
}
public static int Save(VareGrp c)
{
int retval = 0;
if (c.ID > 0)
{
retval = Update(c);
}
else
{
retval = Insert(c);
}
return(retval);
}
public static VareGrp GetVareGrpByAlias(string Alias)
{
DBAccess db = new DBAccess();
db.AddNVarChar("Alias", Alias, 50);
VareGrp c = new VareGrp();
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByAlias));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}
public static int Insert(VareGrp c)
{
DBAccess db = new DBAccess();
AddParms(ref db, c);
SqlParameter objParam = new SqlParameter("@ID", 0);
objParam.Direction = ParameterDirection.Output;
db.Parameters.Add(objParam);
int retval = db.ExecuteNonQuery(_SQLInsert);
if (retval == 1)
{
return(int.Parse(objParam.Value.ToString()));
}
else
{
return(-1);
}
}
public static VareGrp GetVareGrp(int ID)
{
DBAccess db = new DBAccess();
db.AddInt("ID", ID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne));
if (dr.HasRows)
{
VareGrp c = new VareGrp();
while (dr.Read())
{
Populate(dr, c);
}
dr.Close();
return(c);
}
else
{
dr.Close();
return(null);
}
}
public static int Delete(VareGrp c)
{
return(Delete(c.ID));
}
