public int insertUserCommiteeUpdated(BLLFileUpload bllfile)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[5];
par[0] = new SqlParameter("@Committee_name", bllfile.Commiteename);
par[1] = new SqlParameter("@Committee_url", bllfile.Commiteeurl);
par[2] = new SqlParameter("@FileName", bllfile.Filename);
par[3] = new SqlParameter("@roleid", bllfile.Roleid);
par[4] = new SqlParameter("Status", 6);
par[4].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "InsertCommiteeRoleUpdate", par);
status = (int)par[4].Value;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(status);
}
public int DALinsertFileUpload(BLLFileUpload bllfile)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
try
{
string sql1 = "insert into committeedetail(Committee_name,Committee_url,FileName,roleid,userid)values('" + bllfile.Commiteename + "','" + bllfile.Commiteeurl + "','" + bllfile.Filename + "','" + bllfile.Roleid + "','" + bllfile.Userid + "')";
status = cc.ExecuteScalar1(sql1);
}
catch (Exception ex)
{
}
}
return(status);
}
public int BLLInsertUserCommitteeUpdated(BLLFileUpload bllfile)
{
status = dalfile.insertUserCommiteeUpdated(bllfile);
return(status);
}
public int BLLinsertFileupload(BLLFileUpload bllfile)
{
status = dalfile.DALinsertFileUpload(bllfile);
return(status);
}
