public int AddRecord(EventMain1_IDBLL SPMI) { int row; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); DataSet ds = new DataSet(); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@ID", SPMI.ID1), new SqlParameter("@Sub_ID", SPMI.Sub_ID1), new SqlParameter("@Name", SPMI.Name1), new SqlParameter("@Description", SPMI.Description1), new SqlParameter("@User", SPMI.User1), new SqlParameter("@UserId", SPMI.UserId1) }; SqlCommand cmd = new SqlCommand("EventMain_IDInsert", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); con.Open(); row = cmd.ExecuteNonQuery(); return(row); } catch (Exception ex) { throw ex; } }
public int AddrecordBLL(EventMain1_IDBLL objEMain1_IDBLL) { int i = objEMain1_IDDAL.AddRecord(objEMain1_IDBLL); return(i); }