Tag Archives: C#

Create Checked List Box in WPF C#


Checked List box is the combination of Text and Check box. In the C# tool box you have Listbox and Combo box , not the checked listbox.

The Data template become the savior for you. We can create a Data Template for our List box.

In fact Data template can be used to customize the look and feel of the listbox items, what ever you wish.

Let’s add a Simple ListBox with Check box using XAML code which bind the Product List

<ListBox Style="{DynamicResource prent_and_groups_List}"   Background="LightGreen" SelectedItem="SlectedAccount" ItemsSource="{Binding Products}"   Grid.Row="1" Grid.Column="1"  Grid.RowSpan="2" >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <CheckBox IsChecked="{Binding Ischecked}" Content="{Binding Name}" />
                </DataTemplate>
            </ListBox.ItemTemplate>
            
        </ListBox>

C# WPF – Custom Observable String Dictionary for Binding


Observable collection objects come handy when you dealing with Binding controls with values in WPF and C#.Net.

Dictionary object help you to build a collection values using a single dictionary with key, value pair.

With both we can build a custom class for binding and dynamically updated collection, which can be used for multiple purposes, around your projects.

The root : Observable Dictionary

// The orginal class was obtained from official site, then I made some desirable changes such as `UpdateOrAdd`,
// which I think usefull for others
//
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
namespace mynamespace
{
class ObservableDictionary : IDictionary<string, string>, INotifyPropertyChanged
{
//------------------------------------------------------
//
// Constructors
//
//------------------------------------------------------
#region Constructors
/// <summary>
/// Creates a ContentLocatorPart with the specified type name and namespace.
/// </summary>
public ObservableDictionary()
{
_nameValues = new Dictionary<string, string>();
}
#endregion Constructors
//------------------------------------------------------
//
// Public Methods
//
//------------------------------------------------------
#region Public Methods
/// <summary>
/// Adds a key/value pair to the ContentLocatorPart. If a value for the key already
/// exists, the old value is overwritten by the new value.
/// </summary>
/// <param name="key">key</param>
/// <param name="val">value</param>
/// <exception cref="ArgumentNullException">key or val is null</exception>
/// <exception cref="ArgumentException">a value for key is already present in the locator part</exception>
public void Add(string key, string val)
{
if (key == null || val == null)
{
throw new ArgumentNullException(key == null ? "key" : "val");
}
_nameValues.Add(key, val);
FireDictionaryChanged();
}
/// <summary>
/// Removes all name/value pairs from the ContentLocatorPart.
/// </summary>
public void Clear()
{
int count = _nameValues.Count;
if (count > 0)
{
_nameValues.Clear();
// Only fire changed event if the dictionary actually changed
FireDictionaryChanged();
}
}
public void UpdateOrAdd(string key,string value)
{
if (ContainsKey(key) == false)
{
Add(key, value);
}
else
{
Remove(key);
Add(key, value);
}
}
/// <summary>
/// Returns whether or not a value of the key exists in this ContentLocatorPart.
/// </summary>
/// <param name="key">the key to check for</param>
/// <returns>true - yes, false - no</returns>
public bool ContainsKey(string key)
{
return _nameValues.ContainsKey(key);
}
/// <summary>
/// Removes the key and its value from the ContentLocatorPart.
/// </summary>
/// <param name="key">key to be removed</param>
/// <returns>true - the key was found in the ContentLocatorPart, false o- it wasn't</returns>
public bool Remove(string key)
{
bool exists = _nameValues.Remove(key);
// Only fire changed event if the key was actually removed
if (exists)
{
FireDictionaryChanged();
}
return exists;
}
/// <summary>
/// Returns an enumerator for the key/value pairs in this ContentLocatorPart.
/// </summary>
/// <returns>an enumerator for the key/value pairs; never returns null</returns>
IEnumerator IEnumerable.GetEnumerator()
{
return _nameValues.GetEnumerator();
}
/// <summary>
/// Returns an enumerator forthe key/value pairs in this ContentLocatorPart.
/// </summary>
/// <returns>an enumerator for the key/value pairs; never returns null</returns>
public IEnumerator<KeyValuePair<string, string>> GetEnumerator()
{
return ((IEnumerable<KeyValuePair<string, string>>)_nameValues).GetEnumerator();
}
/// <summary>
///
/// </summary>
/// <param name="key"></param>
/// <param name="value"></param>
/// <returns></returns>
/// <exception cref="ArgumentNullException">key is null</exception>
public bool TryGetValue(string key, out string value)
{
if (key == null)
throw new ArgumentNullException("key");
return _nameValues.TryGetValue(key, out value);
}
/// <summary>
///
/// </summary>
/// <param name="pair"></param>
/// <exception cref="ArgumentNullException">pair is null</exception>
void ICollection<KeyValuePair<string, string>>.Add(KeyValuePair<string, string> pair)
{
((ICollection<KeyValuePair<string, string>>)_nameValues).Add(pair);
}
/// <summary>
///
/// </summary>
/// <param name="pair"></param>
/// <returns></returns>
/// <exception cref="ArgumentNullException">pair is null</exception>
bool ICollection<KeyValuePair<string, string>>.Contains(KeyValuePair<string, string> pair)
{
return ((ICollection<KeyValuePair<string, string>>)_nameValues).Contains(pair);
}
/// <summary>
///
/// </summary>
/// <param name="pair"></param>
/// <returns></returns>
/// <exception cref="ArgumentNullException">pair is null</exception>
bool ICollection<KeyValuePair<string, string>>.Remove(KeyValuePair<string, string> pair)
{
return ((ICollection<KeyValuePair<string, string>>)_nameValues).Remove(pair);
}
/// <summary>
///
/// </summary>
/// <param name="target"></param>
/// <param name="startIndex"></param>
/// <exception cref="ArgumentNullException">target is null</exception>
/// <exception cref="ArgumentOutOfRangeException">startIndex is less than zero or greater than the lenght of target</exception>
void ICollection<KeyValuePair<string, string>>.CopyTo(KeyValuePair<string, string>[] target, int startIndex)
{
if (target == null)
throw new ArgumentNullException("target");
if (startIndex < 0 || startIndex > target.Length)
throw new ArgumentOutOfRangeException("startIndex");
((ICollection<KeyValuePair<string, string>>)_nameValues).CopyTo(target, startIndex);
}
#endregion Public Methods
//------------------------------------------------------
//
// Public Operators
//
//------------------------------------------------------
//------------------------------------------------------
//
// Public Events
//
//------------------------------------------------------
//------------------------------------------------------
//
// Public Properties
//
//------------------------------------------------------
#region Public Properties
/// <summary>
/// The number of name/value pairs in this ContentLocatorPart.
/// </summary>
/// <value>count of name/value pairs</value>
public int Count
{
get
{
return _nameValues.Count;
}
}
/// <summary>
/// Indexer provides lookup of values by key. Gets or sets the value
/// in the ContentLocatorPart for the specified key. If the key does not exist
/// in the ContentLocatorPart,
/// </summary>
/// <param name="key">key</param>
/// <returns>the value stored in this locator part for key</returns>
public string this[string key]
{
get
{
if (key == null)
{
throw new ArgumentNullException("key");
}
string value = null;
_nameValues.TryGetValue(key, out value);
return value;
}
set
{
if (key == null)
{
throw new ArgumentNullException("key");
}
if (value == null)
{
throw new ArgumentNullException("value");
}
string oldValue = null;
_nameValues.TryGetValue(key, out oldValue);
// If the new value is actually different, then we add it and fire
// a change notification
if ((oldValue == null) || (oldValue != value))
{
_nameValues[key] = value;
FireDictionaryChanged();
}
}
}
/// <summary>
///
/// </summary>
public bool IsReadOnly
{
get
{
return false;
}
}
/// <summary>
/// Returns a collection of all the keys in this ContentLocatorPart.
/// </summary>
/// <value>keys</value>
public ICollection<string> Keys
{
get
{
return _nameValues.Keys;
}
}
/// <summary>
/// Returns a collection of all the values in this ContentLocatorPart.
/// </summary>
/// <value>values</value>
public ICollection<string> Values
{
get
{
return _nameValues.Values;
}
}
#endregion Public Properties
//------------------------------------------------------
//
// Public Events
//
//------------------------------------------------------
//------------------------------------------------------
//
// Internal Methods
//
//------------------------------------------------------
//------------------------------------------------------
//
// Internal Operators
//
//------------------------------------------------------
//------------------------------------------------------
//
// Internal Events
//
//------------------------------------------------------
#region Public Events
/// <summary>
///
/// </summary>
public event PropertyChangedEventHandler PropertyChanged;
#endregion Public Events
//------------------------------------------------------
//
// Internal Properties
//
//------------------------------------------------------
//------------------------------------------------------
//
// Private Methods
//
//------------------------------------------------------
#region Private Methods
/// <summary>
/// Notify the owner this ContentLocatorPart has changed.
/// </summary>
private void FireDictionaryChanged()
{
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(null));
}
}
#endregion Private Methods
//------------------------------------------------------
//
// Private Fields
//
//------------------------------------------------------
#region Private Fields
/// <summary>
/// The internal data structure.
/// </summary>
private Dictionary<string, string> _nameValues;
#endregion Private Fields
}
}

