Dot Net team at OffshoreSoftwareDevelopmentIndia.com has developed Microsoft SharePoint Server Mini Calendar Webpart. This MOSS 2007 Mini Calendar Webpart allows administrator to select any of the list to configure with the calendar. Calendar displays all the tasks, events in the calendar. Upon selecting the list, all the events/tasks will show in Mini calendar by highlighted background to the date. On mouse hover to that date, a popup will appear with all the events/tasks for that day. On clicking that link of the events/tasks, the page will redirect to that task/event page.

It is easy to install. Easy to configure. With rich functionalities.

Working with MOSS Mini Calendar:

There is often need to share information about important dates, appointments and meetings. The MOSS Mini Calendar provides all information.

When you import MOSS Mini Calendar on site it looks like as follows:

(Fig. 1)

When click on Modify Shared Web Part (right top corner) of Fig. 1, it looks like as follows:

( Fig. 2 )

What you see on right side of Fig. 2 are custom properties of the mini calendar.

1. About us: When click on this, it displays company details in popup window.
2. Select a list: It contains variety of contents like documents, form and templates, master page gallery, web part gallery etc.
3. Select a display column: It contains different columns like name, title, created by, modify by related to selected list item. What you want to display on calendar please select from this list.
4. Select a view to filter calendar items: select which items to display related to calendar item.
5. Select a date column to base the calendar on: Means which items to display related to date column (e.g. created, modify).
6. Select a Background Color: It sets calendar date cells background color.
7. Select a Body Text Color: It sets calendar date cells text color.
8. Select a Border Color: It sets calendar border color. It also sets calendar?s title back color.
9. Select a Border Font Color: It sets calendar?s title fore color.
10. Select a Highlight Color: It sets color on that cells where there are some events display in popup window by moving mouse over on cell as follow-



11. Select a Highlight Font Color:



12. Select a Day Header Background Color: It sets the calendar?s day header background color.



13. Select a Day Header Fore Color: It sets the calendar?s day header font color.



By setting all above properties, click on OK button it display as Fig.1. Now When you take mouse over the highlight cell it display popup window as follow ?



When click on any items it goes to that particular page.

Calender Webpart Configuration: Webpart Properties













Prerequisites:

1. We need to make sure that timer job is running from:

Administrative Tools >> Services >> Windows SharePoint Services Timer



If service is not started please start it.

2. Check whether solution is deployed or not.

From - Central administration >> Operations >> Solutions



3. If it is deployed then they can go ahead and activate feature manually by going to site collection

Site Actions >> Site Settings >> Modify All Site Settings >> Site Collection Features.



Bookmark It



Hide Sites

Dot Net team at OffshoreSoftwareDevelopmentIndia.com has created many Extensions for Microsoft Office Accounting. Here you will find how to create Microsoft Office Accounting extension.

Create Application Extension for Microsoft Office Accounting:

You can create your own application which can be integrated to your accounting company. You need to follow given steps for creating New Application which can be integrated to MOA.

Assumption: You might have created your company in MSOA and you have to pass company name in step - 9 at the place of “yourCompany.sbc”.

1. Create Windows based Project.
2. You have to add references of following DLLS.
   • ILoader: c:\WINDOWS\assembly\GAC_32\ILoader\2.0.5201.0__31bf3856ad364e35\ILoader.dll
   • SBAIAPI: c:\Program Files\Microsoft Small Business\Small Business Accounting 2007\Assemblies\SBAIAPI.dll
   • SBAIUI: c:\Program Files\Microsoft Small Business\Small Business Accounting 2007\Assemblies\SBAIUI.dll
3. Now you need to Import two namespace for MOA
   - using Microsoft.BusinessSolutions.SmallBusinessAccounting.UI;
   -using Microsoft.BusinessSolutions.SmallBusinessAccounting;
4. Provide the Information related to your Loader
   - const string loaderFULLNAME = “Loader, Version=2.0.5201.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″;
5. Provide the details related to your Assembly
   • const string loaderNAMESPACE = “Microsoft.BusinessSolutions.SmallBusinessAccounting.Loader.Loader”;
6. Create object for ISmallBusinessInstance.(It is an interface so no needs to create New Instance for this
7. Load the assembly which was initialized before.

Assembly assem = Assembly.Load(loaderFULLNAME);

8. Load the assembly which in your system using Loader

ILoader ldr = assem.CreateInstance(loaderNAMESPACE) as ILoader;

9. Create string object and initialize with .sbc file which is stored in Your MYDocument. You can provide other path also.
   • string sbaFile = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) Path.DirectorySeparatorChar + “Small Business Accounting” Path.DirectorySeparatorChar + “Companies” + Path.DirectorySeparatorChar + “yourCompany.sbc”;
