protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName.ToLower()) { case "removeinsightsuppliercontactlink": { string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); int insightSupplierContactLinkId = Convert.ToInt32(commandArgs[0]); int insightSupplierContactLicenseId = Convert.ToInt32(commandArgs[1]); int insightSupplierContactIdSelectedUser = InsightSupplierContact.GetInsightSupplierContactByInsightSupplierContactLinkId(insightSupplierContactLinkId).InsightSupplierContactId; InsightSupplierContactDistributionLink.DeleteInsightSupplierContactDistributionLinkByInsightSupplierContactId(this.insightSupplierId, insightSupplierContactIdSelectedUser); InsightSupplierContactDistributionOption.DeleteInsightSupplierContactDistributionOptionByInsightSupplierContactId(this.insightSupplierId, insightSupplierContactIdSelectedUser); InsightSupplierContactDistributionModel.DeleteInsightSupplierContactDistributionModelByInsightSupplierContactId(this.insightSupplierId, insightSupplierContactIdSelectedUser); InsightSupplierContactLicense.DeleteInsightSupplierContactLicenseByInsightSupplierContactIdInsightSupplierId(this.insightSupplierId, insightSupplierContactIdSelectedUser); InsightSupplierContactLink.DeleteInsightSupplierContactLinkByInsightSupplierContactLinkId(insightSupplierContactLinkId); //InsightSupplierContactLink.DeleteInsightSupplierContactLinkByInsightSupplierContactLinkId(Convert.ToInt32(e.CommandArgument)); BindInsightSupplierContactGridView(); TextBoxFirstName.Text = ""; TextBoxLastName.Text = ""; TextBoxPosition.Text = ""; TextBoxLandline.Text = ""; TextBoxMobile.Text = ""; TextBoxEmail.Text = ""; TextBoxAddress.Text = ""; TextBoxUsername.Text = ""; TextBoxPassword.Text = ""; BindRegion(); BindGift(); BindModel(); BindOption(); BindLink(); BindAccessMethod(); BindLicense(); BindQlikviewVersion(); PanelInstall.Visible = false; PanelOnline.Visible = false; break; } } } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { Page.Form.DefaultFocus = TextBoxSearch.ClientID; Page.Form.DefaultButton = ButtonSearch.UniqueID; if (!IsPostBack) { string searchValue = "%"; GridViewResult.DataSource = InsightSupplierContact.GetInsightSupplierContactListByFilter(searchValue); GridViewResult.DataBind(); } }
protected void GridViewUser_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName.ToLower()) { case "removeinsightsuppliercontactlink": { string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); int insightSupplierContactLinkId = Convert.ToInt32(commandArgs[0]); int insightSupplierContactLicenseId = Convert.ToInt32(commandArgs[1]); int insightSupplierContactId = InsightSupplierContact.GetInsightSupplierContactByInsightSupplierContactLinkId(insightSupplierContactLinkId).InsightSupplierContactId; InsightSupplierContactDistributionLink.DeleteInsightSupplierContactDistributionLinkByInsightSupplierContactId(this.insightSupplierId, insightSupplierContactId); InsightSupplierContactDistributionOption.DeleteInsightSupplierContactDistributionOptionByInsightSupplierContactId(this.insightSupplierId, insightSupplierContactId); InsightSupplierContactDistributionModel.DeleteInsightSupplierContactDistributionModelByInsightSupplierContactId(this.insightSupplierId, insightSupplierContactId); //InsightSupplierContactLicense.DeleteInsightSupplierContactLicenseByInsightSupplierContactLicenseId(insightSupplierContactLicenseId); InsightSupplierContactLicense.DeleteInsightSupplierContactLicenseByInsightSupplierContactIdInsightSupplierId(this.insightSupplierId, insightSupplierContactId); InsightSupplierContactLink.DeleteInsightSupplierContactLinkByInsightSupplierContactLinkId(insightSupplierContactLinkId); //InsightSupplierContactLink.DeleteInsightSupplierContactLinkByInsightSupplierContactLinkId(Convert.ToInt32(e.CommandArgument)); BindInsightSupplierContactList(); BindInsightSupplierContactGridView(); break; } } } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } }
private void BindInsightSupplierContactGridView() { GridViewResult.DataSource = InsightSupplierContact.GetInsightSupplierContactListByInsightSupplierId(this.insightSupplierId); GridViewResult.DataBind(); }
protected void ButtonSave_Click(object sender, EventArgs e) { if (Page.IsValid) { InsightSupplierContact insightSupplierContact = new InsightSupplierContact(); insightSupplierContact.InsightSupplierContactId = this.insightSupplierContactId; //insightSupplierContact.AccountId = Convert.ToInt32(DropDownListAccount.SelectedValue); insightSupplierContact.FirstName = TextBoxFirstName.Text; insightSupplierContact.LastName = TextBoxLastName.Text; insightSupplierContact.Landline = TextBoxLandline.Text; insightSupplierContact.Mobile = (TextBoxMobile.Text.Length == 0) ? "" : TextBoxMobile.Text; insightSupplierContact.Email = (TextBoxEmail.Text.Length == 0) ? "" : TextBoxEmail.Text; insightSupplierContact.Address = (TextBoxAddress.Text.Length == 0) ? "" : TextBoxAddress.Text; insightSupplierContact.RegionId = Convert.ToInt32(DropDownListRegion.SelectedValue); insightSupplierContact.Gift = Convert.ToInt32(DropDownListGift.SelectedValue); insightSupplierContact.AccessMethodId = Convert.ToInt32(DropDownListAccessMethod.SelectedValue); insightSupplierContact.Position = (TextBoxPosition.Text.Length == 0) ? "" : TextBoxPosition.Text; insightSupplierContact.ModifiedUser = Context.User.Identity.GetUserName(); try { insightSupplierContact.Save(); int insightSupplierContactId = insightSupplierContact.InsightSupplierContactId; InsightSupplierContactLicense insightSupplierContactLicenseRow = InsightSupplierContactLicense.GetInsightSupplierContactLicenseByInsightSupplierContactIdAccessMethodId(insightSupplierContact.InsightSupplierContactId, Convert.ToInt32(DropDownListAccessMethod.SelectedValue)); if (Convert.ToInt32(DropDownListAccessMethod.SelectedValue) == 1) //Online { InsightSupplierContactLicense insightSupplierContactLicense = new InsightSupplierContactLicense(); insightSupplierContactLicense.InsightSupplierContactLicenseId = insightSupplierContactLicenseRow.InsightSupplierContactLicenseId; insightSupplierContactLicense.InsightSupplierContactId = insightSupplierContact.InsightSupplierContactId; insightSupplierContactLicense.AccessMethodId = Convert.ToInt32(DropDownListAccessMethod.SelectedValue); insightSupplierContactLicense.Username = TextBoxUsername.Text; insightSupplierContactLicense.Password = TextBoxPassword.Text; insightSupplierContactLicense.LicenseId = 0; insightSupplierContactLicense.QlikviewVersionId = 0; insightSupplierContactLicense.ModifiedUser = Context.User.Identity.GetUserName(); insightSupplierContactLicense.Save(); BindLicenseGridView(insightSupplierContact.InsightSupplierContactId); } //InsightSupplierContactLicense.UpdateInsightSupplierContactLicenseInSparMapperByInsightSupplierContactLicenseId(insightSupplierContactLicenseRow.InsightSupplierContactLicenseId, (TextBoxInSparMapperUsername.Text.Length > 0) ? TextBoxInSparMapperUsername.Text : "", (TextBoxInSparMapperPassword.Text.Length > 0) ? TextBoxInSparMapperPassword.Text : "", Context.User.Identity.GetUserName()); InsightSupplierContactLicense.UpdateInsightSupplierContactLicenseInSparMapperByInsightSupplierContactId(insightSupplierContact.InsightSupplierContactId, (TextBoxInSparMapperUsername.Text.Length > 0) ? TextBoxInSparMapperUsername.Text : "", (TextBoxInSparMapperPassword.Text.Length > 0) ? TextBoxInSparMapperPassword.Text : "", Context.User.Identity.GetUserName()); if (this.insightSupplierId != 0) { InsightSupplierContactLink insightSupplierContactLink = new InsightSupplierContactLink(); insightSupplierContactLink.InsightSupplierContactId = insightSupplierContact.InsightSupplierContactId; insightSupplierContactLink.InsightSupplierId = this.insightSupplierId; insightSupplierContactLink.ModifiedUser = Context.User.Identity.GetUserName(); insightSupplierContactLink.Save(); BindInsightSupplierContactGridView(); } if (insightSupplierContactId != 0) { SaveInsightSupplierContactDistributionLink(insightSupplierContactId); } if (insightSupplierContactId != 0) { SaveInsightSupplierContactDistributionOption(insightSupplierContactId); } if (insightSupplierContactId != 0) { SaveInsightSupplierContactDistributionModel(insightSupplierContactId); } Button clickedButton = (Button)sender; switch (clickedButton.ID) { case "ButtonSave": Response.Redirect("InsightSupplierContactList.aspx"); break; case "ButtonSaveEdit": Response.Redirect(String.Format("InsightSupplierContactEdit.aspx?InsightSupplierContactId={0}&InsightSupplierId={1}", insightSupplierContact.InsightSupplierContactId, this.insightSupplierId)); break; case "ButtonSaveNew": Response.Redirect("InsightSupplierContactEdit.aspx"); break; case "ButtonSaveLink": Response.Redirect(String.Format("InsightSupplierContactEdit.aspx?InsightSupplierContactId={0}&InsightSupplierId={1}", 0, this.insightSupplierId)); break; } } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { ErrorMessage.Text += (sqlEx.Errors[i].Message + "<br />"); } } } }
private void BindInsightSupplierContact() { try { InsightSupplierContact insightSupplierContact = InsightSupplierContact.GetInsightSupplierContactByInsightSupplierContactId(this.insightSupplierContactId); //DropDownListAccount.Items.FindByValue(insightSupplierContact.AccountId.ToString()).Selected = true; TextBoxFirstName.Text = insightSupplierContact.FirstName; TextBoxLastName.Text = insightSupplierContact.LastName; TextBoxLandline.Text = insightSupplierContact.Landline; TextBoxMobile.Text = insightSupplierContact.Mobile; TextBoxEmail.Text = insightSupplierContact.Email; TextBoxAddress.Text = insightSupplierContact.Address; DropDownListRegion.Items.FindByValue(insightSupplierContact.RegionId.ToString()).Selected = true; DropDownListGift.Items.FindByValue(insightSupplierContact.Gift.ToString()).Selected = true; DropDownListAccessMethod.Items.FindByValue(insightSupplierContact.AccessMethodId.ToString()).Selected = true; TextBoxPosition.Text = insightSupplierContact.Position; InsightSupplierContactLicense insightSupplierContactLicenseISM = InsightSupplierContactLicense.GetInsightSupplierContactLicenseInSparMapperByInsightSupplierContactId(this.insightSupplierContactId); TextBoxInSparMapperUsername.Text = insightSupplierContactLicenseISM.InSparMapperUsername; TextBoxInSparMapperPassword.Text = insightSupplierContactLicenseISM.InSparMapperPassword; BindAccessMethodLayout(); if (Convert.ToInt32(DropDownListAccessMethod.SelectedValue) == 1) //Online { BindAccessMethodLayout(); } else { //DropDownListLicense.Items.FindByValue(insightSupplierContact.LicenseId.ToString()).Selected = true; //DropDownListQlikviewVersion.Items.FindByValue(insightSupplierContact.QlikviewVersionId.ToString()).Selected = true; BindLicenseGridView(this.insightSupplierContactId); TextBoxUsername.Text = ""; TextBoxPassword.Text = ""; } List <InsightSupplierContactDistributionLink> iscdlList = InsightSupplierContactDistributionLink.GetInsightSupplierContactDistributionLinkByInsightSupplierContactId(this.insightSupplierId, this.insightSupplierContactId); foreach (ListItem listItem in CheckBoxListLink.Items) { foreach (InsightSupplierContactDistributionLink iscdl in iscdlList) { if (listItem.Value == iscdl.LinkId.ToString()) { listItem.Selected = true; } } } List <InsightSupplierContactDistributionOption> iscdOList = InsightSupplierContactDistributionOption.GetInsightSupplierContactDistributionOptionByInsightSupplierContactId(this.insightSupplierId, this.insightSupplierContactId); foreach (ListItem listItem in CheckBoxListOption.Items) { foreach (InsightSupplierContactDistributionOption iscdO in iscdOList) { if (listItem.Value == iscdO.OptionId.ToString()) { listItem.Selected = true; } } } List <InsightSupplierContactDistributionModel> iscdMList = InsightSupplierContactDistributionModel.GetInsightSupplierContactDistributionModelByInsightSupplierContactId(this.insightSupplierId, this.insightSupplierContactId); foreach (ListItem listItem in CheckBoxListModel.Items) { foreach (InsightSupplierContactDistributionModel iscdM in iscdMList) { if (listItem.Value == iscdM.ModelId.ToString()) { listItem.Selected = true; } } } } catch (System.Data.SqlClient.SqlException sqlEx) { for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } catch (Exception exception) { LabelError.Text += (exception.Message + "<br />"); PanelError.Visible = true; } }
protected void ButtonSearch_Click(object sender, EventArgs e) { GridViewResult.DataSource = InsightSupplierContact.GetInsightSupplierContactListByFilter("%" + TextBoxSearch.Text + "%"); GridViewResult.DataBind(); }
private void BindInsightSupplierContactGridView() { GridViewUser.DataSource = InsightSupplierContact.GetInsightSupplierContactListByInsightSupplierId(Convert.ToInt32(ViewState["InsightSupplierId"])); GridViewUser.DataBind(); }