/// <summary>
/// Function to Update values in Service Table
/// </summary>
/// <param name="serviceinfo"></param>
/// <returns></returns>
public bool ServiceEdit(ServiceInfo serviceinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ServiceEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@serviceId", SqlDbType.Decimal);
sprmparam.Value = serviceinfo.ServiceId;
sprmparam = sccmd.Parameters.Add("@serviceName", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.ServiceName;
sprmparam = sccmd.Parameters.Add("@serviceCategoryId", SqlDbType.Decimal);
sprmparam.Value = serviceinfo.ServiceCategoryId;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = serviceinfo.Rate;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.Extra2;
int inEffectedRow = sccmd.ExecuteNonQuery();
if (inEffectedRow > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return false;
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Fill controls for Update or delete
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvService_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
ServiceSP spService = new ServiceSP();
ServiceInfo infoService = new ServiceInfo();
decServiceId = Convert.ToDecimal(dgvService.Rows[e.RowIndex].Cells["dgvtxtServiceId"].Value.ToString());
infoService = spService.ServiceView(decServiceId);
txtServiceName.Text = infoService.ServiceName;
cmbCategory.SelectedValue = infoService.ServiceCategoryId.ToString();
txtRate.Text = infoService.Rate.ToString();
txtNarration.Text = infoService.Narration;
txtServiceNameSearch.Text = string.Empty;
cmbCategorySearch.SelectedIndex = 0;
btnSave.Text = "Update";
btnDelete.Enabled = true;
strServiceName = infoService.ServiceName;
txtServiceName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("Ser17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Edit Function
/// </summary>
public void EditFunction()
{
try
{
ServiceSP spService = new ServiceSP();
ServiceInfo infoService = new ServiceInfo();
infoService.ServiceId = Convert.ToDecimal(dgvService.CurrentRow.Cells["dgvtxtServiceId"].Value.ToString());
infoService.ServiceName = txtServiceName.Text.Trim();
infoService.ServiceCategoryId = Convert.ToDecimal(cmbCategory.SelectedValue.ToString());
infoService.Rate = Convert.ToDecimal(txtRate.Text.ToString());
infoService.Narration = txtNarration.Text.Trim();
infoService.Extra1 = string.Empty;
infoService.Extra2 = string.Empty;
if (CheckExistenceOfServiceName() == false)
{
if (spService.ServiceEdit(infoService))
{
Messages.UpdatedMessage();
Clear();
txtServiceName.Focus();
}
}
else
{
Messages.InformationMessage("Already exists");
txtServiceName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("Ser12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
ServiceSP spService = new ServiceSP();
ServiceInfo infoService = new ServiceInfo();
infoService.ServiceName = txtServiceName.Text.Trim();
infoService.ServiceCategoryId = Convert.ToDecimal(cmbCategory.SelectedValue.ToString());
infoService.Rate = Convert.ToDecimal(txtRate.Text.ToString());
infoService.Narration = txtNarration.Text.Trim();
infoService.ExtraDate = PublicVariables._dtCurrentDate;
infoService.Extra1 = string.Empty;
infoService.Extra2 = string.Empty;
if (spService.ServiceCheckExistence(txtServiceName.Text.Trim(), 0) == false)
{
decIdForOtherForms = spService.ServiceAddWithReturnIdentity(infoService);
Messages.SavedMessage();
Clear();
GridFill();
}
else
{
Messages.InformationMessage("Service name already exist");
txtServiceName.Focus();
}
if (frmServiceVoucherObj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Ser11 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Service Search function
/// </summary>
/// <param name="strBrandName"></param>
/// <param name="strCategoryname"></param>
public void ServiceSearch(string strBrandName, string strCategoryname)
{
try
{
ServiceSP spService = new ServiceSP();
ServiceInfo infoService = new ServiceInfo();
DataTable dtblService = new DataTable();
dtblService = spService.ServiceSearch(strBrandName, strCategoryname);
dgvService.DataSource = dtblService;
}
catch (Exception ex)
{
MessageBox.Show("Ser9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On cellvaluechange of dgvServiceVoucher
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvServiceVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
ServiceSP spService = new ServiceSP();
ServiceInfo infoService = new ServiceInfo();
decimal decRate = 0;
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
SerialNo();
if (e.ColumnIndex == dgvServiceVoucher.Columns["dgvcmbParticulars"].Index)
{
if (dgvServiceVoucher.Rows[e.RowIndex].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[e.RowIndex].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty)
{
infoService = spService.ServiceViewForRate(Convert.ToDecimal(dgvServiceVoucher.Rows[e.RowIndex].Cells["dgvcmbParticulars"].Value.ToString()));
decRate = infoService.Rate;
string strAmount = decRate.ToString();
if (strAmount != string.Empty)
{
dgvServiceVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = strAmount;
}
}
}
AmountCalculation();
}
CheckColumnMissing(e);
}
catch (Exception ex)
{
MessageBox.Show("SV 45 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ServiceAddWithReturnIdentity", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@serviceName", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.ServiceName;
sprmparam = sccmd.Parameters.Add("@serviceCategoryId", SqlDbType.Decimal);
sprmparam.Value = serviceinfo.ServiceCategoryId;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = serviceinfo.Rate;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = serviceinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = serviceinfo.Extra2;
decIdentity = Convert.ToDecimal(sccmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
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();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ServiceViewForRate", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@serviceId", SqlDbType.Decimal);
sprmparam.Value = serviceId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
serviceinfo.ServiceName = sdrreader["serviceName"].ToString();
serviceinfo.ServiceCategoryId = decimal.Parse(sdrreader["serviceCategoryId"].ToString());
serviceinfo.Rate = decimal.Parse(sdrreader["rate"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return serviceinfo;
}
