protected void Page_Load(object sender, EventArgs e)
{
if (Session["userName"] == null || !(Session["roleNumber"].ToString().Equals("2")))
{
Response.Redirect("NotAuthorizatedPage.aspx");
}
String myConnectionString;
myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
MySqlConnection conn = new MySqlConnection(myConnectionString);
conn.Open();
string querycity = "select * from city order by CityName";
MySqlCommand cmd = new MySqlCommand(querycity, conn);
MySqlDataAdapter da = new MySqlDataAdapter {
SelectCommand = cmd
};
DataSet ds = new DataSet();
da.Fill(ds);
if (!IsPostBack)
{
DropDownListCity.DataTextField = ds.Tables[0].Columns["CityName"].ToString();
DropDownListCity.DataSource = ds.Tables[0];
DropDownListCity.DataBind();
DropDownListCity.SelectedItem.Text = "";
}
string querydistrict = "select * from district order by Name";
MySqlCommand cmddistrict = new MySqlCommand(querydistrict, conn);
MySqlDataAdapter dadistrict = new MySqlDataAdapter {
SelectCommand = cmddistrict
};
DataSet dsdistrict = new DataSet();
dadistrict.Fill(dsdistrict);
if (!IsPostBack)
{
DropDownListDistrict.DataTextField = dsdistrict.Tables[0].Columns["Name"].ToString();
DropDownListDistrict.DataSource = dsdistrict.Tables[0];
DropDownListDistrict.DataBind();
DropDownListDistrict.SelectedItem.Text = "";
}
string queryneighborhood = "select * from neighborhood order by Name";
MySqlCommand cmdneighborhood = new MySqlCommand(queryneighborhood, conn);
MySqlDataAdapter daneighborhood = new MySqlDataAdapter {
SelectCommand = cmdneighborhood
};
DataSet dsneighborhood = new DataSet();
daneighborhood.Fill(dsneighborhood);
if (!IsPostBack)
{
DropDownListNeighborhood.DataTextField = dsneighborhood.Tables[0].Columns["Name"].ToString();
DropDownListNeighborhood.DataSource = dsneighborhood.Tables[0];
DropDownListNeighborhood.DataBind();
DropDownListNeighborhood.SelectedItem.Text = "";
}
conn.Close();
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
if (DropDownListDistrict.SelectedIndex <= 0)
{
LabelValidateDistrict.Text = "Select District !!!";
LabelValidateDistrict.ForeColor = System.Drawing.Color.Red;
DropDownListDistrict.Focus();
}
else if (DropDownListTehsil.SelectedIndex <= 0)
{
LabelValidateTehsil.Text = "Select Tehsil !!!";
LabelValidateTehsil.ForeColor = System.Drawing.Color.Red;
DropDownListTehsil.Focus();
}
else if (string.IsNullOrWhiteSpace(TextBoxName.Text))
{
RequiredFieldValidatorName.ErrorMessage = "Enter Name !!!";
TextBoxName.Focus();
}
else if (string.IsNullOrWhiteSpace(TextBoxDesgination.Text))
{
RequiredFieldValidatorDesgination.ErrorMessage = "Enter Designation !!!";
TextBoxDesgination.Focus();
}
else if (string.IsNullOrWhiteSpace(TextBoxContactNo.Text))
{
RequiredFieldValidatorContactNo.ErrorMessage = "Enter Contact No !!!";
TextBoxDesgination.Focus();
}
else if (string.IsNullOrWhiteSpace(TextBoxApprentIssue.Text))
{
RequiredFieldValidatorApprentIssue.ErrorMessage = "Enter Apprent Issue!!!";
TextBoxApprentIssue.Focus();
}
else if (string.IsNullOrWhiteSpace(TextBoxComments.Text))
{
RequiredFieldValidatorComments.ErrorMessage = "Enter Comment!!!";
TextBoxComments.Focus();
}
else if (string.IsNullOrWhiteSpace(TextBoxSubheadnameLocation.Text))
{
RequiredFieldValidatorSubheadnameLocation.ErrorMessage = "Enter SubHead Name & Location!!!";
TextBoxSubheadnameLocation.Focus();
}
else
{
var images = new List <string>();
int filelenght = Request.Files.Count;
if (filelenght > 3)
{
for (int i = 0; i < 3; i++)
{
HttpPostedFile fu = Request.Files[i];
if (fu.ContentLength > 0)
{
try
{
string fileName = Path.GetFileName(fu.FileName);
fu.SaveAs(Server.MapPath("~/Upload/") + fileName);
string imagePath = fileName;
images.Add(imagePath);
lblmsg.Text = "Files have been Uploaded";
lblmsg.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
lblmsg.Text = "File Could not be uploaded" + ex.Message;
lblmsg.ForeColor = System.Drawing.Color.Red;
}
}
}
}
else
{
for (int i = 0; i < Request.Files.Count; i++)
{
HttpPostedFile fu = Request.Files[i];
if (fu.ContentLength > 0)
{
try
{
string fileName = Path.GetFileName(fu.FileName);
fu.SaveAs(Server.MapPath("~/Upload/") + fileName);
string imagePath = fileName;
images.Add(imagePath);
lblmsg.Text = "Files have been Uploaded";
lblmsg.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
lblmsg.Text = "File Could not be uploaded" + ex.Message;
lblmsg.ForeColor = System.Drawing.Color.Red;
}
}
}
}
string[] authors = { "Agriculture", "AUQAF", "Board Revenue", "District ADP", "Drinking Water and Sanitation", "Elementary & Secondary Education", "Energy & Power", "Environment", "Establishment & Administration", "Excise & Taxation", "Finance", "Food", "Health", "Higher Education", "Home", "Housing", "Industries", "Information", "Labour", "Law & Justice", "Local Government", "Mines & Minerals", "MULTI SECTORAL DEVELOPMENT", "Population Welfare", "Relief & Rehabilitation", "Roads", "Social Welfare", "Special Initiatives", "Sports, Culture, Tourism, Archaeology & Youth Affairs", "ST&IT", "Transport", "Urban Development", "Water" };
// Create a Random object
Random rand = new Random();
// Generate a random index less than the size of the array.
int index = rand.Next(authors.Length);
// Display the result.
string dep = authors[index].ToString();
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
conn = new SqlConnection(ConnectionString);
conn.Open();
using (var sqlCommand = new SqlCommand())
{
sqlCommand.Connection = conn;
sqlCommand.CommandText = "INSERT INTO [dbo].[tblReferral] ([UserID],[ProjectCode],[Division],[District],[Tehsil],[Department],[SubHeadNameLocation],[ReferralDate],[Apparent_Issue],[Name],[Desgination],[Contact],[Email],[Comments] ,[Attachment])VALUES(@userid,@ProjectCode,@Division,@Distric,@Tehsil,@Department,@SubHeadNameLocation,@SendingDate,@Apparent_Issue,@Name,@Desgination,@Contact,@Email,@Comment,@Attachment);" + "select scope_identity();";
sqlCommand.CommandType = System.Data.CommandType.Text;
sqlCommand.Parameters.AddWithValue("@ProjectCode", Convert.ToInt32(TextBoxProjCode.Text.Trim()));
sqlCommand.Parameters.AddWithValue("@Division", TextBoxDivision.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Distric", DropDownListDistrict.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Tehsil", DropDownListTehsil.Text.Trim());
sqlCommand.Parameters.AddWithValue("@userid", 1223);
sqlCommand.Parameters.AddWithValue("@Department", dep);
sqlCommand.Parameters.AddWithValue("@SubHeadNameLocation", TextBoxSubheadnameLocation.Text.Trim());
sqlCommand.Parameters.AddWithValue("@SendingDate", DateTime.Now.ToShortDateString());
sqlCommand.Parameters.AddWithValue("@Apparent_Issue", TextBoxApprentIssue.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Name", TextBoxName.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Desgination", TextBoxDesgination.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Contact", Convert.ToInt32(TextBoxContactNo.Text.Trim()));
sqlCommand.Parameters.AddWithValue("@Email", TextBoxAssignTo.Text);
sqlCommand.Parameters.AddWithValue("@SubHead", TextBoxSubheadnameLocation.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Comment", TextBoxComments.Text.Trim());
sqlCommand.Parameters.AddWithValue("@Attachment", string.Join("|", images.ToArray()));
var Referralid = sqlCommand.ExecuteScalar();
//sqlCommand.ExecuteNonQuery();
conn.Close();
ReferralID = Referralid.ToString();
}
conn = new SqlConnection(ConnectionString);
conn.Open();
using (var sqlCommand2 = new SqlCommand())
{
sqlCommand2.Connection = conn;
sqlCommand2.CommandText = "INSERT INTO [dbo].[tblReferralNotification] ([UserID],[ReferralID],[Msg])VALUES(110,@referralid,@msg)";
sqlCommand2.CommandType = System.Data.CommandType.Text;
sqlCommand2.Parameters.AddWithValue("@referralid", ReferralID.ToString());
sqlCommand2.Parameters.AddWithValue("@msg", "Project Referral ");
sqlCommand2.ExecuteNonQuery();
}
conn.Close();
toEmail = TextBoxAssignTo.Text;
EmailSubj = "Project Referral Notification";
EmailMsg = "You have new Notication Check your Dashboard";
//passing parameter to Email Method
Email_Without_Attachment(toEmail, EmailSubj, EmailMsg);
Labelnotif.Text = "<body onload=\"showContent()\"></body>";
DropDownListDistrict.SelectedIndex = 0;
TextBoxDivision.Text = "Division";
TextBoxName.Text = "";
TextBoxDesgination.Text = "";
TextBoxContactNo.Text = "";
TextBoxApprentIssue.Text = "";
TextBoxComments.Text = "";
TextBoxSubheadnameLocation.Text = "";
TextBoxAssignTo.Text = "";
//Server.Transfer("ProjectReferralWizard.aspx", false);
}
}