//public static PhoneFollowUp GetPhoneFollowUp(int SaMIProfileID) //{ // PhoneFollowUp objPhoneFollowUp = new PhoneFollowUp(); // return (PhoneFollowUp)(new PhoneFollowUpDAO().FillDTO(objPhoneFollowUp, "SaMIProfileID=" + SaMIProfileID)); //} public int InsertPhoneFollowUp(PhoneFollowUp objPhonefollowup) { objPhonefollowup.PhoneFollowUpID = 1; BeginTransaction(); try { objPhonefollowup.PhoneFollowUpID = Insert(objPhonefollowup); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objPhonefollowup.PhoneFollowUpID = -1; } return objPhonefollowup.PhoneFollowUpID; }
public int DeletePhoneFollowUp(PhoneFollowUp objPhonefollowup) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "Status" }; rowsaffected = Update(objPhonefollowup, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public int UpdatePhoneFollowUp(PhoneFollowUp objPhonefollowup) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "LeftForFE", "VisitorsCurrentStatus", "VisitorsOtherStatus", "ContractNumber", "MigratedCountry", "MigratedDate", "MigratedAfterTraining", "ManpowerAgent", "AmountPaidforFE", "SourceOfInvestment", "ReceiptReceived", "LeftDocumentBeforeDeparture", "SameWorkAsAgreement", "SameSalaryAsAgreement", "AdditionalInfo", "Recommendation", "InformantsName", "MigrantRelation", "FollowUpDate", "Remarks", "UpdatedBy", "UpdatedDate", "Status" }; rowsaffected = Update(objPhonefollowup, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
protected void gvPhoneFollowUp_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("cmdEdit")) { hfPhoneFollowUpID.Value = e.CommandArgument.ToString(); //PhoneFollowUp objPhoneFollowUp = PhoneFollowUpBO.GetPhoneFollowUp(Convert.ToInt32(e.CommandArgument.ToString())); LoadPhoneFollowUp(Convert.ToInt32(hfPhoneFollowUpID.Value)); //ScriptManager.RegisterStartupScript(this, this.GetType(), "myalert", "alert('File already exists.');", true); //Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "abc()", true); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "Func()", true); } else if (e.CommandName.Equals("cmdDelete")) { hfPhoneFollowUpID.Value = e.CommandArgument.ToString(); PhoneFollowUp objPhoneFollowUp = new PhoneFollowUp(); objPhoneFollowUp.PhoneFollowUpID = Convert.ToInt32(e.CommandArgument.ToString()); objPhoneFollowUp.Status = 0; objPhoneFollowUp.SyncStatus = 0; PhoneFollowUpBO.DeletePhoneFollowUp(objPhoneFollowUp); LoadPhoneFollowUpList(Convert.ToInt32(hfSaMIProfileID.Value)); ClearPhoneFollowUpList(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "Func()", true); } }
protected void btnSavePhoneFollowUp_Click(object sender, EventArgs e) { String sourceofInvestment = string.Empty; //DataView dvPhoneFollowUp = PhoneFollowUpBO.GetBySaMIProfileID(Convert.ToInt32(Request.QueryString.Get("ID"))); //if (dvPhoneFollowUp.Count > 0) //{ // ID = Convert.ToInt32(dvPhoneFollowUp.Table.Rows[0]["PhoneFollowUpID"]); //} PhoneFollowUp objPhoneFollowUp = new PhoneFollowUp(); int SaMIProfileId = Convert.ToInt32(hfSaMIProfileID.Value); objPhoneFollowUp.SaMIProfileID = SaMIProfileId; if (rbtnLeftFEYes.Checked) { objPhoneFollowUp.LeftForFE = 1; objPhoneFollowUp.ContractNumber = txtContractNumber.Text; objPhoneFollowUp.MigratedCountry = txtMigratedCountry.Text; objPhoneFollowUp.MigratedDate = txtMigratedDate.Text; if (rbtnMigratedAfterTrainingYes.Checked) { objPhoneFollowUp.MigratedAfterTraining = 1; } else if (rbtnMigratedAfterTrainingNo.Checked) { objPhoneFollowUp.MigratedAfterTraining = 0; } objPhoneFollowUp.ManpowerAgent = txtManpowerAgent.Text; objPhoneFollowUp.AmountPaidforFE = txtAmountPaidforFE.Text; for (int j = 0; j < chkSourceOfInvestment.Items.Count; j++) { if (chkSourceOfInvestment.Items[j].Selected == true) { if (j == 0) sourceofInvestment = chkSourceOfInvestment.Items[j].Value; else sourceofInvestment = sourceofInvestment + "," + chkSourceOfInvestment.Items[j].Value; } } objPhoneFollowUp.SourceOfInvestment = sourceofInvestment; if (rbtnReceiptFromManpowerYes.Checked) objPhoneFollowUp.ReceiptReceived = 1; else if (rbtnReceiptFromManpowerNo.Checked) objPhoneFollowUp.ReceiptReceived = 0; if (rbtnLeftDocumentYes.Checked) objPhoneFollowUp.LeftDocumentBeforeDeparture = 1; else if (rbtnLeftDocumentNo.Checked) objPhoneFollowUp.LeftDocumentBeforeDeparture = 0; if (rbtnWorkAggreementYes.Checked) objPhoneFollowUp.SameWorkAsAgreement = 1; else if (rbtnWorkAggreementNo.Checked) objPhoneFollowUp.SameWorkAsAgreement = 0; if (rbtnSalaryAgreementYes.Checked) objPhoneFollowUp.SameSalaryAsAgreement = 1; else if (rbtnSalaryAgreementNo.Checked) objPhoneFollowUp.SameSalaryAsAgreement = 0; } else if (rbtnLeftFENo.Checked) { objPhoneFollowUp.LeftForFE = 0; objPhoneFollowUp.VisitorsCurrentStatus = ddlCurrentStatus.Text; objPhoneFollowUp.VisitorsOtherStatus = txtCurrentStatus.Text; } objPhoneFollowUp.AdditionalInfo = txtAdditionalInfo.Text; objPhoneFollowUp.Recommendation = txtRecommendations.Text; objPhoneFollowUp.InformantsName = txtNameOfInformants.Text; objPhoneFollowUp.MigrantRelation = txtRelationMigrant.Text; objPhoneFollowUp.FollowUpDate = txtDateOfFollowUp.Text; objPhoneFollowUp.Remarks = txtRemarks.Text; objPhoneFollowUp.Status = 1; objPhoneFollowUp.GUID = 0; objPhoneFollowUp.SyncStatus = 0; if (hfPhoneFollowUpID.Value != string.Empty) { objPhoneFollowUp.PhoneFollowUpID = Convert.ToInt32(hfPhoneFollowUpID.Value); objPhoneFollowUp.UpdatedBy = UserAuthentication.GetUserId(this.Page); objPhoneFollowUp.UpdatedDate = DateTime.Now; PhonefollowupId = PhoneFollowUpBO.UpdatePhoneFollowUp(objPhoneFollowUp); } else { objPhoneFollowUp.CreatedBy = UserAuthentication.GetUserId(this.Page); objPhoneFollowUp.CreatedDate = DateTime.Now; PhonefollowupId = PhoneFollowUpBO.InsertPhoneFollowUp(objPhoneFollowUp); } if (PhonefollowupId > 0) { hfPhoneFollowUpID.Value = PhonefollowupId.ToString(); LoadPhoneFollowUpList(SaMIProfileId); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "Func()", true); ClearPhoneFollowUpList(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "Func()", true); } }