/// <summary> /// Creates a Xero line item for every Aquairum line item with a matching Invoice number, and bundles them up into a Xero invoice /// </summary> /// <param name="theInvoiceLineItemToConvert"></param> /// <returns></returns> public static XeroApi.Model.Invoice ConvertMultipleOutboundInvoiceLineItemsToXeroInvoice(OutboundInvoiceLineItemList theInvoiceLineItemsToConvert, OutboundInvoiceLineItem theLineItemToMatchTo, Datalayer.Xero.Interresolve.InterResolveXeroService aService) { try { XeroApi.Model.Invoice theInvoiceToReturn = new XeroApi.Model.Invoice(); theInvoiceToReturn.LineItems = new XeroApi.Model.LineItems(); theInvoiceToReturn.Contact = new XeroApi.Model.Contact(); //NEED TO SPECIFY A CONTACT //assign the xero contact aService.LoginToXero(); theInvoiceToReturn.Contact = aService.GetXeroContactFromAquariumInvoiceLineItemList(theLineItemToMatchTo); //assign top level invoice fields for the passed invoice to the Xero counterpart theInvoiceToReturn.InvoiceNumber = theLineItemToMatchTo.InvoiceNumber.ToString(); theInvoiceToReturn.Status = "DRAFT"; theInvoiceToReturn.Type = "ACCREC"; //Sales invoice theInvoiceToReturn.Reference = theLineItemToMatchTo.SageNarrative + " " + theLineItemToMatchTo.YourRef; theInvoiceToReturn.LineAmountTypes = XeroApi.Model.LineAmountType.Exclusive; theInvoiceToReturn.SubTotal = theLineItemToMatchTo.OriginalPurchaseInvoiceTotal; theInvoiceToReturn.DueDate = DateTime.Now.AddDays(14); theInvoiceToReturn.Date = theLineItemToMatchTo.InvoiceDate; // theInvoiceToReturn.TotalTax //this must be calculated AFTER by summing all the line item VATs theInvoiceToReturn.Total = theLineItemToMatchTo.OriginalPurchaseInvoiceTotal; //iterate through and if number matches specified invoice number, add it to the list decimal RunningVATTotalForInvoice = new decimal(0.00); for (int i = 0; i < theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.Count(); i++) { if (theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.ElementAt(i).InvoiceNumber == theLineItemToMatchTo.InvoiceNumber) { //if the invoice numbers match, create a new line item and add this line item to the list XeroApi.Model.LineItem aLineItem = new XeroApi.Model.LineItem(); aLineItem.Quantity = 1; //always one line item aLineItem.Description = theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.ElementAt(i).InvoiceType; // aLineItem.UnitAmount = theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.ElementAt(i).OriginalPurchaseInvoiceAmount; aLineItem.TaxAmount = theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.ElementAt(i).OriginalPurchaseInvoiceVAT; aLineItem.LineAmount = (aLineItem.Quantity * aLineItem.UnitAmount); aLineItem.AccountCode = InterResolveXeroService.GetXeroAccountCodeForAquariumLineItem(theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.ElementAt(i)); //add the VAT to the running total RunningVATTotalForInvoice =+ theInvoiceLineItemsToConvert.OutboundInvoiceLineItems.ElementAt(i).OriginalPurchaseInvoiceVAT; //add it to the list theInvoiceToReturn.LineItems.Add(aLineItem); } } //assign the overall invoice VAT theInvoiceToReturn.TotalTax = RunningVATTotalForInvoice; return theInvoiceToReturn; } catch (Exception ex) { throw ex; } }
public static DataTable QueryInvoices(CustomProcessingSoapClient customSdk, Datalayer.Xero.Interresolve.AquariumCustomProcessing.SessionDetails sessionDetails, AquariumInvoiceTypeToQuery theInvoiceType) { DataTable TableToReturn = new DataTable(); string ProcName = ""; switch(theInvoiceType) { case AquariumInvoiceTypeToQuery.InboundInvoice: ProcName = System.Configuration.ConfigurationManager.AppSettings["_C74_Xero_GetInboundInvoiceData"].ToString(); break; case AquariumInvoiceTypeToQuery.OutboundInvoice: ProcName = System.Configuration.ConfigurationManager.AppSettings["_C74_Xero_GetInvoiceData"].ToString(); break; } string[] ProcParm = null; ReportResult result = new ReportResult(); result = customSdk.RunCustomProc(sessionDetails, ProcName, ProcParm); if (result.ResultInfo.ReturnCode == Datalayer.Xero.Interresolve.AquariumCustomProcessing.BasicCode.OK) { TableToReturn = SDKGeckoboardHelper.GetDataTableFromSdkResult(result.Data.Columns, result.Data.Rows); return TableToReturn; } else { Exception ex = new Exception("There has been a problem in the QueryInvoices method in the invoice helper class"); throw ex; } }
public StartCentre() { InitializeComponent(); Datalayer dl = Datalayer.Instance; dl.Open(); lblSite.Text = String.Format("{0} Workorder Backlog Prioritisation", dl.Site); DataPointCollection pc = progressPie.Series[0].Points; DataPoint p = null; Button b = null; DataSet prog = dl.GetProgressSummary(); foreach (DataRow row in prog.Tables["Progress"].Rows) { AssessmentStatus status = AssessmentStatuses.GetStatus(row["AssessmentStatus"].ToString()); switch (status) { case AssessmentStatus.New: p = pc[0]; p.Color = Color.Orange; b = btnNew; break; case AssessmentStatus.Completed: p = pc[1]; p.Color = Color.SeaGreen; b = btnComp; break; case AssessmentStatus.Cancelled: p = pc[2]; p.Color = Color.Crimson; b = btnCan; break; } p.AxisLabel = AssessmentStatuses.GetStatusDescription(status); p.YValues[0] = double.Parse(row["WoCount"].ToString()); b.Text = p.AxisLabel; b.BackColor = p.Color; b.Tag = p.Tag = status; } progressPie.Invalidate(); progressPie.Update(); priorityChart.Series[0].Points[0].Color = Color.PaleTurquoise; priorityChart.Series[0].Points[1].Color = Color.MediumAquamarine; priorityChart.Series[0].Points[2].Color = Color.Teal; priorityChart.Series[0].Points[3].Color = Color.DarkSlateGray; }
public void PhotoBag() { Property p = new Property(); Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); p.Condition1 = "5"; p.Condition2 = ""; p.Condition3 = ""; p.onTable = "FETCH_HOME_CONTENT"; ds = dl.FETCH_CONDITIONAL_QUERY(p); List <Property> Photo = new List <Property>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Property p1 = new Property(); p1.id = ds.Tables[0].Rows[i]["id"].ToString(); p1.Title = ds.Tables[0].Rows[i]["Title"].ToString(); p1.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString(); p1.Description = ds.Tables[0].Rows[i]["Description"].ToString(); Regex rstr = new Regex("<(.|\n)*?>"); if (rstr.IsMatch(p1.Description)) { p1.Description = rstr.Replace(p1.Description, ""); } if (p1.Description.Length >= 100) { p1.Description = p1.Description.Substring(0, 100) + "..."; } else { p1.Description = p1.Description; } p1.ThumbImgURL = ds.Tables[0].Rows[i]["ThumbImgURL"].ToString().Replace("~", ""); p1.ImgURL = ds.Tables[0].Rows[i]["ImgURL"].ToString().Replace("~", ""); Photo.Add(p1); } } else { Property p1 = new Property(); p1.id = "0"; p1.Title = "NONE"; p1.Description = "NONE"; Photo.Add(p1); } ViewBag.PhotoList = Photo; }
public JsonResult Getalluser() { try { Datalayer dl = new Datalayer(); List <UserModel> userlist = dl.getusers(); return(Json(userlist)); } catch (Exception ex) { return(Json(new { status = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public void Updatemodel(DataGridView drv) { Datalayer d1 = new Datalayer(); foreach (DataGridViewRow row in drv.Rows) { if (!row.IsNewRow) { d1.Updatemodel(row.Cells["Company_Name"].Value + "", row.Cells["Mod_Name"].Value + "", row.Cells["Mod_Quantity"].Value + "", row.Cells["Mod_Sell_Cost"].Value + "", row.Cells["Ram"].Value + "", row.Cells["CPU"].Value + "", row.Cells["Internal_Storage"].Value + "", row.Cells["Screen_Size"].Value + "", row.Cells["Primary_Camera"].Value + "", row.Cells["Secondry_Camera"].Value + ""); MessageBox.Show("Update Operation is Completed"); } } }
public void companyCheck(DataGridView drv) { Datalayer d1 = new Datalayer(); foreach (DataGridViewRow row in drv.Rows) { if (!row.IsNewRow) { d1.companyCheck(row.Cells["Company_Name"].Value + "", row.Cells["mod_Serial"].Value + ""); MessageBox.Show("Update Operation is Completed"); } } }
public void UpdateCust(DataGridView drv) { Datalayer dl = new Datalayer(); foreach (DataGridViewRow row in drv.Rows) { if (!row.IsNewRow) { dl.UpdateCust(row.Cells["SSN"].Value + "", row.Cells["Name"].Value + "", row.Cells["Phone"].Value + "", row.Cells["Email"].Value + ""); MessageBox.Show("Update Operation is Completed"); } } }
private void frmCustomerBalance_Load(object sender, EventArgs e) { Datalayer.SetButtion(btnSearch); Datalayer.SetButtion(btnClear); Datalayer.SetSoftwareThems(pnlHeader, pnlFooter); dbo.FillAccountList(cmbName, "c"); if (cmbName.Items.Count > 0) { cmbName.SelectedIndex = -1; } }
public void Vedio() { Property p = new Property(); Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); p.Condition1 = ""; p.Condition2 = ""; p.Condition3 = ""; p.onTable = "FETCH_VEDIO_CONTENT"; ds = dl.FETCH_CONDITIONAL_QUERY(p); List <Property> Detail = new List <Property>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Property p1 = new Property(); p1.id = ds.Tables[0].Rows[i]["id"].ToString(); p1.Title = ds.Tables[0].Rows[i]["Title"].ToString(); p1.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString(); p1.Description = ds.Tables[0].Rows[i]["Description"].ToString(); p1.Menu = ds.Tables[0].Rows[i]["MenuID"].ToString(); Regex rstr = new Regex("<(.|\n)*?>"); if (rstr.IsMatch(p1.Description)) { p1.Description = rstr.Replace(p1.Description, ""); } if (p1.Description.Length >= 1000) { p1.Description = p1.Description.Substring(0, 1000) + "..."; } else { p1.Description = p1.Description; } Detail.Add(p1); } } else { Property p1 = new Property(); p1.id = "0"; p1.Title = "NONE"; p1.Description = "NONE"; Detail.Add(p1); } ViewBag.vediocontentlist = Detail; }
public bool IsSSNExist(String CustomerSSN) { Datalayer dl = new Datalayer(); MySqlDataReader dr = dl.Select(null, "customer", "SSN", CustomerSSN); if (dr.Read()) { return(true); } else { return(false); } }
private void loginB_Click(object sender, EventArgs e) { String res = bl.LoginCheck(user.Text, password.Text); ///MessageBox.Show(Global.BillNo+""); /// //MessageBox.Show(Global.BillNo + "-------"+Global.Time+"----"); bool bo = true; if (res == null) { bo = false; MessageBox.Show("Invalid Username or Password"); } else if (res.Equals("admin")) { this.Parent.Parent.Hide(); Form2 adminF = new Form2(); adminF.Show(); } else { this.Parent.Parent.Hide(); Form1 empF = new Form1(); empF.Show(); } if (bo) { MySqlDataReader dr = new Datalayer().GetMaxDate(); dr.Read(); Global.Time = Convert.ToDateTime(dr.GetString(0)); Global.BillNo = Convert.ToInt32(dr.GetString(1)); } //if (Global.Time.Day != DateTime.Now.Day || Global.Time.Month != DateTime.Now.Month || Global.Time.Year != DateTime.Now.Year) //{ // //MessageBox.Show("Hoba"); // Global.BillNo = 1; //} //else //{ // Global.BillNo++; //} //Global.Time = DateTime.Now; }
private void tsbCount_Click(object sender, EventArgs e) { Datalayer d = Datalayer.Instance; try { Properties.Settings s = Properties.Settings.Default; statusLabel.Text = String.Format("Locations {0}", d.Open(s.OraUsername, s.OraPassword, s.OraTNS)); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public List <string> SearchComboBoxItems(String Table) { Datalayer dl = new Datalayer(); MySqlDataReader dr = dl.GetComboBoxItems(Table); List <string> ColName = new List <string>(); for (int i = 0; i < dr.FieldCount; i++) { if (!dr.GetName(i).Equals("Type") && !dr.GetName(i).Equals("ssnImage")) { ColName.Add(dr.GetName(i)); } } dr.Close(); return(ColName); }
public void InsertCust(String username, String Phone, String SSN, String Email, String fileName) { Datalayer dl = new Datalayer(); string FileName = fileName; byte[] ImageData; FileStream fs; BinaryReader br; fs = new FileStream(FileName, FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); ImageData = br.ReadBytes((int)fs.Length); br.Close(); fs.Close(); dl.insertCust(username, Phone, SSN, Email, ImageData); }
/// <summary> /// This would save the Personal details in the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click(object sender, RoutedEventArgs e) { ClassLibrary.MainClasses.PersonalDetails personalDetails = new ClassLibrary.MainClasses.PersonalDetails(); personalDetails.address1 = txtAddress1.Text; personalDetails.address2 = txtaddress2.Text; personalDetails.address3 = txtaddress3.Text; personalDetails.adhaarNumber = txtAdharrNumber.Text; personalDetails.age = txtAge.Text; personalDetails.attendanceId = Int32.Parse(txtattendanceid.Text); personalDetails.emialaddress = txtEmailAddress.Text; personalDetails.employeeID = Int32.Parse(txtempid.Text); personalDetails.EmployeeName = txtempname.Text; personalDetails.passportNumer = txtPassPortNumber.Text; personalDetails.age = txtAge.Text; personalDetails.fatherName = txtFathersName.Text; personalDetails.phone1 = txtphone1.Text; personalDetails.phone2 = txtphone2.Text; personalDetails.phone3 = txtphone3.Text; personalDetails.panNumber = txtPannumber.Text; Datalayer dl = new Datalayer(); Response res = dl.PersonalDetailsInTheDataBAse(personalDetails); if (res.success) { MessageBox.Show("Details Saved"); txtAddress1.Text = ""; txtaddress2.Text = ""; txtaddress3.Text = ""; txtAdharrNumber.Text = ""; txtAge.Text = ""; txtattendanceid.Text = ""; txtEmailAddress.Text = ""; txtempid.Text = ""; txtempname.Text = ""; txtPassPortNumber.Text = ""; txtAge.Text = ""; txtFathersName.Text = ""; txtphone1.Text = ""; txtphone2.Text = ""; txtphone3.Text = ""; txtPannumber.Text = ""; } else if (res.isException) { MessageBox.Show("Exception occured : " + res.exception); } }
void PopualteData() { string TM02_PARTYID = ""; int iTM02_PARTYID = 0; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iTM02_PARTYID); } if (iTM02_PARTYID > 0) { TM02_PARTYID = iTM02_PARTYID.ToString(); } DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_CUSTOMER_BAL_SUMMARY '" + TM02_PARTYID + "','" + Datalayer.iT001_COMPANYID + "'"); if (dt.Rows.Count > 0) { DataTable dt1 = new DataTable(); DataRow[] dr = dt.Select("TOTALSALE >0 "); if (dr.Length > 0) { dt1 = dr.CopyToDataTable(); } ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptCustomerBalSummary.rpt"); RptDoc.SetDataSource(dt1); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Customer Balance Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
public void ListMenu() { Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); Property p1 = new Property(); p1.Condition1 = ""; p1.Condition2 = ""; p1.Condition3 = ""; p1.onTable = "LIST_MENU"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); List <Property> Menu = new List <Property>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Property p = new Property(); p.id = ds.Tables[0].Rows[i]["id"].ToString(); p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString(); p.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString(); Menu.Add(p); } } else { Property p = new Property(); p.id = "0"; p.Menu = "NONE"; p.URLTitle = "NONE"; Menu.Add(p); } ViewBag.MenuList = Menu; }
public string EMAILID_CHECK(string Id) { Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); Property p1 = new Property(); p1.Condition1 = Id; p1.Condition2 = ""; p1.onTable = "EMAIL_CHECK"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); if (ds.Tables[0].Rows.Count > 0) { return("Email ID Already Exists."); } else { return("Available"); } }
private void populateYears() { try { Datalayer dl = new Datalayer(); Response res = dl.getallYears(); if (res.success) { String[] YearName = (String[])res.body; cmbselectyear.ItemsSource = YearName; } else if (res.isException) { MessageBox.Show("Exception in populationg the Month names " + res.exception); } } catch (Exception ex) { MessageBox.Show("Exception on the front Page" + ex); } }
public ActionResult Menu(Property p) { Datalayer dl = new Datalayer(); try { p.id = "0"; if (dl.INSERT_MENU(p) > 0) { TempData["MSG"] = "Record Saved Successfully!"; ModelState.Clear(); } } catch (Exception ex) { TempData["MSG"] = ex.ToString(); } return(RedirectToAction("Menu")); }
public ActionResult Menu() { Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); Property p1 = new Property(); p1.Condition1 = ""; p1.Condition2 = ""; p1.Condition3 = ""; p1.onTable = "MAIN_MENU"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); List <Property> Menu = new List <Property>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Property p = new Property(); p.id = ds.Tables[0].Rows[i]["id"].ToString(); p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString(); p.Position = ds.Tables[0].Rows[i]["Position"].ToString(); p.Status = ds.Tables[0].Rows[i]["Status"].ToString(); Menu.Add(p); } } else { Property p = new Property(); p.id = "0"; p.Menu = "NONE"; p.Position = "NONE"; p.Status = "NONE"; Menu.Add(p); } ViewBag.MenuList = Menu; return(View()); }
public void HomeContent(string Id) { Property p = new Property(); Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); p.Condition1 = Id; p.Condition2 = ""; p.Condition3 = ""; p.onTable = "FETCH_HOME_CONTENT"; ds = dl.FETCH_CONDITIONAL_QUERY(p); List <Property> Detail = new List <Property>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { p.id = ds.Tables[0].Rows[i]["id"].ToString(); p.Title = ds.Tables[0].Rows[i]["Title"].ToString(); p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString(); p.Description = ds.Tables[0].Rows[i]["Description"].ToString(); p.ThumbImgURL = ds.Tables[0].Rows[i]["ThumbImgURL"].ToString().Replace("~", ""); p.ImgURL = ds.Tables[0].Rows[i]["ImgURL"].ToString().Replace("~", ""); Detail.Add(p); } } else { p.id = "0"; p.Title = "NONE"; p.Menu = "NONE"; p.Description = "NONE"; Detail.Add(p); } ViewBag.contentlist = Detail; }
private void populateMonths() { try { Datalayer dl = new Datalayer(); Response res = dl.getallMonths(); if (res.success) { String[] Monthnames = (String[])res.body; cmbselectMonth.ItemsSource = Monthnames; //cmbselectMonth.DisplayMemberPath = "Monthnames"; } else if (res.isException) { MessageBox.Show("Exception in populationg the Month names " + res.exception); } } catch (Exception ex) { MessageBox.Show("Exception on the front Page" + ex); } }
public ActionResult Detail(string id) { ListMenu(); Property p1 = new Property(); DataSet ds = new DataSet(); Datalayer dl = new Datalayer(); try { p1.Condition1 = id; } catch { p1.Condition1 = ""; } p1.Condition2 = ""; p1.Condition3 = ""; p1.onTable = "FETCH_DETAIL"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); if (ds.Tables[0].Rows.Count > 0) { TempData["Found"] = "1"; var info = new collegedaze.Models.Property() { id = ds.Tables[0].Rows[0]["id"].ToString(), Title = ds.Tables[0].Rows[0]["Title"].ToString(), Description = ds.Tables[0].Rows[0]["Description"].ToString(), ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString().Replace("~", ""), }; return(View(info)); } else { TempData["MSG"] = "Invalid ID!!!"; return(Redirect("/")); } }
public String LoginCheck(String username, String password) { Datalayer dl = new Datalayer(); MySqlDataReader dr = dl.LoginCheck(username, password); if (dr.Read()) { Global.GlobalVar = dr["SSN"].ToString(); if (dr["Type"].Equals("admin")) { return("admin"); } else { return("emp"); } } else { return(null); } }
public void populateEmployees() { try { Datalayer dl = new Datalayer(); Response res = dl.fetchallEmployees(); if (res.success) { List <Employee> employees = (List <Employee>)res.body; cmbEmployees.ItemsSource = employees; cmbEmployees.DisplayMemberPath = "employeeNameToshow"; // cmbEmployeeName.SelectionChanged += cmbEmployeeName_SelectionChanged; } else if (res.isException) { MessageBox.Show("Exception while populating companies : " + res.exception); } } catch (Exception exception) { MessageBox.Show("Exception in populate companies cmb : " + exception); } }
public ActionResult Home() { Property p = new Property(); p.Condition1 = "HOME"; p.Condition2 = ""; p.Condition3 = ""; p.onTable = "HOME_CONTENT"; Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); ds = dl.FETCH_CONDITIONAL_QUERY(p); var home = new collegedaze.Models.Property() { id = ds.Tables[0].Rows[0]["id"].ToString(), Title = ds.Tables[0].Rows[0]["Title"].ToString(), Description = ds.Tables[0].Rows[0]["Description"].ToString(), }; return(View(home)); }
public void SliderBag() { Property p = new Property(); Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); p.Condition1 = "9"; p.Condition2 = ""; p.Condition3 = ""; p.onTable = "FETCH_HOME_CONTENT"; ds = dl.FETCH_CONDITIONAL_QUERY(p); List <Property> Photo = new List <Property>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Property p1 = new Property(); p1.id = ds.Tables[0].Rows[i]["id"].ToString(); p1.Title = ds.Tables[0].Rows[i]["Title"].ToString(); p1.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString(); p1.Description = ds.Tables[0].Rows[i]["Description"].ToString(); p1.ImgURL = ds.Tables[0].Rows[i]["ImgURL"].ToString().Replace("~", ""); Photo.Add(p1); } } else { Property p1 = new Property(); p1.id = "0"; p1.Title = "NONE"; p1.Description = "NONE"; Photo.Add(p1); } ViewBag.SliderList = Photo; }
//returns two 'out' parameters = the custom session details and the user session details, which can be used with //both SDKs public static bool LoginToAquariumAndCreateUserAndCustomSDKHelpersInSession(out Datalayer.Xero.Interresolve.AquariumUserManagement.SessionDetails userSession, Datalayer.Xero.Interresolve.AquariumCustomProcessing.SessionDetails customSession ) { try { AquariumLogin login = new AquariumLogin(); login.LoginToAquarium(); LoggedOnUserResult theUserResult = login.GetLoggedOnUserResult(); Datalayer.Xero.Interresolve.AquariumUserManagement.SessionDetails sessionDetails = new Datalayer.Xero.Interresolve.AquariumUserManagement.SessionDetails(); //set this from the logon //set the USER sesson sessionDetails.SessionKey = theUserResult.SessionKey; sessionDetails.Username = theUserResult.Username; sessionDetails.ThirdPartySystemId = 29; userSession = sessionDetails; //assign out param //map a custom session Datalayer.Xero.Interresolve.AquariumCustomProcessing.SessionDetails customSessionDetails = new Datalayer.Xero.Interresolve.AquariumCustomProcessing.SessionDetails(); customSessionDetails.SessionKey = sessionDetails.SessionKey; customSessionDetails.ThirdPartySystemId = 29; customSessionDetails.Username = theUserResult.Username; customSession = customSessionDetails; //assign out param return true; } catch (Exception ex) { throw ex; } }
public ActionResult Delete() { Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); Property p1 = new Property(); string str = ""; p1.ImgURL = ""; p1.ThumbImgURL = ""; p1.id = Request.QueryString["id"].ToString(); p1.Condition1 = Request.QueryString["id"].ToString(); p1.Condition2 = ""; p1.Condition3 = ""; if (Request.QueryString["type"].ToString() == "Content") { p1.onTable = "CONTENT_EDIT"; str = "DELETE FROM tbl_Content WHERE id='" + p1.id + "'"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); if (ds.Tables[0].Rows.Count > 0) { p1.ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString(); p1.ThumbImgURL = ds.Tables[0].Rows[0]["ThumbImgURL"].ToString(); } string completIMG = Server.MapPath(p1.ImgURL); string completeThumb = Server.MapPath(p1.ThumbImgURL); try { if (System.IO.File.Exists(completIMG)) { System.IO.File.Delete(completIMG); } if (System.IO.File.Exists(completeThumb)) { System.IO.File.Delete(completeThumb); } } catch (Exception ex) { TempData["MSG"] = ex.ToString(); } } else if (Request.QueryString["type"].ToString() == "Contact") { p1.onTable = "CONTENT_EDIT"; str = "DELETE FROM tbl_Contact WHERE id='" + p1.id + "'"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); } else if (Request.QueryString["type"].ToString() == "Multiple") { p1.onTable = "MULTIPLE_URL"; str = "DELETE FROM tbl_Multiple WHERE id='" + p1.id + "'"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); if (ds.Tables[0].Rows.Count > 0) { p1.ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString(); p1.ThumbImgURL = ds.Tables[0].Rows[0]["ThumbImgURL"].ToString(); } string completIMG = Server.MapPath(p1.ImgURL); string completeThumb = Server.MapPath(p1.ThumbImgURL); try { if (System.IO.File.Exists(completIMG)) { System.IO.File.Delete(completIMG); } if (System.IO.File.Exists(completeThumb)) { System.IO.File.Delete(completeThumb); } } catch (Exception ex) { TempData["MSG"] = ex.ToString(); } } else { p1.onTable = ""; str = ""; } SqlConnection con = new SqlConnection(p1.Con); con.Open(); try { SqlCommand cmd = new SqlCommand(str, con); int i = cmd.ExecuteNonQuery(); if (i > 0) { TempData["MSG"] = "Data Deleted Successfully!!!"; } else { TempData["MSG"] = "Record Not Deleted."; } } catch (Exception ex) { TempData["MSG"] = ex.ToString(); } con.Close(); if (Request.QueryString["type"].ToString() == "Content") { return(RedirectToAction("List", "Content")); } else if (Request.QueryString["type"].ToString() == "Contact") { return(RedirectToAction("Contact", "Content")); } else if (Request.QueryString["type"].ToString() == "Multiple") { return(RedirectToAction("Multiple", "Content")); } else { return(RedirectToAction("Index", "Admin")); } }
public void DeleteRow(String table, String col, String val) { Datalayer dl = new Datalayer(); dl.DeleteRow(table, col, val); }
public ActionResult Delete() { Datalayer dl = new Datalayer(); DataSet ds = new DataSet(); Property p1 = new Property(); string str = ""; p1.ImgURL = ""; p1.ThumbImgURL = ""; p1.id = Request.QueryString["id"].ToString(); p1.Condition1 = Request.QueryString["id"].ToString(); p1.Condition2 = ""; p1.Condition3 = ""; if (Request.QueryString["type"].ToString() == "Menu") { p1.onTable = ""; str = "DELETE FROM tbl_Menu WHERE id='" + p1.id + "'"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); } else if (Request.QueryString["type"].ToString() == "SubMenu") { p1.onTable = ""; str = "DELETE FROM tbl_SubMenu WHERE id='" + p1.id + "'"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); } else if (Request.QueryString["type"].ToString() == "SubMenuLevel") { p1.onTable = ""; str = "DELETE FROM tbl_SubMenu_Level2 WHERE id='" + p1.id + "'"; ds = dl.FETCH_CONDITIONAL_QUERY(p1); } else { p1.onTable = ""; str = ""; } SqlConnection con = new SqlConnection(p1.Con); con.Open(); try { SqlCommand cmd = new SqlCommand(str, con); int i = cmd.ExecuteNonQuery(); if (i > 0) { TempData["MSG"] = "Data Deleted Successfully!!!"; } else { TempData["MSG"] = "Record Not Deleted."; } } catch (Exception ex) { TempData["MSG"] = ex.ToString(); } con.Close(); if (Request.QueryString["type"].ToString() == "Menu") { return(RedirectToAction("Menu", "Settings")); } else if (Request.QueryString["type"].ToString() == "SubMenu") { return(RedirectToAction("SubMenu", "Settings")); } else if (Request.QueryString["type"].ToString() == "SubMenuLevel") { return(RedirectToAction("SubMenuLevel2", "Settings")); } else { return(RedirectToAction("Index", "Admin")); } }
public Datalayer.Models.User AddUpdate(Datalayer.Models.User user, UserType type = UserType.User) { return _userRepository.AddUpdate(user, type); }