public ActionResult edit(string id, string gid) { Populate DropDown = new Populate(); Db_Connection dbconn = new Db_Connection(); try { dbconn.openConnection(); string strSQL = @"SELECT STORAGE FROM STORAGE WHERE ID=@ID AND GID=@GID"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id; cmd.Parameters.Add("GID", SqlDbType.VarChar).Value = gid; SqlDataReader dr = cmd.ExecuteReader(); mdlStorage record = new mdlStorage(); record.ID = id; record.GID = gid; if (dr.HasRows) { dr.Read(); record.ID = id; record.GID = gid; record.STORAGE = dr["STORAGE"].ToString(); } return(PartialView(record)); } finally { dbconn.closeConnection(); } }
// // GET: /en/Firearmtype/ public ActionResult Index() { Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT ID,GID,STORAGE FROM STORAGE ORDER BY STORAGE ASC"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); SqlDataReader dr = cmd.ExecuteReader(); List <mdlStorage> record = new List <mdlStorage>(); if (dr.HasRows) { while (dr.Read()) { mdlStorage list = new mdlStorage(); list.ID = dr["ID"].ToString(); list.GID = dr["GID"].ToString(); list.STORAGE = dr["STORAGE"].ToString(); record.Add(list); } } dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(View(record)); } finally { dbconn.closeConnection(); } }