/// <summary>
 /// Function to insert values to Service Table and return the Curresponding row's Id
 /// </summary>
 /// <param name="serviceinfo"></param>
 /// <returns></returns>
 public decimal ServiceAddWithReturnIdentity(ServiceInfo serviceinfo)
 {
     decimal decIdentity = 0;
     try
     {
         decIdentity = spService.ServiceAddWithReturnIdentity(serviceinfo);
     }
     catch (Exception ex)
     {
         MessageBox.Show("AL35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     return decIdentity;
 }
 /// <summary>
 /// Function to get particular values from Service Table based on the parameter
 /// </summary>
 /// <param name="serviceId"></param>
 /// <returns></returns>
 public ServiceInfo ServiceViewForRate(decimal serviceId)
 {
     ServiceInfo serviceinfo = new ServiceInfo();
     try
     {
         serviceinfo = spService.ServiceViewForRate(serviceId);
     }
     catch (Exception ex)
     {
         MessageBox.Show("AL35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     return serviceinfo;
 }
 /// <summary>
 /// Function to Update values in Service Table
 /// </summary>
 /// <param name="serviceinfo"></param>
 /// <returns></returns>
 public bool ServiceEdit(ServiceInfo serviceinfo)
 {
     bool isEdit = false;
     try
     {
         isEdit = spService.ServiceEdit(serviceinfo);
     }
     catch (Exception ex)
     {
         MessageBox.Show("AL35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     return isEdit;
 }