10. Load the file in your application using loader.

- sbi = ldr.GetSbaObjects(sbaFile).SmallBusinessInstance as ISmallBusinessInstance

11. Now your sbi object (instance of SmallBusinessInstance) is ready to Use.

Manage customer details using SmallBusinessInstance Object

Now it’s time to implement SmallBusinessInstance object to access the details related to Customers. [sbi is an object of SmallBusinessInstance]

How to view existing customers?

• Create object of DataTable. And initialize the Details of sbi.CustomerAccounts.DataView.Table to the object of DataTable.

• You can use this DataTable object and assign that object to DataSource of GridView or ComboBox to view the details related to Customers.

How to create New Customers?

• Create an object of ICustomerAccount. And assign the value of sbi.CreateCustomerAccount(); ICustomerAccount cust = sbi.CreateCustomerAccount();

• Now you can access the Properties on Customer Account (e.g. Name, Active);

• You cannot access the property of Address, Email and Fax directly from this object you need to create the object of ICustomerVendorAddress , ICustomerVendorEmail and ICustomerVendorFax respectively
  • ICustomerVendorAddress: You have to create object of ICustomerVendorAddress and initialize it. ICustomerVendorAddress address = cust.CustomerVendorAddresses.GetByType(CustomerVendorAddressType.Business); where you can find different CustomerVendorAddressType. Like (Business, Home, Postal, etc) Now you can access the properties of Address.
  • ICustomerVendorEmail: You have to create object of ICustomerVendorAddress and initialize it. ICustomerVendorEmail emailAddress = cust.CustomerVendorEmails.GetByType(CustomerVendorEmailType.Email1); where you can find different CustomerVendorEmailType. Like (Email1, Email2, and Email3). Now you can access the properties of Email
  • ICustomerVendorFax: You have to create object of ICustomerVendorAddress and initialize it. ICustomerVendorFax faxNumber = cust.CustomerVendorFaxes.GetByType(CustomerVendorFaxType.Business); where you can find different CustomerVendorFaxType. Like (Business, Home and Other). Now you can access the properties of Fax.
• Now you can save the Customer. cust.Save();

Manage Payment details using SmallBusinessInstance object Now you can implement the Payment module of customer in following ways.

How to Create New Payment for Customers?

• For payment of customer you have to specify for which customer you need to make payment.
• You need to provide AccountId of customer for Payment.
• Create ICustomerAccount object and initialize it with sbi.CustomerAccounts
  ICustomerAccount cust = (ICustomerAccount)sbi.CustomerAccounts.GetByPrimaryKey(AccountID);
• Create object of ICustomerPayment and initialize it with sbi.CreateCustomerPayment()
  ICustomerPayment payment = sbi.CreateCustomerPayment();
• Now assign the value of payment.Customer as cust
  payment.Customer = cust;
• Now provide the details of Amount.
• And finally save the record
  payment.Save();

Manage Invoice details using SmallBusinessInstance object. You can manage the details of Invoice using the APIs of Microsoft Accounting.

How to View existing Invoice?

• Create object of DataTable. And initialize the Details of sbi.SalesInvoices.DataView.Table to the object of DataTable.
• You can use this DataTable object and assign that object to DataSource of GridView or ComboBox to view the details related to Invoice.

How to create New Invoice?

• For Invoice of customer you have to specify for which customer you need to create invoice.
• You need to provide AccountId of customer for creating Invoice.
• Create object of ISalesInvoice and initialize it with sbi.CreateSalesInvoice(false). ISalesInvoice invoice = sbi.CreateSalesInvoice(false);
• Create object of IItemLine.

IItemLine line;

• Initialize the object of IItemLine with invoice.CreateSalesInvoiceLine(parameters) IItemLine line = invoice.CreateSalesInvoiceLine(DocumentLineType.ContractItemLineType) as IItemLine;
• Now assign the value for LineItem property of IItemLine object line.LineItem = sbi.ItemAccounts.GetByPrimaryKey(ProdId) as IItemAccount;
• Provide the Quantity and other details of IItemAccount object.
• Finally save the details of Invoice

invoice.Save();

Bookmark It

Hide Sites