public int InsertData(BlogPosition objcust) { SqlConnection con = null; int result; try { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString()); SqlCommand cmd = new SqlCommand("InserBlogs", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Title", objcust.Title); cmd.Parameters.AddWithValue("@Descriptions", objcust.Descriptions); cmd.Parameters.AddWithValue("@Detail", objcust.Detail); cmd.Parameters.AddWithValue("@Category", objcust.Category); cmd.Parameters.AddWithValue("@Status", objcust.Status); cmd.Parameters.AddWithValue("@DataPublic", objcust.DataPublic); cmd.Parameters.AddWithValue("@Thumbs", objcust.Thumbs); con.Open(); result = Convert.ToInt32(cmd.ExecuteScalar().ToString()); return(result); } catch { return(0); } finally { con.Close(); } }
void GetPosition() { BlogPosition listModul = new BlogPosition(); DdlPosition.Items.Clear(); for (int i = 0; i < listModul.Text.Length; i++) { DdlPosition.Items.Add(new ListItem(listModul.Text[i], listModul.Values[i])); } }
public ActionResult Create(BlogPosition objBlog) { if (ModelState.IsValid) { DataAccessLayer objDB = new DataAccessLayer(); var poscateid = objDB.InsertData(objBlog); foreach (var blogid in objBlog.Position) { objDB.InsertPosition(poscateid, blogid); } return(RedirectToAction("Index")); } return(View(objBlog)); }
string SetPosition(string value) { string s = "_"; BlogPosition listModul = new BlogPosition(); for (int i = 0; i < listModul.Values.Length; i++) { if (listModul.Values[i] == value) { s = listModul.Text[i]; break; } } return(s); }