Our class utilizes two interphases namely Dictionary and INotifyPropertyChanged. The INotifyPropertyChanged and the implemented methods help use to update the data source where the object is binded. As a result when ever the object updated with new values, the control automatically updates.

How to use

Drop the class file to your solution and create an object of our class and also add some values to the dictionary as follows

ObservableDictionary _items = new ObservableDictionary();
_items.UpdateOrAdd("Dev", "Manoj");
_items.UpdateOrAdd("Lan", "C#");
tbl_lan.DataCOntext=_items;
tbl_lan.DataCOntext=_items;

xaml

 <TextBlock x:Name="tbl_dev" TextAlignment="Left" HorizontalAlignment="Left" Text="{Binding [Dev]}" Foreground="LightGoldenrodYellow" />
 <TextBlock x:Name="tbl_lan" TextAlignment="Left" HorizontalAlignment="Left" Text="{Binding [Lan]}" Foreground="LightGoldenrodYellow" />        

Go head and customize the class to meet your requirements

Nullable date with Linq and Model class in C#


In C# Model class you may have experienced a nullable Error while fetching the rows with nullable column from database to your Model objects.

To treat the nullable in proper way , you have to tell your Model class and Linq this is nullable field.

Model class

*The nullable is applied to Value Type .This is not required for string

