private void displayrecords()
{
string rolename = Session["RoleName"].ToString();
string sql = "select roleid from SubMenuPermission where RoleName='" + rolename + "' ";
int roleid = cc.ExecuteScalar1(sql);
string sqldisplay = "select Id,usrFirstName+''+usrLastName as username,usrMobileNo,FileName,Committee_url from UserMaster inner join committeedetail on UserMaster.usrUserId =committeedetail.userid where roleid='" + roleid + "'";
DataSet ds = cc.ExecuteDataset(sqldisplay);
gvUser.DataSource = ds.Tables[0];
gvUser.DataBind();
}
private void displayrecords()
{
string rolename = Session["RoleName"].ToString();
string sql = "select roleid from SubMenuPermission where RoleName='" + rolename + "' ";
int roleid = cc.ExecuteScalar1(sql);
string sqldisplay = "select Committee_url,FileName from committeedetail where roleid='" + roleid + "'";
DataSet ds = cc.ExecuteDataset(sqldisplay);
GridShow.DataSource = ds.Tables[0];
GridShow.DataBind();
}
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 void AddUDISE_SCHOOL(string SchoolCode, string SchoolName, string Mgmt, string Type, string ClassL, string ClassH)
{
try
{
string CheckCode = "select SchoolId from UDISE_SchoolMaster where SchoolCode='" + SchoolCode + "'";
status = cc.ExecuteScalar1(CheckCode);
if (!(status == null || status == 0))
{
string str = "Update UDISE_SchoolMaster set SchoolName='" + SchoolName + "',Management='" + Mgmt + "',SchoolType='" + Type + "',LowClass=" + ClassL + ", HighClass=" + ClassH + " where SchoolCode='" + SchoolCode + "'";
status = cc.ExecuteNonQuery(str);
}
else
{
string str = "insert into UDISE_SchoolMaster " +
"(SchoolCode,SchoolName,Management,SchoolType,LowClass,HighClass)values" +
"('" + SchoolCode + "','" + SchoolName + "','" + Mgmt + "','" + Type + "'," + ClassL + "," + ClassH + ")";
status = cc.ExecuteNonQuery(str);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string Role = Convert.ToString(Session["RoleId"]);
if (Role == "28" || Role == "29")
{
string Id = Request.QueryString["Id"];
string userid = Session["MarketingUser"].ToString();
DateTime date = System.DateTime.Now;
if (myFile.HasFile)
{
try
{
string path = "";
filename = myFile.FileName;
string mobileno = Convert.ToString(Session["MobileNumber"]);
string sql = "select Committee_name,Committee_url from committeedetail where Id='" + Id + "'";
DataSet dset = cc.ExecuteDataset(sql);
string committeename = Convert.ToString(dset.Tables[0].Rows[0]["Committee_name"]);
string comitteeurl = Convert.ToString(dset.Tables[0].Rows[0]["Committee_url"]);
if (Id != "")
{
string thisDir = Server.MapPath("~/downloadfilesMLA/");
System.IO.Directory.CreateDirectory(thisDir + committeename + "");
string newpa = "" + thisDir + committeename + "";
string newpath = Server.MapPath("~/downloadfilesMLA/" + committeename + "");
path = newpath + "\\" + myFile.FileName;
string ePath = newpa;
System.IO.DirectoryInfo di = new DirectoryInfo(ePath);
FileInfo[] fiArr = di.GetFiles();
foreach (FileInfo fi in fiArr)
{
fi.Delete();
}
myFile.SaveAs(path);
string type = System.IO.Path.GetExtension(myFile.FileName);
string sqlupdate = "update committeedetail set FileName='" + filename + "',userid='" + userid + "' where Id='" + Id + "' and Committee_name='" + committeename + "'";
int status = cc.ExecuteScalar1(sqlupdate);
if (status == 0)
{
displayrecords();
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('File added Successfully')", true);
Response.Write("<script>(alert)('File Uploaded Successfully')</script>");
}
}
}
catch (Exception ex)
{ }
}
}
else if (Role == "38")
{
string Id = Request.QueryString["Id"];
string userid = Session["MarketingUser"].ToString();
DateTime date = System.DateTime.Now;
if (myFile.HasFile)
{
try
{
string path = "";
filename = myFile.FileName;
string mobileno = Convert.ToString(Session["MobileNumber"]);
string sql = "select Committee_name,Committee_url from committeedetail where Id='" + Id + "'";
DataSet dset = cc.ExecuteDataset(sql);
string committeename = Convert.ToString(dset.Tables[0].Rows[0]["Committee_name"]);
string comitteeurl = Convert.ToString(dset.Tables[0].Rows[0]["Committee_url"]);
if (Id != "")
{
string thisDir = Server.MapPath("~/download files/");
System.IO.Directory.CreateDirectory(thisDir + committeename + "");
string newpa = "" + thisDir + committeename + "";
string newpath = Server.MapPath("~/download files/" + committeename + "");
path = newpath + "\\" + myFile.FileName;
string ePath = newpa;
System.IO.DirectoryInfo di = new DirectoryInfo(ePath);
FileInfo[] fiArr = di.GetFiles();
foreach (FileInfo fi in fiArr)
{
fi.Delete();
}
myFile.SaveAs(path);
string type = System.IO.Path.GetExtension(myFile.FileName);
string sqlupdate = "update committeedetail set FileName='" + filename + "',userid='" + userid + "' where Id='" + Id + "' and Committee_name='" + committeename + "'";
int status = cc.ExecuteScalar1(sqlupdate);
if (status == 0)
{
displayrecords();
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('File added Successfully')", true);
Response.Write("<script>(alert)('File Uploaded Successfully')</script>");
}
}
}
catch (Exception ex)
{ }
}
}
else if (Role == "37")
{
string userid = Session["MarketingUser"].ToString();
DateTime date = System.DateTime.Now;
string Id = "32";
string sql = "select Committee_name,Committee_url from committeedetail where Id='" + Id + "'";
DataSet dset = cc.ExecuteDataset(sql);
string committeename = Convert.ToString(dset.Tables[0].Rows[0]["Committee_name"]);
string comitteeurl = Convert.ToString(dset.Tables[0].Rows[0]["Committee_url"]);
if (myFile.HasFile)
{
try
{
string path = "";
filename = myFile.FileName;
string mobileno = Convert.ToString(Session["MobileNumber"]);
if (Id != "")
{
string thisDir = Server.MapPath("~/downloadfilesMPCC/");
System.IO.Directory.CreateDirectory(thisDir);
string newpath = Server.MapPath("~/downloadfilesMPCC/");
path = newpath + "\\" + myFile.FileName;
string ePath = newpath;
System.IO.DirectoryInfo di = new DirectoryInfo(thisDir);
FileInfo[] fiArr = di.GetFiles();
foreach (FileInfo fi in fiArr)
{
fi.Delete();
}
myFile.SaveAs(path);
string sqlupdate = "update committeedetail set FileName='" + filename + "',userid='" + userid + "',roleid='" + Role + "' where Id='" + Id + "' and Committee_name='" + committeename + "'";
int status = cc.ExecuteScalar1(sqlupdate);
if (status == 0)
{
displayrecords();
Response.Write("<script>(alert)('File Uploaded Successfully')</script>");
}
}
}
catch (Exception ex)
{ }
}
}
}
