public static List <Site_Model> RetrieveData(SqlConnection connection, int idSite)
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"SELECT idSite
,Site_Name
,Site_Desc
FROM a_Site ");
if (idSite != 0)
{
sQuery.Append(" WHERE idSite = @idSite ");
}
var lmodel = new List <Site_Model>();
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
if (idSite != 0)
{
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@idSite",
SqlDbType = SqlDbType.Int,
Value = idSite
};
cmd.Parameters.Add(parm2);
}
var oreader = cmd.ExecuteReader();
while (oreader.Read())
{
Site_Model oModel = new Site_Model
{
idSite = (int)oreader["idSite"],
Site_Name = (string)oreader["Site_Name"],
Site_Desc = (string)oreader["Site_Desc"]
};
lmodel.Add(oModel);
}
cmd.Dispose();
}
connection.Close();
return(lmodel);
}
public static bool Save(SqlConnection connection, Site_Model model)
{
bool returnValue = true;
StringBuilder sQuery = new StringBuilder();
try
{
sQuery.Append(@"INSERT INTO a_Site
(Site_Name
,Site_Desc)
VALUES
(@Site_Name
,@Site_Desc)");
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@Site_Name",
SqlDbType = SqlDbType.NVarChar,
Value = model.Site_Name
};
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter
{
ParameterName = "@Site_Desc",
SqlDbType = SqlDbType.NVarChar,
Value = model.Site_Desc
};
cmd.Parameters.Add(parm3);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
}
cmd.Dispose();
cmd.Parameters.Clear();
}
connection.Close();
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
return(returnValue);
}
protected void btnSaveSite_Click(object sender, EventArgs e)
{
Site_Model mdlCL = new Site_Model
{
Site_Desc = txtSiteDesc.Text.Trim(),
Site_Name = txtSiteName.Text.Trim()
};
if (Session["siteMode"].ToString() == "Save")
{
Site_Loc.Save(oCon, mdlCL);
}
else if (Session["siteMode"].ToString() == "Update")
{
mdlCL.idSite = Convert.ToInt32(Session["idSite"].ToString());
Site_Loc.Update(oCon, mdlCL);
}
clearSite();
getSite();
}