In the Model class I have a field edate which is in database is a nullable field. I want to make this field nullable in my model

 class StocKBatchModel
    {
        public int B_Id { get; set; }        
        public string Name { get; set; }
        public DateTime? Edate { get; set; }
}

By placing ? after the type of my class property , it becomes nullable. Say the DateTime becomes nullable , I can use the same in Linq in my LInq query as follows

 
var blist = (from m in batch_table.AsEnumerable()                                 
                                 select new
                                 {
                                     obj = new Models.StocKBatchModel()
                                     {
                                         B_Id = m.Field<int>("b_id"),
                                         Name = m.Field<string>("name"),
                                         Edate = m.Field<DateTime?>("exp_date"),                                       
                                 }.obj).ToList();

Hope this will helpful for someone.

Storyboard animation in WPF C#


WPF allows you to customize the look and feel using XAML and Styles, it allow capable of create some cool animation which is a way of interacting with user and UI. You can use Storyboard with EvenTrigger.

Let’s create a style for a textbox control, which add some color, align text etc ,then add a Style trigger and Event trigger which also add some font animation , want to play while the textbox has focus and lost it’s focus.

The Style

It is a simple style, add font, alignment etc Name the style as NuberTex.

 <Style x:Key="NumberText" TargetType="TextBox">
        <Setter Property="FontSize" Value="18"/>
        <Setter Property="TextAlignment" Value="Right"/>   
        

  </Style>    

To use this style add the following lines to the TextBox control (xaml).

 <TextBox  Style="{DynamicResource NumberText}" />

Storyboard

Now we can add a Event trigger and a story board to the above style. First we create a style trigger and then we want to add some style based on Events, namely Gotfocus and Lostfocus.

<Style.Triggers >
            <Trigger Property="IsFocused" Value="True">
                <Setter Property="Foreground" Value="IndianRed"/>
            </Trigger>
            <EventTrigger RoutedEvent="GotFocus">
                <EventTrigger.Actions>
                    <BeginStoryboard>
                        <Storyboard>
                            <DoubleAnimation Duration="0:0:0:1" To="20" Storyboard.TargetProperty="FontSize" From="18"  />
                        </Storyboard>
                    </BeginStoryboard>
                </EventTrigger.Actions>
            </EventTrigger>
            
            <EventTrigger RoutedEvent="LostFocus">
                <EventTrigger.Actions>
                    <BeginStoryboard>
                        <Storyboard>
                            <DoubleAnimation Duration="0:0:0:1" From="20" Storyboard.TargetProperty="FontSize" To="18"  />
                        </Storyboard>
                    </BeginStoryboard>
                </EventTrigger.Actions>
            </EventTrigger>
            
        </Style.Triggers>

The storyboard is added within the trigger action. We used a double animation which increase the font from range of values specified using To and From, you can specify what event property you want to play using Target property.

Complete Style

Here is the full style

<Style x:Key="NumberText" TargetType="TextBox">
        <Setter Property="FontSize" Value="18"/>
        <Setter Property="TextAlignment" Value="Right"/>         
        
        <Style.Triggers >
            <Trigger Property="IsFocused" Value="True">
                <Setter Property="Foreground" Value="IndianRed"/>
            </Trigger>
            <EventTrigger RoutedEvent="GotFocus">
                <EventTrigger.Actions>
                    <BeginStoryboard>
                        <Storyboard>
                            <DoubleAnimation Duration="0:0:0:1" To="20" Storyboard.TargetProperty="FontSize" From="18"  />
                        </Storyboard>
                    </BeginStoryboard>
                </EventTrigger.Actions>
            </EventTrigger>
            
            <EventTrigger RoutedEvent="LostFocus">
                <EventTrigger.Actions>
                    <BeginStoryboard>
                        <Storyboard>
                            <DoubleAnimation Duration="0:0:0:1" From="20" Storyboard.TargetProperty="FontSize" To="18"  />
                        </Storyboard>
                    </BeginStoryboard>
                </EventTrigger.Actions>
            </EventTrigger>
            
        </Style.Triggers>

    </Style>    

Convert Doc file to PDF,XPS,SVG,XML,HTML using Spire in C#


There are many useful libraries around Nuget which can be made your application more productive. We already learned how to create PDF files from a Word Document using Interop and Docx.

Free Spire.Doc offer high performance operation on word documents. You can check the project on Codeplex Achive

Spire offer following feature

  • *Convert Word to PDF
  • *Convert Word to HTML
  • *Convert Word to Image
  • *Convert Word to XML
  • *Convert Word to RTF
  • *Convert Word to EMF
  • *Convert Word to¬†XPS

How to Convert Doc to PDF

Add the library to your project using Nuget Package Manager

Visual Studio 2019 : Nuget Package Manager

How to convert a WordDocument to PDF in C#.Net


Word Document is an essential part of any application, it may help users to prepare reports etc. You can easily create Documents programamatically using Microsoft.Office.Interop.Word Library in C#.Net.

This Library also provide capability of converting document to two another monstly used file format, PDF and XPS. Let’s beggin

Reference Library

First up all add refrence to Microsoft.Office.Interop.Word and Include to the project

Microsoft Visual Studio Reference Manager

Start Converting

using Microsoft.Office.Interop.Word;

and do the following

  • Open the File want to convert with Document constructor
  • Use ExExportAsFixedFormat to convert document into pdf
 Microsoft.Office.Interop.Word.Application appWord = new Microsoft.Office.Interop.Word.Application();
                    var wordDocument = appWord.Documents.Open("mydoc.docx");
                    wordDocument.ExportAsFixedFormat("mydoc.pdf", Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF);
                    wordDocument.Close();
appWord.Quit();

In the similary way you can convert document to XPS too

Ask Masrshal to realease resources

Finally we are no need to hold the Word resources , ask Marshal to release them. Do this when ever you use file resources.

System.Runtime.InteropServices.Marshal.FinalReleaseComObject(appWord);

C# WPF Tips : How to bind array/list elements


Binding is an ideal technique for displaying dybanic content in to application in WPF. Todays tips is about how to bind list/array elements in a C# WPF app.

In my C# code I have specified the binding as follows.

 List<string> myvalues = new List<string>() { "May 2020", "May", "Monday", "25/May/2020" };
txt_month.DataContext=myvalues;

I wan t to bind the second element, that means second element in the list (1th). So lets udjust the xaml bining

 <TextBlock  FontSize="14"   x:Name="txt_month" Text="{Binding [1]}" Foreground="Bisque"/>

We have used ‘[ ]’ to specify the element. If you have array of object you can use [ ] .<member> to specify the public member of the class too.

Create aggregate function using lambda expressions on collectionView in C#


Hope you need this article for updating your skills. As we seen in the last article, we learned about collection view and how to create filters using them. If you miss just take a look at it. To I will help you learn som lambda expression

Lambda experession ?

Lambda expressions permit the creation of anonymous functions with a very concise syntax. I don’t want explain what lambda expression is , I will show you how to use it. For learn more about lambda please visit Richard Carr’s lackwaspBlog ,he had a detailed guide to lambda.

The following is an example of lambda expression.

(params) => expression

let’s jump into the regular salesinformation example. The sales Collection used to store all sales information such as Customer,Date,Amount,tax,discount etc. It may contain many of them, that is why we used collection or List.

We are going to use Agrgregate feature of collectionview object to create lambda function, for find total sale amount ,tax collected etc

 var total_saleAmount = Salescolletionview.Cast<SalesView>()
.Aggregate<SalesView, double>(0, (totalSale, s) => totalSales += s.Amount);

The SaleCollectionView class Hold information about Sales which is in the type of ViewClass. So first up all we can cast the view to SalesView and then invoke Aggregate. The Aggregate functionality of C#.Net let us create anonymous function using lambda expression.

At first we had initialise the output variable and access the Amount property of viewclass and then add it up.

In the similar manner you can operate on other properties of view class.

 var total_tax = Salescolletionview.Cast<SalesView>().
Aggregate<SalesView, double>(0, (tax, s) => tax+= s.Tax);

C#Tips/Tricks – XAML Formating


Do you know , within XAML element of you C# WPF application , the binded data can be formated using string format. For a date field you can use the following style

<TextBlock x:Name="tbl_fy" Text="{Binding [0].f_date1,
 StringFormat={}{0:MMM/dd/yyyy}}" Foreground="Beige"
 FontSize="14" Width="119"/>   

