protected void rptrClientDetails_ItemCommand(object source, RepeaterCommandEventArgs e)
{
LinkButton lnkUpdate = (LinkButton)e.Item.FindControl("lnkUpdate");
LinkButton lnkCancel = (LinkButton)e.Item.FindControl("lnkCancel");
LinkButton lnkEdit = (LinkButton)e.Item.FindControl("lnkEdit");
LinkButton lnkDelete = (LinkButton)e.Item.FindControl("lnkDelete");
DropDownList ddlClientName = (DropDownList)e.Item.FindControl("ddlClientName");
TextBox txtClientProfile = (TextBox)e.Item.FindControl("txtClientProfile");
TextBox txtPosition = (TextBox)e.Item.FindControl("txtPosition");
DropDownList ddlIndustry = (DropDownList)e.Item.FindControl("ddlIndustry");
DropDownList ddlFunctionalArea = (DropDownList)e.Item.FindControl("ddlFunctionalArea");
TextBox txtAddress = (TextBox)e.Item.FindControl("txtAddress");
DropDownList ddlCountry = (DropDownList)e.Item.FindControl("ddlCountry");
DropDownList ddlState = (DropDownList)e.Item.FindControl("ddlState");
DropDownList ddlCity = (DropDownList)e.Item.FindControl("ddlCity");
DropDownList ddlArea = (DropDownList)e.Item.FindControl("ddlArea");
TextBox txtPincode = (TextBox)e.Item.FindControl("txtPincode");
TextBox txtSkillsets = (TextBox)e.Item.FindControl("txtSkillsets");
TextBox txtContents = (TextBox)e.Item.FindControl("txtContents");
TextBox txtDateofRequirementSent = (TextBox)e.Item.FindControl("txtDateofRequirementSent");
TextBox txtDueDate = (TextBox)e.Item.FindControl("txtDueDate");
RadioButtonList rbtlistStatus = (RadioButtonList)e.Item.FindControl("rbtlistStatus");
DropDownList ddlRecruiter = (DropDownList)e.Item.FindControl("ddlRecruiter");
Label lblClientName = (Label)e.Item.FindControl("lblClientName");
Label lblClientProfile = (Label)e.Item.FindControl("lblClientProfile");
Label lblPosition = (Label)e.Item.FindControl("lblPosition");
Label lblIndustry = (Label)e.Item.FindControl("lblIndustry");
Label lblFunctionalArea = (Label)e.Item.FindControl("lblFunctionalArea");
Label lblAddress = (Label)e.Item.FindControl("lblAddress");
Label lblCountry = (Label)e.Item.FindControl("lblCountry");
Label lblState = (Label)e.Item.FindControl("lblState");
Label lblCity = (Label)e.Item.FindControl("lblCity");
Label lblArea = (Label)e.Item.FindControl("lblArea");
Label lblPincode = (Label)e.Item.FindControl("lblPincode");
Label lblSkillsets = (Label)e.Item.FindControl("lblSkillsets");
Label lblContents = (Label)e.Item.FindControl("lblContents");
Label lblDateofRequirementSent = (Label)e.Item.FindControl("lblDateofRequirementSent");
Label lblDueDate = (Label)e.Item.FindControl("lblDueDate");
Label lblStatus = (Label)e.Item.FindControl("lblStatus");
Label lblRecruiter = (Label)e.Item.FindControl("lblRecruiter");
// Check commond for edit
if (e.CommandName == "edit")
{
BindRecruiter(HrId);
lnkCancel.Visible = true;
lnkUpdate.Visible = true;
lnkEdit.Visible = false;
txtClientName.Visible = true;
txtClientProfile.Visible = true;
txtPosition.Visible = true;
ddlIndustry.Visible = true;
ddlFunctionalArea.Visible = true;
txtAddress.Visible = true;
ddlCountry.Visible = true;
ddlState.Visible = true;
ddlCity.Visible = true;
ddlArea.Visible = true;
txtPincode.Visible = true;
txtSkillsets.Visible = true;
txtContents.Visible = true;
txtDateofRequirementSent.Visible = true;
txtDueDate.Visible = true;
rbtlistStatus.Visible = true;
ddlRecruiter.Visible = true;
pnlRecruiter.Visible = true;
lblClientName.Visible = false;
lblClientProfile.Visible = false;
lblPosition.Visible = false;
lblIndustry.Visible = false;
lblFunctionalArea.Visible = false;
lblAddress.Visible = false;
lblCountry.Visible = false;
lblState.Visible = false;
lblCity.Visible = false;
lblArea.Visible = false;
lblPincode.Visible = false;
lblSkillsets.Visible = false;
lblContents.Visible = false;
lblDateofRequirementSent.Visible = false;
lblDueDate.Visible = false;
lblStatus.Visible = false;
lblRecruiter.Visible = false;
pnlRecruiter.Visible = false;
}
// Check commond for update
if (e.CommandName == "cancel")
{
BindViewClientRequirements();
}
// Check commond for update
if (e.CommandName == "update")
{
try
{
ClientRequirementsHRBAL clientRequirementsHRBAL = new ClientRequirementsHRBAL();
ClientRequirementsHREntity clientRequirementsHREntity = new ClientRequirementsHREntity();
// Assign values to the entities
clientRequirementsHREntity.HrId = 1;
clientRequirementsHREntity.ClientId = Convert.ToInt32(txtClientId.Text.Trim()); ;
clientRequirementsHREntity.ClientName = txtClientName.Text.Trim();
clientRequirementsHREntity.ClientProfile = txtClientProfile.Text.Trim();
clientRequirementsHREntity.Position = txtPosition.Text.Trim();
clientRequirementsHREntity.Industry = Convert.ToInt32(ddlIndustry.SelectedValue);
clientRequirementsHREntity.FunctionalArea = Convert.ToInt32(ddlFunctionalArea.SelectedValue);
clientRequirementsHREntity.Address = txtAddress.Text.Trim();
clientRequirementsHREntity.CountryId = Convert.ToInt32(ddlCountry.SelectedValue);
clientRequirementsHREntity.StateId = Convert.ToInt32(ddlState.SelectedValue);
clientRequirementsHREntity.CityId = Convert.ToInt32(ddlCity.SelectedValue);
clientRequirementsHREntity.AreaId = Convert.ToInt32(ddlArea.SelectedValue);
clientRequirementsHREntity.Pincode = Convert.ToInt32(txtPincode.Text.Trim());
clientRequirementsHREntity.Skillsets = txtSkillsets.Text.Trim();
clientRequirementsHREntity.Contents = txtContents.Text.Trim();
clientRequirementsHREntity.DateOfRequirementSent = Convert.ToDateTime(txtDateofRequirementSent.Text);
clientRequirementsHREntity.DueDate = Convert.ToDateTime(txtDueDate.Text);
clientRequirementsHREntity.Status = rbtlistStatus.SelectedItem.Text.Trim();
clientRequirementsHREntity.RecruiterID = Convert.ToInt32(ddlRecruiter.SelectedValue);
// Saving data to the database
int result = clientRequirementsHRBAL.UpdateClientRequirementsBAL(clientRequirementsHREntity);
if (result > 0)
{
Response.Write("<script language='javascript'>alert('Update Client Requirement Successfully')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Client Requirement won't Updated')</script>");
}
}
catch (Exception)
{
//throw;
}
BindViewClientRequirements();
}
// Check commond for delete
if (e.CommandName == "delete")
{
try
{
//ClientRequirementsHRBAL clientRequirementsHRBAL = new ClientRequirementsHRBAL();
//int ClientRequirementId = Convert.ToInt32(e.CommandArgument);
//clientRequirementsHRBAL.DeleteclientRequirementsBAL(ClientRequirementId);
}
catch (Exception)
{
// throw;
}
BindViewClientRequirements();
}
}
/// <summary>
/// Method of class ClientRequirementsHRDAL for saving ClientRequirements in database
/// </summary>
/// <param name="clientrequirementsHREntity">Object of ClientRequirementsHREntity</param>
/// <returns>System.Int32</returns>
public int SaveClientRequirementsDAL(ClientRequirementsHREntity clientRequirementsHREntity)
{
try
{
connection.Open();
//Add parameter for stored procedure
SqlParameter[] sparam = { new SqlParameter("@hrid", clientRequirementsHREntity.HrId),
new SqlParameter("@clientId", clientRequirementsHREntity.ClientId),
new SqlParameter("@clientName", clientRequirementsHREntity.ClientName),
new SqlParameter("@clientProfile", clientRequirementsHREntity.ClientProfile),
new SqlParameter("@position", clientRequirementsHREntity.Position),
new SqlParameter("@industry", clientRequirementsHREntity.Industry),
new SqlParameter("@functuionalarea", clientRequirementsHREntity.FunctionalArea),
new SqlParameter("@address", clientRequirementsHREntity.Address),
new SqlParameter("@countryId", clientRequirementsHREntity.CountryId),
new SqlParameter("@stateId", clientRequirementsHREntity.StateId),
new SqlParameter("@cityId", clientRequirementsHREntity.CityId),
new SqlParameter("@areaId", clientRequirementsHREntity.AreaId),
new SqlParameter("@pincode", clientRequirementsHREntity.Pincode),
new SqlParameter("@skillsets", clientRequirementsHREntity.Skillsets),
new SqlParameter("@contents", clientRequirementsHREntity.Contents),
new SqlParameter("@dateOfRequirementSent", clientRequirementsHREntity.DateOfRequirementSent.Date),
new SqlParameter("@dueDate", clientRequirementsHREntity.DueDate.Date),
new SqlParameter("@status", clientRequirementsHREntity.Status),
new SqlParameter("@recruiterID", clientRequirementsHREntity.RecruiterID),
};
int result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_HR_InsertClientRequirements, sparam);
return result;
}
catch (System.Exception)
{
throw;
}
finally
{
connection.Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
ClientRequirementsHRBAL clientRequirementsHRBAL = new ClientRequirementsHRBAL();
ClientRequirementsHREntity clientRequirementsHREntity = new ClientRequirementsHREntity();
// Assign values to the entities
clientRequirementsHREntity.HrId = 1;
clientRequirementsHREntity.ClientId = Convert.ToInt32(txtClientId.Text.Trim()); ;
clientRequirementsHREntity.ClientName = txtClientName.Text.Trim();
clientRequirementsHREntity.ClientProfile = txtClientProfile.Text.Trim();
clientRequirementsHREntity.Position = txtPosition.Text.Trim();
clientRequirementsHREntity.Industry = Convert.ToInt32(ddlIndustry.SelectedValue);
clientRequirementsHREntity.FunctionalArea = Convert.ToInt32(ddlFunctionalArea.SelectedValue);
clientRequirementsHREntity.Address = txtAddress.Text.Trim();
clientRequirementsHREntity.CountryId = Convert.ToInt32(ddlCountry.SelectedValue);
clientRequirementsHREntity.StateId = Convert.ToInt32(ddlState.SelectedValue);
clientRequirementsHREntity.CityId = Convert.ToInt32(ddlCity.SelectedValue);
clientRequirementsHREntity.AreaId = Convert.ToInt32(ddlArea.SelectedValue);
clientRequirementsHREntity.Pincode = Convert.ToInt32(txtPincode.Text.Trim());
clientRequirementsHREntity.Skillsets = txtSkillsets.Text.Trim();
clientRequirementsHREntity.Contents = txtContents.Text.Trim();
clientRequirementsHREntity.DateOfRequirementSent = Convert.ToDateTime(txtDateofRequirementSent.Text);
clientRequirementsHREntity.DueDate = Convert.ToDateTime(txtDueDate.Text);
clientRequirementsHREntity.Status = rbtlistStatus.SelectedItem.Text.Trim();
clientRequirementsHREntity.RecruiterID = Convert.ToInt32(ddlRecruiter.SelectedValue);
// Saving data to the database
int result = clientRequirementsHRBAL.SaveClientRequirementsBAL(clientRequirementsHREntity);
if (result > 0)
{
try
{
string strBody = "", ClientName, ClientProfile, Position, IndustryName, FunctionalAreaName, Address,
CountryName, StateName, CityName, AreaName, Skillsets, Contents, Status, RecruiterName;
int ClientId,Pincode;
DateTime DateOfRequirementSent, DueDate;
ClientId = Convert.ToInt32(txtClientId.Text.Trim());
ClientName = txtClientName.Text.Trim();
ClientProfile = txtClientProfile.Text.Trim();
Position = txtPosition.Text.Trim();
IndustryName = ddlIndustry.SelectedItem.Text.Trim();
FunctionalAreaName = ddlFunctionalArea.SelectedItem.Text.Trim();
Address = txtAddress.Text.Trim();
CountryName = ddlCountry.SelectedItem.Text.Trim();
StateName = ddlState.SelectedItem.Text.Trim();
CityName = ddlCity.SelectedItem.Text.Trim();
AreaName = ddlArea.SelectedItem.Text.Trim();
Pincode = Convert.ToInt32(txtPincode.Text.Trim());
Skillsets = txtSkillsets.Text.Trim();
Contents = txtContents.Text.Trim();
DateOfRequirementSent = Convert.ToDateTime(txtDateofRequirementSent.Text);
DueDate = Convert.ToDateTime(txtDueDate.Text);
Status = rbtlistStatus.SelectedItem.Text;
RecruiterName = ddlRecruiter.SelectedItem.Text.Trim();
MailMessage msg = new MailMessage();
msg.From = new MailAddress("*****@*****.**");
DataSet dsSelectClientRequirementsForwardMail = new DataSet();
HrId = 1;
ClientId = Convert.ToInt32(txtClientId.Text.Trim()); ;
string EmailIdJoin = null, EmailId, toemail;
dsSelectClientRequirementsForwardMail = clientRequirementsHRBAL.SelectClientRequirementsForwardMailBAL(HrId, ClientId);
foreach (DataTable table in dsSelectClientRequirementsForwardMail.Tables)
{
foreach (DataRow dr in table.Rows)
{
EmailId = Convert.ToString(dr["EmailId"]); ;
if (EmailIdJoin == null)
{
EmailIdJoin = string.Concat(EmailId + ",");
}
else
EmailIdJoin = string.Concat(EmailIdJoin + EmailId + ",");
}
}
string[] Multi = EmailIdJoin.Split(','); //spiliting input Email id string with comma(,)
foreach (string Multiemailid in Multi)
{
if (Multiemailid != "")
{
msg.To.Add(new MailAddress(Multiemailid)); //adding multi reciver's Email Id
}
else
break;
}
//msg.To.Add("*****@*****.**");
//msg.To.Add("*****@*****.**");
msg.Subject = "Client Requirements";
// Check if selected value equal to Other Help
strBody = "<html><body><table><tr><td>Client Id </td><td>:</td><td>" + ClientId + "</td></tr> " +
" <tr><td>Client Name </td><td>:</td><td>" + ClientName + "</td></tr> " +
" <tr><td>Client Profile </td><td>:</td><td>" + ClientProfile + "</td></tr> " +
" <tr><td>Position</td><td>:</td><td>" + Position + "</td></tr> " +
" <tr><td>Industry Name</td><td>:</td><td>" + IndustryName + "</td></tr> " +
" <tr><td>Functional Area Name</td><td>:</td><td>" + FunctionalAreaName + "</td></tr> " +
" <tr><td>Address </td><td>:</td><td>" + Address + "</td></tr><br /> " +
" <tr><td>Country Name</td><td>:</td><td>" + CountryName + "</td></tr><br /> " +
" <tr><td>State Name</td><td>:</td><td>" + StateName + "</td></tr><br /> " +
" <tr><td>City Name </td><td>:</td><td>" + CityName + "</td></tr><br /> " +
" <tr><td>Area Name</td><td>:</td><td>" + AreaName + "</td></tr><br /> " +
" <tr><td>Pincode</td><td>:</td><td>" + Pincode + "</td></tr> " +
" <tr><td>Skillsets</td><td>:</td><td>" + Skillsets + "</td></tr> " +
" <tr><td>Contents</td><td>:</td><td>" + Contents + "</td></tr><br /> " +
" <tr><td>Date Of Requirement Sent</td><td>:</td><td>" + DateOfRequirementSent + "</td></tr><br /> " +
" <tr><td>Due Date</td><td>:</td><td>" + DueDate + "</td></tr><br /> " +
" <tr><td>Status</td><td>:</td><td>" + Status + "</td></tr><br /> " +
" <tr><td>RecruiterName</td><td>:</td><td>" + RecruiterName + "</td></tr><br /> " +
" </table> </body></html>";
msg.Body = strBody;
msg.IsBodyHtml = true;
//"Name :" + name + "\nEmail ID :" + emailId + "\nMobile Number :" + mobileNo + "\nAlternate Mobile Number :" + alternateMobile + "\nTotal Experience :" + totalExperience + "\nPosition Looking for :" + positionLooking + "\nRelevant Experience in the position applied :" + RelevantExpPositionApplied + "\nRelevant Experience in the Mobile Domain :" + RelevantExpMobileDomain + "\nDo you have experience in mobile domain (Android and iPhone) :" + mobileDomain + "\nCurrent / last Employer :" + currentEmployer + "\nWork Tenure :" + workTenture + "\nCurrent Designation :" + currentDesignation + "\nCurrent location :" + currentLocation + "\nCurrent Salary :" + currentSalary + "\nExpected Salary :" + exceptedSalary + "\nNotice Period :" + noticePeriod + "\nSize of organization are you looking for ?" + companyType + "\nReason for the job change :" + reason + "Can you attend face to face interview in weekdays :" + interview + "\nAvailability for the personal interview in Week Days (Monday to Friday) :" + beforeTime + " " + afterTime + "\nPreferable City for Job :" + preferedCity + "\nPreferable areas in the City :" + preferedArea;
//if (resumeUpload.HasFile)
//{
// string FileName = Path.GetFileName(resumeUpload.PostedFile.FileName);
// msg.Attachments.Add(new Attachment(resumeUpload.PostedFile.InputStream, FileName));
//}
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "logos@gmail");
smtp.EnableSsl = true;
smtp.Send(msg);
msg = null;
}
catch (Exception)
{
//throw;
}
Response.Write("<script language='javascript'>alert('Client Requirement Successfully Mailed...');</script>");
Response.Write("<script language='javascript'>alert('Saved Client Requirement Successfully')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Client Requirement won't saved')</script>");
}
}
catch (Exception)
{
//throw;
}
}
/// <summary>
/// Update Client Requirement Details
/// </summary>
/// <param name="clientRequirementsHREntity">ClientRequirementsHREntity</param>
/// <returns>system.Int32</returns>
public int UpdateClientRequirementsBAL(ClientRequirementsHREntity clientRequirementsHREntity)
{
ClientRequirementsHRDAL clientRequirementsHRDAL = new ClientRequirementsHRDAL();
return clientRequirementsHRDAL.UpdateClientRequirementsDAL(clientRequirementsHREntity);
}
