private void LoadRecords() { dgDetails.Rows.Clear(); eVariable.DisableGridColumnSort(dgDetails); if (oFindOption == FIND_OPTION.AUTHOR) { AuthorStructure(); oAuthor = new DataAccess.Author(); foreach (DataRow row in oAuthor.GetAuthor(cboSearch.Text, txtSearch.Text).Rows) { dgDetails.Rows.Add(row[0].ToString(), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString()); } } else if (oFindOption == FIND_OPTION.CATEGORY) { CategoryStructure(); oCategory = new DataAccess.Category(); foreach (DataRow row in oCategory.GetCategory(cboSearch.Text, txtSearch.Text).Rows) { dgDetails.Rows.Add(row[0].ToString(), row[1].ToString(), row[2].ToString()); } } else if (oFindOption == FIND_OPTION.LOCATION) { LocationStructure(); oLocation = new DataAccess.Location(); foreach (DataRow row in oLocation.GetLocationRecord(cboSearch.Text, txtSearch.Text).Rows) { dgDetails.Rows.Add(row[0].ToString(), row[1].ToString(), row[2].ToString()); } } }
public static Location Map(DataAccess.Location location) => new Location { LocId = location.Id, StreetAddress = location.Street, City = location.City, State = location.State, Zip = location.Zip };
public DataAccess.Location ToDataAccessModel(DataAccess.Location daLoc = null) { if (daLoc == null) { daLoc = new DataAccess.Location(); } daLoc.Id = this.Id; daLoc.Name = this.Name; daLoc.ImportanceCategory = this.ImportanceCategory; daLoc.Latitude = this.Latitude; daLoc.Longitude = this.Longitude; return daLoc; }
public void LoadLocation() { try { oLocation = new DataAccess.Location(); dgDetails.Rows.Clear(); eVariable.DisableGridColumnSort(dgDetails); foreach (DataRow row in oLocation.GetLocationRecord("", "").Rows) { dgDetails.Rows.Add(row[0], row[1], row[2]); } } catch (Exception ex) { } }
private void btnSave_Click(object sender, EventArgs e) { oMLocation = new Model.Location(); oLocation = new DataAccess.Location(); if (eVariable.IsFieldEmpty(pnlBody)) { oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.ALL_FIELDS_ARE_REQUIRED.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); return; } if (eVariable.m_ActionType == eVariable.ACTION_TYPE.EDIT) { oMLocation.LOCATION_ID = eVariable.sUniqueID; oMLocation.LOCATION = txtLocation.Text; oMLocation.STATUS = chkActive.Checked == true ? "ACTIVE" : "INACTIVE"; oLocation.UpdateCategory(oMLocation); } else { oMLocation.LOCATION = txtLocation.Text; oMLocation.STATUS = chkActive.Checked == true ? "ACTIVE" : "INACTIVE"; if (oLocation.isRecordExists(oMLocation)) { oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.RECORD_IS_ALREADY_EXISTS.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); return; } oLocation.InsertLocation(oMLocation); } oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.RECORD_HAS_BEEN_SUCESSFULLY_SAVED.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); eVariable.ClearText(pnlBody); LoadLocation(); }
// Location public static Library.Location Map(DataAccess.Location location) => new Library.Location { Id = location.LocationId };