Linq – suming rows,create list of custom fields,create model class object list from data table


Querying data from a data table in .Net is easy with Linq. Linq is a query language which is applicable to all type of objects such as List,Tables etc in .Net . Infact you can simply convert the table data to object like List of generic type or cutom Model class object with Linq operation, in limited sense you can forget loops.

Sum table column

Let’ learn how to simply sum up a column in your data table using Linq.

var comms = (from p in public_members.payroll_posting.AsEnumerable() where p.Field<string>
("eid") == "1001" select p.Field<decimal>("amount")).Sum();

The above linq simply fetch amount from the data table for employee id “1001”. I also place an outer pareanthesis for summing up. The parenthesis come handy when you want to convert the values you selected to Arrays,List or perform aggragate functions like Sum,Count etct

Create List of rows with custom list

LINQ – CREATE LIST OF OBJECTS FROM A DATA TABLE
 var comm_list = (from p in posting.AsEnumerable() where  p.Field<string>("type") == 
"Commission" select new { amount = p.Field<decimal>("amount"), eno = p.Field<int>("pp_no"),
 edate = p.Field<DateTime>("post_date") }).ToList();

I have a table in which I store all employee payments under seperate types. I just want to create a list of commission paid to the employees as new list with custom column which is not exist in the data table .

The select new will create a model class like fields.

