public bool UpdateNotesData(NotesTask NotesObject, string Mode, string CustId)
{
bool Update;
try
{
string SqlQuery;
if (Mode == "Update")
{
SqlQuery = "Update Notes Set Date='" + NotesObject.Date + "', Details='" + NotesObject.Details + "' where ID=" + NotesObject.ID;
}
else
{
SqlQuery = "Insert into Notes(CustId, Date, Details) values (" + CustId + ", '" + NotesObject.Date + "', '" + NotesObject.Details + "')";
}
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
public NotesTask GetNotesDataForID(NotesTask NotesObject, string Mode)
{
DataTable NotesTable = new DataTable();
NotesTask ReturnNotesObject = new NotesTask();
try
{
string SqlQuery = "Select nt.* from Notes nt where nt.ID =" + NotesObject.ID.ToString();
NotesTable = objAdaptor.FetchData(SqlQuery);
if (NotesTable != null && NotesTable.Rows.Count == 1)
{
ReturnNotesObject.ID = int.Parse(NotesTable.Rows[0]["ID"].ToString());
ReturnNotesObject.CustID = int.Parse(NotesTable.Rows[0]["CustID"].ToString());
ReturnNotesObject.Date = NotesTable.Rows[0]["Date"].ToString();
ReturnNotesObject.Details = NotesTable.Rows[0]["Details"].ToString();
}
}
catch
{
}
finally
{
}
return(ReturnNotesObject);
}
private void InsertNotes()
{
try
{
bool update = false;
NotesTask NotesObject = new NotesTask();
//NotesObject.CustID = Convert.ToInt32(CustomerComboBox.SelectedItem.Value);
//NotesObject.Date = NCDateTextbox.Text;
NotesObject.Date = NCDateEdit.Text;
NotesObject.Details = NCDetailTextbox.Text;
update = CustomerServiceBL.CustomerDetails.Ins.UpdateNotesData(NotesObject, "Insert", CustomerComboBox.SelectedItem.Value.ToString());
if (update)
{
successDiv.Style.Value = "display: block";
errorDiv1.Style.Value = "display: none";
successDiv.InnerText = "New Notes has been successfully created";
}
else
{
successDiv.Style.Value = "display: none";
errorDiv1.Style.Value = "display: block";
errorDiv1.InnerText = "Notes has NOT been created";
}
}
catch (Exception ex)
{ throw ex; }
finally
{
}
}
public DataTable GetAllNotesData()
{
DataTable NotesDataTable = new DataTable();
NotesTask ReturnObject = new NotesTask();
try
{
string SqlQuery = "Select * from Customer, Notes";
NotesDataTable = objAdaptor.FetchData(SqlQuery);
}
catch (Exception ex)
{
}
finally
{
}
return(NotesDataTable);
}
void SetupDisplay(View view)
{
// setup our message list view
MessagesListView = view.FindViewById <ListView>(Resource.Id.notes_details_list);
MessagesListView.SetOnTouchListener(this);
MessagesListView.Divider = null;
// setup the messages list
MessagesListView.Adapter = new NotesDetailsArrayAdapter(this);
// load the placeholder and series image
SeriesBillboard = null;
bool imageExists = TryLoadBanner(NotesTask.FormatBillboardImageName(Series.SeriesName));
if (imageExists == false)
{
//string widthParam = string.Format( "&width={0}", NavbarFragment.GetContainerDisplayWidth_Landscape( ) );
// use the placeholder and request the image download
FileCache.Instance.DownloadFileToCache(Series.BillboardUrl, NotesTask.FormatBillboardImageName(Series.SeriesName), null,
delegate
{
TryLoadBanner(NotesTask.FormatBillboardImageName(Series.SeriesName));
});
AsyncLoader.LoadImage(PrivateNoteConfig.NotesMainPlaceholder, true, false,
delegate(Bitmap imageBmp)
{
if (FragmentActive == true && imageBmp != null)
{
PlaceholderImage = imageBmp;
RefreshList( );
return(true);
}
return(false);
});
}
}
private void FillNotesDetails(int ID)
{
try
{
NotesTask NotesObject = new NotesTask();
NotesTask ReturnNotes = new NotesTask();
NotesObject.ID = ID;
ReturnNotes = CustomerServiceBL.CustomerDetails.Ins.GetNotesDataForID(NotesObject, "");
if (ReturnNotes != null)
{
NCDateEdit.Date = DateTime.Parse(ReturnNotes.Date.ToString());
//NCDateTextbox.Text = ReturnNotes.Date.ToString();
NCDetailTextbox.Text = ReturnNotes.Details.ToString();
}
}
catch (Exception ex)
{ throw ex; }
finally
{
}
}
public bool UpdateNotesData(NotesTask NotesObject, string Mode, string CustId)
{
return(CustomerTrackingDL.CustomerDetails.Ins.UpdateNotesData(NotesObject, Mode, CustId));
}
public NotesTask GetNotesDataForID(NotesTask NotesObject, string Mode)
{
return(CustomerTrackingDL.CustomerDetails.Ins.GetNotesDataForID(NotesObject, Mode));
}
