void LoadForm()
{
try
{
this.Header1.TaskId = dalBPM.TaskID;
SAP_VendorCreation obj = db.SAP_VendorCreation.Find(dalBPM.RecordID);
hidRecordID.Value = obj.RequestId;
txtIBAN.Text = obj.AccountNoIBAN;
txtAddress.Text = obj.Address;
txtBankAddress.Text = obj.BankAddress;
txtCountry.Text = obj.Country;
txtPostalCode.Text = obj.PostalCode;
txtCity.Text = obj.City;
txtBenificaryName.Text = obj.BenificaryName;
txtBusinessName.Text = obj.BusinessName;
Common.SelectItemByValue(rblClassification, string.IsNullOrEmpty(obj.Classification) ? string.Empty : obj.Classification);
Common.SelectItemByValue(rblType, string.IsNullOrEmpty(obj.CompanyType) ? string.Empty : obj.CompanyType);
txtContactPerson.Text = obj.ContactPerson;
txtEmail.Text = obj.Email;
txtFaxNo.Text = obj.FaxNo;
Common.SelectItemByValue(rblNaturOfWork, string.IsNullOrEmpty(obj.NatureOfWork) ? string.Empty : obj.NatureOfWork);
txtNTN.Text = obj.NTNNo;
txtCurrency.Text = obj.PaymentCurrency;
Common.SelectItemByValue(rblPaymentMethod, string.IsNullOrEmpty(obj.PaymentMethod) ? string.Empty : obj.PaymentMethod);
txtPaymentTerms.Text = obj.PaymentTerms;
txtPeriod.Text = obj.PeriodUpto;
txtContactNo.Text = obj.PhoneNo;
Common.SelectItemByValue(rblQualification, string.IsNullOrEmpty(obj.Qualification) ? string.Empty : obj.Qualification);
if (obj.QuestionnaireCompleted.GetValueOrDefault())
{
rblAttached.SelectedValue = "Yes";
}
else
{
rblAttached.SelectedValue = "No";
}
txtNA.Checked = obj.RegNA.GetValueOrDefault();
Common.SelectItemByValue(rblOptions, string.IsNullOrEmpty(obj.RequestType) ? string.Empty : obj.RequestType);
txtReason.Text = obj.Reason;
txtRoutingNo.Text = obj.RoutingNo;
txtState.Text = obj.State;
txtSwiftCode.Text = obj.SwiftCode;
txtSaleTaxReg.Text = obj.TaxRegNo;
hidUserID.Value = obj.UserId;
txtWHoldingTax.Text = obj.WithholdingTax;
txtVendorID.Text = obj.SAPVendorId;
txtIssedBy.Text = obj.IssuedBy;
if (!obj.IssuedOn.HasValue)
{
txtIssuedOn.Text = obj.IssuedOn.Value.ToString("dd-MMM-yyyy");
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
void LoadForm(SAP_VendorCreation obj)
{
try
{
hidRecordID.Value = obj.RequestId;
txtIBAN.Text = obj.AccountNoIBAN;
txtAddress.Text = obj.Address;
txtBankAddress.Text = obj.BankAddress;
Common.SelectItemByText(ddlCountry, string.IsNullOrEmpty(obj.Country)?string.Empty:obj.Country);
txtPostalCode.Text = obj.PostalCode;
txtCity.Text = obj.City;
txtBenificaryName.Text = obj.BenificaryName;
txtBusinessName.Text = obj.BusinessName;
Common.SelectItemByValue(rblClassification, string.IsNullOrEmpty(obj.Classification) ? string.Empty : obj.Classification);
Common.SelectItemByValue(rblType, string.IsNullOrEmpty(obj.CompanyType) ? string.Empty : obj.CompanyType);
txtContactPerson.Text = obj.ContactPerson;
txtEmail.Text = obj.Email;
txtFaxNo.Text = obj.FaxNo;
Common.SelectItemByValue(rblNaturOfWork, string.IsNullOrEmpty(obj.NatureOfWork) ? string.Empty : obj.NatureOfWork);
txtNTN.Text = obj.NTNNo;
Common.SelectItemByText(ddlCurrency, string.IsNullOrEmpty(obj.PaymentCurrency) ? string.Empty : obj.PaymentCurrency);
Common.SelectItemByValue(rblPaymentMethod, string.IsNullOrEmpty(obj.PaymentMethod) ? string.Empty : obj.PaymentMethod);
Common.SelectItemByText(ddlPaymentTerms, string.IsNullOrEmpty(obj.PaymentTerms) ? string.Empty : obj.PaymentTerms);
txtPeriod.Text = obj.PeriodUpto;
txtContactNo.Text = obj.PhoneNo;
Common.SelectItemByValue(rblQualification, string.IsNullOrEmpty(obj.Qualification) ? string.Empty : obj.Qualification);
if (obj.QuestionnaireCompleted.GetValueOrDefault())
{
rblAttached.SelectedValue = "Yes";
}
else
{
rblAttached.SelectedValue = "No";
}
txtNA.Checked = obj.RegNA.GetValueOrDefault();
Common.SelectItemByValue(rblOptions, string.IsNullOrEmpty(obj.RequestType) ? string.Empty : obj.RequestType);
txtReason.Text = obj.Reason;
txtRoutingNo.Text = obj.RoutingNo;
txtState.Text = obj.State;
txtSwiftCode.Text = obj.SwiftCode;
txtSaleTaxReg.Text = obj.TaxRegNo;
Common.SelectItemByText(ddlWitholdingTaxField, string.IsNullOrEmpty(obj.WithholdingTax) ? string.Empty : obj.WithholdingTax);
// txtVendorID.Text = obj.SAPVendorId;
// lblEmail.Text = obj.Email_Sent.Equals("1") ? "Yes" : "No";
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btSubmit_Click(object sender, EventArgs e)
{
try
{
SAP_VendorCreation obj = db.SAP_VendorCreation.Find(hidRecordID.Value);
string AppStatus = "", _Action = "";
AppStatus = "1";
_Action = "Closed";
dalBPM.SetVarValue("AppStatus", AppStatus);
int IncidentNo = dalBPM.SubmitTask(_Action, txtRemarks.Content);
if (IncidentNo > 0)
{
obj.UpdatedDate = DateTime.Now;
obj.Status = 3;
obj.IncidentNo = dalBPM.IncidentNo;
obj.Activity = dalBPM.ActivityName;
obj.TaskId = dalBPM.TaskID;
obj.UserId = dalBPM.UserID.Trim();
obj.UserName = dalBPM.UserName;
obj.Remarks = txtRemarks.Content;
if (db.Entry(obj).State == EntityState.Detached)
{
db.SAP_VendorCreation.Attach(obj);
}
db.Entry(obj).State = EntityState.Modified;
var log = db.GetVendorCreationLog(main: obj, activity: dalBPM.ActivityName, taskId: dalBPM.TaskID);
if (log.Id == 0)
{
db.SAP_VendorCreationLog.Add(log);
}
else
{
if (db.Entry(log).State == EntityState.Detached)
{
db.SAP_VendorCreationLog.Attach(log);
}
db.Entry(log).State = EntityState.Modified;
}
db.SaveChanges();
Response.Redirect("~/View.aspx?TaskID=" + dalBPM.TaskID, false);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btEmail_Click(object sender, EventArgs e)
{
try
{
string _message = "<p>New vendor form has been initiated please click on following link to view the details </p> http://UEISBAP001/vendorcreation/print.aspx?requestid=" + hidRecordID.Value;
// SendEmail(_message);
SAP_VendorCreation obj = db.SAP_VendorCreation.Find(hidRecordID.Value);
obj.EmailSent = true;
obj.EmailSentDate = DateTime.Now;
db.SaveChanges();
LoadForm();
lblError.Text = "Email has been successfully sent.";
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
lblError.Text = "";
PageLoad();
if (!IsPostBack && dalBPM != null)
{
if (dalBPM.TaskStatus.Equals(BPMExecution.TASK_STATUS_IN_QUEUE) || dalBPM.TaskStatus.Equals(BPMExecution.TASK_STATUS_RETURN) || dalBPM.TaskStatus.Equals(BPMExecution.TASK_STATUS_COMPLETE))
{
Response.Redirect("~/CompletedView.aspx?" + EncryptQueryString, false);
return;
}
else
{
LoadControls();
this.RequestId = dalBPM.RecordID;
SAP_VendorCreation objMain = null;
if (string.IsNullOrEmpty(dalBPM.RecordID))
{
objMain = db.AddVendorCreation(dalBPM.UserID, dalBPM.UserName);
}
else
{
objMain = db.GetVendorCreation(dalBPM.RecordID);
}
if (objMain != null)
{
this.RequestId = objMain.RequestId;
LoadForm(objMain);
}
hidRecordID.Value = this.RequestId;
BindAttachments(dgAttachment);
// GetGroupUsers(ddlTo);
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SAP_VendorCreation obj = db.SAP_VendorCreation.Find(hidRecordID.Value);
try
{
if (!Validation())
{
return;
}
this.SetData(obj);
obj.Status = 1;
db.SaveChanges();
string Incident_Summary = "Vendor " + txtBusinessName.Text.Replace("'", "''");
dalBPM.SetVarValue("INCIDENT_SUMMARY", Incident_Summary);
dalBPM.SetVarValue("IEmail", dalBPM.UserEmail);
dalBPM.SetVarValue("I_User", dalBPM.UserID);
dalBPM.SetVarValue("RecordKey", hidRecordID.Value);
// dalBPM.SetVarValue("HOD", ddlTo.SelectedValue);
int IncidentNo = dalBPM.SubmitTask(Incident_Summary, hidRecordID.Value, "Initiated", txtRemarks.Content);
if (IncidentNo > 0)
{
if (!obj.InitiatedDate.HasValue || obj.IncidentNo == 0)
{
obj.InitiatedDate = DateTime.Now;
obj.UpdatedDate = obj.InitiatedDate;
}
else
{
obj.UpdatedDate = DateTime.Now;
}
obj.Status = 1;
obj.IncidentNo = dalBPM.IncidentNo;
obj.Activity = dalBPM.ActivityName;
obj.TaskId = dalBPM.TaskID;
obj.UserId = dalBPM.UserID.Trim();
obj.UserName = dalBPM.UserName;
obj.Remarks = txtRemarks.Content;
if (db.Entry(obj).State == EntityState.Detached)
{
db.SAP_VendorCreation.Attach(obj);
}
db.Entry(obj).State = EntityState.Modified;
var log = db.GetVendorCreationLog(main: obj, activity: dalBPM.ActivityName, taskId: dalBPM.TaskID);
if (log.Id == 0)
{
db.SAP_VendorCreationLog.Add(log);
}
else
{
if (db.Entry(log).State == EntityState.Detached)
{
db.SAP_VendorCreationLog.Attach(log);
}
db.Entry(log).State = EntityState.Modified;
}
db.SaveChanges();
// Response.Redirect("~/View.aspx?TaskID=" + dalBPM.TaskID, false);
Response.Redirect("~/SuccessfullySubmited.aspx", false);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void SetData(SAP_VendorCreation obj)
{
if (obj == null)
{
obj = db.SAP_VendorCreation.Find(hidRecordID.Value);
}
obj.RequestId = hidRecordID.Value;
obj.AccountNoIBAN = txtIBAN.Text;
obj.Address = txtAddress.Text;
obj.BankAddress = txtBankAddress.Text;
if (ddlCountry.SelectedIndex != -1)
{
obj.Country = ddlCountry.SelectedItem.Text;
}
obj.PostalCode = txtPostalCode.Text;
obj.City = txtCity.Text;
obj.BenificaryName = txtBenificaryName.Text;
obj.BusinessName = txtBusinessName.Text;
if (rblClassification.SelectedIndex != -1)
{
obj.Classification = rblClassification.SelectedValue;
}
if (rblType.SelectedIndex != -1)
{
obj.CompanyType = rblType.SelectedValue;
}
obj.ContactPerson = txtContactPerson.Text;
obj.Email = txtEmail.Text;
obj.FaxNo = txtFaxNo.Text;
if (rblNaturOfWork.SelectedIndex != -1)
{
obj.NatureOfWork = rblNaturOfWork.SelectedValue;
}
obj.NTNNo = txtNTN.Text;
if (ddlCurrency.SelectedIndex != -1)
{
obj.PaymentCurrency = ddlCurrency.SelectedItem.Text;
}
if (rblPaymentMethod.SelectedIndex != -1)
{
obj.PaymentMethod = rblPaymentMethod.SelectedValue;
}
if (ddlPaymentTerms.SelectedIndex != -1)
{
obj.PaymentTerms = ddlPaymentTerms.SelectedItem.Text;
}
obj.PeriodUpto = txtPeriod.Text;
obj.PhoneNo = txtContactNo.Text;
if (rblQualification.SelectedIndex != -1)
{
obj.Qualification = rblQualification.SelectedValue;
}
if (rblAttached.SelectedIndex != -1)
{
obj.QuestionnaireCompleted = rblAttached.SelectedValue == "Yes";
}
obj.RegNA = txtNA.Checked;
if (rblOptions.SelectedIndex != -1)
{
obj.RequestType = rblOptions.SelectedValue;
}
obj.Reason = txtReason.Text;
obj.RoutingNo = txtRoutingNo.Text;
obj.State = txtState.Text;
if (ddlWitholdingTaxField.SelectedIndex != -1)
{
obj.WithholdingTax = ddlWitholdingTaxField.SelectedItem.Text;
}
obj.SwiftCode = txtSwiftCode.Text;
obj.TaxRegNo = txtSaleTaxReg.Text;
obj.UpdatedDate = DateTime.Now;
obj.CreatedDate = DateTime.Now;
obj.UserId = dalBPM.UserID;
obj.UserName = dalBPM.UserName;
obj.Remarks = txtRemarks.Content;
}
protected void btSubmit_Click(object sender, EventArgs e)
{
try
{
if (!Validation())
return;
SAP_VendorCreation obj = db.SAP_VendorCreation.Find(hidRecordID.Value);
if (optReturn.Checked || optReject.Checked)
{
if (txtRemarks.Text.Equals(""))
{
lblError.Text = "Please enter remarks.";
return;
}
}
string AppStatus = "", _Action = "";
obj.AccountNoIBAN = txtIBAN.Text;
obj.Address = txtAddress.Text;
obj.BankAddress = txtBankAddress.Text;
if (ddlCountry.SelectedIndex != -1)
obj.Country = ddlCountry.SelectedItem.Text;
obj.PostalCode = txtPostalCode.Text;
obj.City = txtCity.Text;
obj.BenificaryName = txtBenificaryName.Text;
obj.BusinessName = txtBusinessName.Text;
if (rblClassification.SelectedIndex != -1)
obj.Classification = rblClassification.SelectedValue;
if (rblType.SelectedIndex != -1)
obj.CompanyType = rblType.SelectedValue;
obj.ContactPerson = txtContactPerson.Text;
obj.Email = txtEmail.Text;
obj.FaxNo = txtFaxNo.Text;
if (rblNaturOfWork.SelectedIndex != -1)
obj.NatureOfWork = rblNaturOfWork.SelectedValue;
obj.NTNNo = txtNTN.Text;
if (ddlCurrency.SelectedIndex != -1)
obj.PaymentCurrency = ddlCurrency.SelectedItem.Text;
if (rblPaymentMethod.SelectedIndex != -1)
obj.PaymentMethod = rblPaymentMethod.SelectedValue;
if (ddlPaymentTerms.SelectedIndex != -1)
obj.PaymentTerms = ddlPaymentTerms.SelectedItem.Text;
obj.PeriodUpto = txtPeriod.Text;
obj.PhoneNo = txtContactNo.Text;
if (rblQualification.SelectedIndex != -1)
obj.Qualification = rblQualification.SelectedValue;
if (rblAttached.SelectedIndex != -1)
obj.QuestionnaireCompleted = rblAttached.SelectedValue == "Yes";
obj.RegNA = txtNA.Checked;
if (rblOptions.SelectedIndex != -1)
obj.RequestType = rblOptions.SelectedValue;
obj.Reason = txtReason.Text;
obj.RoutingNo = txtRoutingNo.Text;
obj.State = txtState.Text;
if (ddlWitholdingTaxField.SelectedIndex != -1)
obj.WithholdingTax = ddlWitholdingTaxField.SelectedItem.Text;
obj.SwiftCode = txtSwiftCode.Text;
obj.TaxRegNo = txtSaleTaxReg.Text;
obj.UpdatedDate = DateTime.Now;
obj.IssuedBy = dalBPM.UserID;
obj.IssuedOn = DateTime.Now;
db.SaveChanges();
if (optApprove.Checked)
{
AppStatus = "1";
_Action = "Forward";
}
else if (optReject.Checked)
{
AppStatus = "2";
_Action = "Disapprove";
dalBPM.SetVarValue("Message", "Your vendor " + txtBusinessName.Text + " request has been disapproved due to " + txtRemarks.Text);
dalBPM.SetVarValue("Subject", "Vendor Disapproved");
}
else
{
AppStatus = "3";
_Action = "Return";
}
dalBPM.SetVarValue("AppStatus", AppStatus);
int IncidentNo = dalBPM.SubmitTask(_Action, txtRemarks.Content);
if (IncidentNo > 0)
{
obj.UpdatedDate = DateTime.Now;
obj.Status = 1;
obj.IncidentNo = dalBPM.IncidentNo;
obj.Activity = dalBPM.ActivityName;
obj.TaskId = dalBPM.TaskID;
obj.UserId = dalBPM.UserID.Trim();
obj.UserName = dalBPM.UserName;
obj.Remarks = txtRemarks.Content;
if (db.Entry(obj).State == EntityState.Detached)
{
db.SAP_VendorCreation.Attach(obj);
}
db.Entry(obj).State = EntityState.Modified;
var log = db.GetVendorCreationLog(main: obj, activity: dalBPM.ActivityName, taskId: dalBPM.TaskID);
if (log.Id == 0)
db.SAP_VendorCreationLog.Add(log);
else
{
if (db.Entry(log).State == EntityState.Detached)
{
db.SAP_VendorCreationLog.Attach(log);
}
db.Entry(log).State = EntityState.Modified;
}
db.SaveChanges();
Response.Redirect("~/View.aspx?TaskID=" + dalBPM.TaskID, false);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btSubmit_Click(object sender, EventArgs e)
{
SAP_VendorCreation obj = db.SAP_VendorCreation.Find(hidRecordID.Value);
try
{
if (!Validation())
{
return;
}
if (obj == null)
{
obj = new SAP_VendorCreation();
}
obj.RequestId = hidRecordID.Value;
obj.AccountNoIBAN = txtIBAN.Text;
obj.Address = txtAddress.Text;
obj.BankAddress = txtBankAddress.Text;
if (ddlCountry.SelectedIndex != -1)
{
obj.Country = ddlCountry.SelectedItem.Text;
}
obj.PostalCode = txtPostalCode.Text;
obj.City = txtCity.Text;
obj.BenificaryName = txtBenificaryName.Text;
obj.BusinessName = txtBusinessName.Text;
if (rblClassification.SelectedIndex != -1)
{
obj.Classification = rblClassification.SelectedValue;
}
if (rblType.SelectedIndex != -1)
{
obj.CompanyType = rblType.SelectedValue;
}
obj.ContactPerson = txtContactPerson.Text;
obj.Email = txtEmail.Text;
obj.FaxNo = txtFaxNo.Text;
if (rblNaturOfWork.SelectedIndex != -1)
{
obj.NatureOfWork = rblNaturOfWork.SelectedValue;
}
obj.NTNNo = txtNTN.Text;
if (ddlCurrency.SelectedIndex != -1)
{
obj.PaymentCurrency = ddlCurrency.SelectedItem.Text;
}
if (rblPaymentMethod.SelectedIndex != -1)
{
obj.PaymentMethod = rblPaymentMethod.SelectedValue;
}
if (ddlPaymentTerms.SelectedIndex != -1)
{
obj.PaymentTerms = ddlPaymentTerms.SelectedItem.Text;
}
obj.PeriodUpto = txtPeriod.Text;
obj.PhoneNo = txtContactNo.Text;
if (rblQualification.SelectedIndex != -1)
{
obj.Qualification = rblQualification.SelectedValue;
}
if (rblAttached.SelectedIndex != -1)
{
obj.QuestionnaireCompleted = rblAttached.SelectedValue == "Yes";
}
obj.RegNA = txtNA.Checked;
if (rblOptions.SelectedIndex != -1)
{
obj.RequestType = rblOptions.SelectedValue;
}
obj.Reason = txtReason.Text;
obj.RoutingNo = txtRoutingNo.Text;
obj.State = txtState.Text;
if (ddlWitholdingTaxField.SelectedIndex != -1)
{
obj.WithholdingTax = ddlWitholdingTaxField.SelectedItem.Text;
}
obj.SwiftCode = txtSwiftCode.Text;
obj.TaxRegNo = txtSaleTaxReg.Text;
obj.UpdatedDate = DateTime.Now;
obj.UserId = dalBPM.UserID;
obj.UserName = dalBPM.UserName;
db.SaveChanges();
string Incident_Summary = "Vendor " + txtBusinessName.Text.Replace("'", "''");
dalBPM.SetVarValue("INCIDENT_SUMMARY", Incident_Summary);
// dalBPM.SetVarValue("HOD", ddlTo.SelectedValue);
dalBPM.SubmitTask("Resubmitted", txtRemarks.Text);
Response.Redirect("~/View.aspx?TaskID=" + dalBPM.TaskID, false);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