Create a list of objects from Linq query

Create list of Objects[Model class] with Linq

Following LinQ will help to build Model class object list from a data table, remember I used myown Model class which I not provided here. Use your own

 var payrolls = (from pp in payroll_entries.AsEnumerable()
                                  join emp in employees.AsEnumerable() on pp.Field<string>("eid") equals emp.Field<string>("eid")
                                  select new
                                  {
                                      p = new PayRollEntryModel()
                                      {
                                          VNO = pp.Field<int>("pe_no").ToString(),
                                          DATE = pp.Field<DateTime>("pe_date"),
                                          Employee = LedgeName(emp.Field<int>("lid")),
                                          EID = Convert.ToInt32(pp.Field<string>("eid")),
                                          CashAccount = LedgeName(pp.Field<int>("crledger")),
                                          Total = string.Format("{0:0.00}", pp.Field<decimal>("amount")),
                                          CrACID = Convert.ToInt32( pp.Field<int>("cash_ac")),
                                          Narration = pp.Field<string>("narration"),
                                          DrAcid = Convert.ToInt32( emp.Field<int>("lid")),                                         
                                          Allownaces=pp.Field<string>("allowances"),
                                          Commission=pp.Field<string>("comm"),
                                          Advance=pp.Field<string>("advance"),
                                          Basic=pp.Field<string>("bp"),
                                          Deductions=pp.Field<string>("deductions"),
                                          WDs= pp.Field<decimal>("wdays").ToString() ,
                                          WHs=  pp.Field<decimal>("whours").ToString(),                                       


                                      }
                                  }.p).ToList<PayRollEntryModel>();

At the 26th line of the above code I used .p because the linq only create a list of p which is a anonimous type. I want is a list of the Model class object which is PayRollEntryModel.

I think this will help somebody out there… leave comment and share your thoughts

All the examples I demonstrated here is part of my personal project and I should say these are working very well.

Advertisements