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 = "";
// }
}
}
