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