این توابع منه:
private bool SuiterInsertValue()
{
UseDate ud = new UseDate();
try
{
SqlConnection objconnection =
new SqlConnection(clsForms.ConnectionString);
SqlCommand objcommand1 = new SqlCommand();
objcommand1.Connection = objconnection;
objcommand1.CommandText = @"INSERT INTO tblServisRequest(
Username, UnitName, SubmitDate, SendTo, TimeSabt)
VALUES(
@Username, @UnitName, @SubmitDate, @SendTo, @TimeSabt)";
objcommand1.Parameters.AddWithValue("@username", Program.Username);
objcommand1.Parameters.AddWithValue("@UnitName", txtUnitName.Text);
objcommand1.Parameters.AddWithValue("@SubmitDate", lblDate.Text);
objcommand1.Parameters.AddWithValue("@SendTo", lblUsernameDarkhast.Text);
objcommand1.Parameters.AddWithValue("@TimeSabt", ud.TimeEightCharacter().ToString());
objconnection.Open();
objcommand1.ExecuteNonQuery();
objconnection.Close();
return true;
}
catch (Exception)
{
return false;
}
}
private bool ServisesInsertValues()
{
try
{
int servisRequestID = GetFinalIDas();
SqlConnection objconnection =
new SqlConnection(clsForms.ConnectionString);
SqlCommand objcommand1 = new SqlCommand();
objcommand1.Connection = objconnection;
objconnection.Open();
objcommand1.CommandText = @"INSERT INTO tblServisRequestServises(
ServisDesc, Amount, Unit,
Survy, UseDesc, ServisRequestID)
VALUES(
@ServisDesc, @Amount, @Unit,
@Survy, @UseDesc, @ServisRequestID)";
for (int i = 0; i < dgvServisRequestServises.Rows.Count - 1; i++)
{
objcommand1.Parameters.Clear();
objcommand1.Parameters.AddWithValue("@ServisDesc", dgvServisRequestServises.Rows[i].Cells["Desc"].Value.ToString());
objcommand1.Parameters.AddWithValue("@Amount", dgvServisRequestServises.Rows[i].Cells["Count"].Value.ToString());
objcommand1.Parameters.AddWithValue("@Unit", dgvServisRequestServises.Rows[i].Cells["Unit"].Value.ToString());
objcommand1.Parameters.AddWithValue("@Survy", dgvServisRequestServises.Rows[i].Cells["CalculatePrice"].Value.ToString());
if (dgvServisRequestServises.Rows[i].Cells["Column1"].Value == null)
objcommand1.Parameters.AddWithValue("@UseDesc", "");
else
objcommand1.Parameters.AddWithValue("@UseDesc", dgvServisRequestServises.Rows[i].Cells["Column1"].Value.ToString());
objcommand1.Parameters.AddWithValue("@ServisReques tID", servisRequestID);
objcommand1.ExecuteNonQuery();
}
objconnection.Close();
return true;
}
catch (Exception)
{
return false;
}
}
private bool ServisesInsertPeigiri()
{
clsForms Forms = new clsForms();
peigiri = GetFinalID();
peigiris = peigiri.ToString() + "/" + "27";
if (Forms.AddPeigiriCode(peigiri, peigiris, "tblServisRequest"))
{
return true;
}
else
{
return false;
}
}
public bool AddPeigiriCode(int p, string pc, string TableName)
{
try
{
SqlConnection objconnection =
new SqlConnection(clsForms.ConnectionString);
SqlCommand objcommand1 = new SqlCommand();
objcommand1.Connection = objconnection;
string str = @"UPDATE " + TableName + " SET PeigiriCode = @PeigiriCode WHERE ID = " + p;
objcommand1.CommandText = str;
objcommand1.Parameters.AddWithValue("@PeigiriCode" , pc);
objconnection.Open();
objcommand1.ExecuteNonQuery();
objconnection.Close();
return true;
}
catch (Exception)
{
return false;
}
}
private bool InsertTableNameAndCode()
{
clsForms Forms = new clsForms();
int lidd = GetFinalID();
if (Forms.AddFormNameAndPeigiriCode("frmDarkhastAnjam Khadamat", peigiris, lidd, "انجام خدمات"))
{
return true;
}
else
{
return false;
}
}
public bool AddFormNameAndPeigiriCode(string FormName, string pc, int iidd, string FormNameFarsi)
{
UseDate ud = new UseDate();
try
{
SqlConnection objconnection =
new SqlConnection(clsForms.ConnectionString);
SqlCommand objcommand1 = new SqlCommand();
objcommand1.Connection = objconnection;
objcommand1.CommandText = @"INSERT INTO tblPeigiriCode(
FormNameName, PeigiriCodeCode, peigiriid, FormNameNameFarsi, DateDate, SuiterUsername, TimeSabt)
VALUES(
@FormNameName, @PeigiriCodeCode, @peigiriid, @FormNameNameFarsi, @DateDate, @SuiterUsername, @TimeSabt)";
objcommand1.Parameters.AddWithValue("@FormNameName ", FormName);
objcommand1.Parameters.AddWithValue("@PeigiriCodeC ode", pc);
objcommand1.Parameters.AddWithValue("@peigiriid", iidd);
objcommand1.Parameters.AddWithValue("@FormNameName Farsi", FormNameFarsi);
objcommand1.Parameters.AddWithValue("@DateDate", ud.GhamariToShamsi());
objcommand1.Parameters.AddWithValue("@SuiterUserna me", Program.Username);
objcommand1.Parameters.AddWithValue("@TimeSabt", ud.TimeEightCharacter().ToString());
objconnection.Open();
objcommand1.ExecuteNonQuery();
objconnection.Close();
return true;
}
catch (Exception)
{
return false;
}
}