public bool ModelNoEditParticularFeilds(ModelNoInfo modelnoinfo)
{
bool isEdit = false;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoEditParticularFeild", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam4 = new SqlParameter();
sprmparam4 = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam4.Value = modelnoinfo.ModelNoId;
sprmparam4 = sccmd.Parameters.Add("@modelNo", SqlDbType.VarChar);
sprmparam4.Value = modelnoinfo.ModelNo;
sprmparam4 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam4.Value = modelnoinfo.Narration;
int inAffectedRows = sccmd.ExecuteNonQuery();
isEdit = (inAffectedRows > 0 && true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
return(isEdit);
}
public ModelNoInfo ModelNoWithNarrationView(decimal decModelNoId)
{
ModelNoInfo modelnoinfo = new ModelNoInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoWithNarrationView", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam2.Value = decModelNoId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
modelnoinfo.ModelNoId = Convert.ToDecimal(((DbDataReader)sdrreader)[0].ToString());
modelnoinfo.ModelNo = ((DbDataReader)sdrreader)[1].ToString();
modelnoinfo.Narration = ((DbDataReader)sdrreader)[2].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(modelnoinfo);
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
ModelNoSP spModelNo = new ModelNoSP();
ModelNoInfo infoModelNo = new ModelNoInfo();
infoModelNo.ModelNo = txtModalNo.Text.Trim();
infoModelNo.Narration = txtNarration.Text.Trim();
infoModelNo.Extra1 = string.Empty;
infoModelNo.Extra2 = string.Empty;
if (spModelNo.ModelCheckIfExist(txtModalNo.Text.Trim().ToString(), 0) == false)
{
decIdForOtherForms = spModelNo.ModelNoAddWithDifferentModelNo(infoModelNo);
if (decIdForOtherForms > 0)
{
Messages.SavedMessage();
Clear();
}
}
else
{
Messages.InformationMessage("Model number already exist");
txtModalNo.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("MN3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void ModelNoEdit(ModelNoInfo modelnoinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam6 = new SqlParameter();
sprmparam6 = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam6.Value = modelnoinfo.ModelNoId;
sprmparam6 = sccmd.Parameters.Add("@modelNo", SqlDbType.VarChar);
sprmparam6.Value = modelnoinfo.ModelNo;
sprmparam6 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam6.Value = modelnoinfo.Narration;
sprmparam6 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam6.Value = modelnoinfo.Extra1;
sprmparam6 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam6.Value = modelnoinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
/// <summary>
/// Function to Update values in ModelNo Table
/// </summary>
/// <param name="modelnoinfo"></param>
public void ModelNoEdit(ModelNoInfo modelnoinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam.Value = modelnoinfo.ModelNoId;
sprmparam = sccmd.Parameters.Add("@modelNo", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.ModelNo;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Extra2;
sccmd.ExecuteNonQuery(); }
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
public bool ModelNoEditParticularFeilds(ModelNoInfo modelnoinfo)
{
bool isEdit = false;
try
{
isEdit = SpModelNo.ModelNoEditParticularFeilds(modelnoinfo);
}
catch (Exception ex)
{
MessageBox.Show("MN4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(isEdit);
}
public decimal ModelNoAddWithDifferentModelNo(ModelNoInfo modelnoinfo)
{
decimal decWork = 0;
try
{
decWork = SpModelNo.ModelNoAddWithDifferentModelNo(modelnoinfo);
}
catch (Exception ex)
{
MessageBox.Show("MN3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decWork);
}
public ModelNoInfo ModelNoWithNarrationView(decimal decModelNoId)
{
ModelNoInfo modelnoinfo = new ModelNoInfo();
try
{
modelnoinfo = SpModelNo.ModelNoWithNarrationView(decModelNoId);
}
catch (Exception ex)
{
MessageBox.Show("MN7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(modelnoinfo);
}
/// <summary>
/// Function to edit
/// </summary>
public void EditFunction()
{
try
{
ModelNoSP spModelNo = new ModelNoSP();
ModelNoInfo infoModelNo = new ModelNoInfo();
infoModelNo.ModelNo = txtModalNo.Text.Trim();
infoModelNo.Narration = txtNarration.Text.Trim();
infoModelNo.Extra1 = string.Empty;
infoModelNo.Extra2 = string.Empty;
infoModelNo.ModelNoId = Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString());
if (txtModalNo.Text != strModelNo)
{
if (spModelNo.ModelCheckIfExist(txtModalNo.Text.Trim(), decModelNo) == false)
{
if (spModelNo.ModelNoEditParticularFeilds(infoModelNo))
{
Messages.UpdatedMessage();
Clear();
}
else if (infoModelNo.ModelNoId == 1)
{
Messages.InformationMessage("Cannot update");
Clear();
txtModalNo.Focus();
}
}
else
{
Messages.InformationMessage("Model number already exist");
txtModalNo.Focus();
}
}
else
{
spModelNo.ModelNoEditParticularFeilds(infoModelNo);
Messages.UpdatedMessage();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("MN4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill controls for update
/// </summary>
public void FillControls()
{
try
{
ModelNoInfo infoModelNo = new ModelNoInfo();
ModelNoSP spModelNo = new ModelNoSP();
infoModelNo = spModelNo.ModelNoWithNarrationView(Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString()));
txtModalNo.Text = infoModelNo.ModelNo;
txtNarration.Text = infoModelNo.Narration;
btnSave.Text = "Update";
btnDelete.Enabled = true;
decModelNo = infoModelNo.ModelNoId;
strModelNo = infoModelNo.ModelNo;
}
catch (Exception ex)
{
MessageBox.Show("MN8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to add modelNo to modelNo table with differnt modelNo
/// </summary>
/// <param name="modelnoinfo"></param>
/// <returns></returns>
public decimal ModelNoAddWithDifferentModelNo(ModelNoInfo modelnoinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoAddWithDifferentModelNo", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@modelNo", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.ModelNo;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Extra2;
decimal decWork=Convert.ToDecimal( sccmd.ExecuteScalar());
if (decWork > 0)
{
return decWork;
}
else
{
return 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return 0;
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to add modelNo to modelNo table with differnt modelNo
/// </summary>
/// <param name="modelnoinfo"></param>
/// <returns></returns>
public decimal ModelNoAddWithDifferentModelNo(ModelNoInfo modelnoinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoAddWithDifferentModelNo", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@modelNo", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.ModelNo;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Extra2;
decimal decWork = Convert.ToDecimal(sccmd.ExecuteScalar());
if (decWork > 0)
{
return(decWork);
}
else
{
return(0);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(0);
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to get particular values from ModelNo table based on the parameter
/// </summary>
/// <param name="modelNoId"></param>
/// <returns></returns>
public ModelNoInfo ModelNoView(decimal modelNoId)
{
ModelNoInfo modelnoinfo = new ModelNoInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam.Value = modelNoId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
modelnoinfo.ModelNoId = Convert.ToDecimal(sdrreader[0].ToString());
modelnoinfo.ModelNo = sdrreader[1].ToString();
modelnoinfo.Narration = sdrreader[2].ToString();
modelnoinfo.ExtraDate = Convert.ToDateTime(sdrreader[3].ToString());
modelnoinfo.Extra1 = sdrreader[4].ToString();
modelnoinfo.Extra2 = sdrreader[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{ sdrreader.Close();
sqlcon.Close(); }
return(modelnoinfo);
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
ModelNoSP spModelNo = new ModelNoSP();
ModelNoInfo infoModelNo = new ModelNoInfo();
infoModelNo.ModelNo = txtModalNo.Text.Trim();
infoModelNo.Narration = txtNarration.Text.Trim();
infoModelNo.Extra1 = string.Empty;
infoModelNo.Extra2 = string.Empty;
if (spModelNo.ModelCheckIfExist(txtModalNo.Text.Trim().ToString(), 0) == false)
{
decIdForOtherForms = spModelNo.ModelNoAddWithDifferentModelNo(infoModelNo);
if (decIdForOtherForms > 0)
{
Messages.SavedMessage();
Clear();
}
}
else
{
Messages.InformationMessage("Model number already exist");
txtModalNo.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("MN3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill controls for update
/// </summary>
public void FillControls()
{
try
{
ModelNoInfo infoModelNo = new ModelNoInfo();
ModelNoSP spModelNo = new ModelNoSP();
infoModelNo = spModelNo.ModelNoWithNarrationView(Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString()));
txtModalNo.Text = infoModelNo.ModelNo;
txtNarration.Text = infoModelNo.Narration;
btnSave.Text = "Update";
btnDelete.Enabled = true;
decModelNo = infoModelNo.ModelNoId;
strModelNo = infoModelNo.ModelNo;
}
catch (Exception ex)
{
MessageBox.Show("MN8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit
/// </summary>
public void EditFunction()
{
try
{
ModelNoSP spModelNo = new ModelNoSP();
ModelNoInfo infoModelNo = new ModelNoInfo();
infoModelNo.ModelNo = txtModalNo.Text.Trim();
infoModelNo.Narration = txtNarration.Text.Trim();
infoModelNo.Extra1 = string.Empty;
infoModelNo.Extra2 = string.Empty;
infoModelNo.ModelNoId = Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString());
if (txtModalNo.Text != strModelNo)
{
if (spModelNo.ModelCheckIfExist(txtModalNo.Text.Trim(), decModelNo) == false)
{
if (spModelNo.ModelNoEditParticularFeilds(infoModelNo))
{
Messages.UpdatedMessage();
Clear();
}
else if (infoModelNo.ModelNoId == 1)
{
Messages.InformationMessage("Cannot update");
Clear();
txtModalNo.Focus();
}
}
else
{
Messages.InformationMessage("Model number already exist");
txtModalNo.Focus();
}
}
else
{
spModelNo.ModelNoEditParticularFeilds(infoModelNo);
Messages.UpdatedMessage();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("MN4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get particular values from ModelNo table based on the parameter with narration
/// </summary>
/// <param name="decModelNoId"></param>
/// <returns></returns>
public ModelNoInfo ModelNoWithNarrationView(decimal decModelNoId)
{
ModelNoInfo modelnoinfo = new ModelNoInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoWithNarrationView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam.Value = decModelNoId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
modelnoinfo.ModelNoId = Convert.ToDecimal(sdrreader[0].ToString());
modelnoinfo.ModelNo = sdrreader[1].ToString();
modelnoinfo.Narration = sdrreader[2].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return modelnoinfo;
}
/// <summary>
/// Function to Update values in ModelNo Table
/// </summary>
/// <param name="modelnoinfo"></param>
/// <returns></returns>
public bool ModelNoEditParticularFeilds(ModelNoInfo modelnoinfo)
{
bool isEdit = false;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ModelNoEditParticularFeild", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@modelNoId", SqlDbType.Decimal);
sprmparam.Value = modelnoinfo.ModelNoId;
sprmparam = sccmd.Parameters.Add("@modelNo", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.ModelNo;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = modelnoinfo.Narration;
int inAffectedRows = sccmd.ExecuteNonQuery();
if (inAffectedRows > 0)
{
isEdit = true;
}
else
{
isEdit = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return isEdit;
}
