protected void Btn_Update_Click(object sender, EventArgs e) { Btn_Save.Visible = true; Btn_new.Visible = true; string FuCompanySizeFileName, FuCompanySizeFilePath = "", FuIndustryFileName, FuIndustryFilePath = ""; FuCompanySizeFileName = Path.GetFileName(Fu_CompanySize.PostedFile.FileName); if (FuCompanySizeFileName != "") { FuCompanySizeFilePath = "CompanyProfile/" + FuCompanySizeFileName; Fu_CompanySize.SaveAs(Server.MapPath("CompanyProfile/" + CompaignId.ToString() + "_" + FuCompanySizeFileName)); } else { FuCompanySizeFilePath = " "; } FuIndustryFileName = Path.GetFileName(Fu_Industry.PostedFile.FileName); if (FuIndustryFileName != "") { FuIndustryFilePath = "IndustryProfile/" + FuIndustryFileName; Fu_Industry.SaveAs(Server.MapPath("IndustryProfile/" + CompaignId.ToString() + "_" + FuIndustryFileName)); } else { FuIndustryFilePath = " "; } CompaignId = Convert.ToInt32(Tb_CompaignId.Text.ToString()); CompaignName = (Tb_CompaignName.Text.ToString()); CompaignDate = (Dp_CompaignDate.Text.ToString()); JobFunction = (Tb_JobFunction.Text.ToString()); FuCompanySizeFileText = (txt_CompanySize.Text.ToString()); FuIndustryFileNameText = (txt_Industry.Text.ToString()); Country = (Tb_Country.Text.ToString()); CustomeQuestion = (Tb_CustomQuestion.Text.ToString()); con.ConnectionString = str; con.Open(); cmd = new SqlCommand(); //cmd.CommandText = "USP_CompaignDetail"; cmd.CommandText = "USP_CompaignDetailUpdate"; cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompaignId", CompaignId); cmd.Parameters.AddWithValue("@CompaignName", CompaignName); cmd.Parameters.AddWithValue("@CompaignDate", Convert.ToDateTime(CompaignDate)); //cmd.Parameters.AddWithValue("@CompaignDate", DBNull.Value); cmd.Parameters.AddWithValue("@JobFunction", JobFunction); cmd.Parameters.AddWithValue("@CreatedDate", DBNull.Value); cmd.Parameters.AddWithValue("@CreatedBy", DBNull.Value); cmd.Parameters.AddWithValue("@TouchedBy", UserName); cmd.Parameters.AddWithValue("@TouchedWhen", CurrentUtc_IND); cmd.Parameters.AddWithValue("@Country", Country); cmd.Parameters.AddWithValue("@CustomeQuestion", CustomeQuestion); cmd.Parameters.AddWithValue("@FuCompanySizeFileText", FuCompanySizeFileText); cmd.Parameters.AddWithValue("@FuIndustryFileNameText", FuIndustryFileNameText); if (FuCompanySizeFileName != "") { FuCompanySizeFilePath = "CompanyProfile/" + FuCompanySizeFileName; Fu_CompanySize.SaveAs(Server.MapPath("CompanyProfile/" + CompaignId.ToString() + "_" + FuCompanySizeFileName)); cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName); cmd.Parameters.AddWithValue("@FuIndustryFilePath", FuIndustryFilePath); cmd.Parameters.AddWithValue("@FuCompanySizeFileName", FuCompanySizeFileName); cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", FuCompanySizeFilePath); cmd.Parameters.AddWithValue("@selecttype", "update1"); } else if (FuIndustryFileName != "") { FuIndustryFilePath = "IndustryProfile/" + FuIndustryFileName; Fu_Industry.SaveAs(Server.MapPath("IndustryProfile/" + CompaignId.ToString() + "_" + FuIndustryFileName)); cmd.Parameters.AddWithValue("@FuCompanySizeFileName", FuCompanySizeFileName); cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", FuCompanySizeFilePath); cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName); cmd.Parameters.AddWithValue("@FuIndustryFilePath", FuIndustryFilePath); cmd.Parameters.AddWithValue("@selecttype", "update2"); } else if (FuCompanySizeFileName != "" && FuIndustryFileName != "") { cmd.Parameters.AddWithValue("@FuCompanySizeFileName", FuCompanySizeFileName); cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", FuCompanySizeFilePath); cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName); cmd.Parameters.AddWithValue("@FuIndustryFilePath", FuIndustryFilePath); cmd.Parameters.AddWithValue("@selecttype", "update3"); } else { cmd.Parameters.AddWithValue("@FuCompanySizeFileName", FuCompanySizeFileName); cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", FuCompanySizeFilePath); cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName); cmd.Parameters.AddWithValue("@FuIndustryFilePath", FuIndustryFilePath); cmd.Parameters.AddWithValue("@selecttype", "update4"); } //cmd.Parameters.AddWithValue("@selecttype", "update"); cmd.ExecuteNonQuery(); con.Close(); ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('update succesfully'", true); cleardata(); fill_compaign(); }
protected void Btn_Save_Click(object sender, EventArgs e) { int Go = 1; Go = ValidateData(); if (Go == 1) { string folderPath = Server.MapPath("~/IndustryProfile1"); //Check whether Directory (Folder) exists. if (!Directory.Exists("~/IndustryProfile1")) { //If Directory (Folder) does not exists. Create it. Directory.CreateDirectory("folderPath"); // Directory.CreateDirectory("~/IndustryProfile1"); } //Save the File to the Directory (Folder). Fu_Industry.SaveAs(folderPath + Path.GetFileName(Fu_Industry.FileName)); //Display the success message. lblMessage.Text = Path.GetFileName(Fu_Industry.FileName) + " has been uploaded."; Btn_Update.Visible = true; Btn_view.Visible = true; string FuCompanySizeFileName, FuCompanySizeFilePath = "", FuIndustryFileName, FuIndustryFilePath = ""; FuIndustryFileName = Path.GetFileName(Fu_Industry.PostedFile.FileName); if (FuIndustryFileName != "") { FuIndustryFilePath = "IndustryProfile/" + CompaignId.ToString() + "_" + FuIndustryFileName; // FuIndustryFilePath = "IndustryProfile/" + FuIndustryFileName; Fu_Industry.SaveAs(Server.MapPath("IndustryProfile/" + CompaignId.ToString() + "_" + FuIndustryFileName)); } else { FuCompanySizeFilePath = " "; } //if (Fu_CompanySize.HasFile == true) //{ FuCompanySizeFileName = Path.GetFileName(Fu_CompanySize.PostedFile.FileName); //} if (FuCompanySizeFileName != "") { // File_Path = "CompaignProfile/" + CompaignId.ToString() + "_" + File_Name; FuCompanySizeFilePath = "CompanyProfile/" + FuCompanySizeFileName; Fu_CompanySize.SaveAs(Server.MapPath("CompanyProfile/" + CompaignId.ToString() + "_" + FuCompanySizeFileName)); } else { FuCompanySizeFilePath = " "; } ClientId = (Tb_ClientId.Text.ToString()); ClientStatus_Id = Convert.ToInt32(DD_EmployeeStatus.SelectedValue.ToString()); CompaignId = Convert.ToInt32(Tb_CompaignId.Text.ToString()); CompaignName = (Tb_CompaignName.Text.ToString()); CompaignDate = (Dp_CompaignDate.Text.ToString()); JobFunction = (Tb_JobFunction.Text.ToString()); FuCompanySizeFileText = (txt_CompanySize.Text.ToString()); FuIndustryFileNameText = (txt_Industry.Text.ToString()); Country = (Tb_Country.Text.ToString()); CustomeQuestion = (Tb_CustomQuestion.Text.ToString()); cmd.Parameters.Clear(); con.ConnectionString = str; con.Open(); cmd = new SqlCommand(); cmd.CommandText = "USP_CompaignDetail"; cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompaignId", CompaignId); cmd.Parameters.AddWithValue("@CompaignName", CompaignName); cmd.Parameters.AddWithValue("@CompaignDate", Convert.ToDateTime(CompaignDate)); cmd.Parameters.AddWithValue("@JobFunction", JobFunction); cmd.Parameters.AddWithValue("@ClientId", ClientId); cmd.Parameters.AddWithValue("@ClientStatus", ClientStatus_Id); cmd.Parameters.AddWithValue("@Country", Country); cmd.Parameters.AddWithValue("@CustomeQuestion", CustomeQuestion); cmd.Parameters.AddWithValue("@CreatedDate", CurrentUtc_IND); cmd.Parameters.AddWithValue("@CreatedBy", UserName); cmd.Parameters.AddWithValue("@TouchedWhen", DBNull.Value); cmd.Parameters.AddWithValue("@TouchedBy", DBNull.Value); cmd.Parameters.AddWithValue("@FuCompanySizeFileText", FuCompanySizeFileText); cmd.Parameters.AddWithValue("@FuIndustryFileNameText", FuIndustryFileNameText); if (FuCompanySizeFileName != null) { cmd.Parameters.AddWithValue("@FuCompanySizeFileName", FuCompanySizeFileName); cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", FuCompanySizeFilePath); //cmd.Parameters.AddWithValue("@Companysize", Companysize); //cmd.Parameters.AddWithValue("@Industry", Industry); } else { string FuCompanySizeFileName1 = null; string FuCompanySizeFilePath1 = null; cmd.Parameters.AddWithValue("@FuCompanySizeFileName", FuCompanySizeFileName1); cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", FuCompanySizeFilePath1); } if (FuIndustryFileName != null) { cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName); cmd.Parameters.AddWithValue("@FuIndustryFilePath", FuIndustryFilePath); //cmd.Parameters.AddWithValue("@Companysize", Companysize); //cmd.Parameters.AddWithValue("@Industry", Industry); } else { string FuIndustryFileName1 = null; string FuIndustryFilePath1 = null; cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName1); cmd.Parameters.AddWithValue("@FuIndustryFilePath", FuIndustryFilePath1); } //cmd.Parameters.AddWithValue("@FuIndustryFileName ", FuIndustryFileName); cmd.Parameters.AddWithValue("@selecttype", "insert"); cmd.ExecuteNonQuery(); con.Close(); ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('save succesfully'", true); cleardata(); fill_compaign(); // string File_Name = "", File_Path = ""; // if (Fu_CompanySize.HasFile == true) // { // File_Name = Path.GetFileName(Fu_CompanySize.PostedFile.FileName); // } // if (File_Name != "") // { // File_Path = "CompaignProfile/" + CompaignId.ToString() + "_" + File_Name; // Fu_CompanySize.SaveAs(Server.MapPath("CompaignProfile/" + CompaignId.ToString() + "_" + File_Name)); // cmd.Parameters.AddWithValue("@FuCompanySizeFileName", File_Name); // cmd.Parameters.AddWithValue("@FuCompanySizeFilePath", File_Path); // } //else //{ // File_Path = ""; //} //string File_Name1 = "", File_Path1 = ""; // if (Fu_Industry.HasFile == true) // { // File_Name1 = Path.GetFileName(Fu_Industry.PostedFile.File_Name1); // } // if (File_Name1 != "") // { // File_Path1 = "CompaignProfile/" + CompaignId.ToString() + "_" + File_Name1; // Fu_Industry.SaveAs(Server.MapPath("CompaignProfile/" + CompaignId.ToString() + "_" + File_Name1)); // cmd.Parameters.AddWithValue("@FuIndustryFileName ", File_Name1); // cmd.Parameters.AddWithValue("@FuIndustryFilePath", File_Path1); // } // else // { // File_Path1 = ""; // } } }