private void frmTotalPriceOrders_Load(object sender, EventArgs e)
{
InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[1];
//Current Data
PersianCalendar pcalender = new PersianCalendar();
string year, month, day;
year = pcalender.GetYear(DateTime.Now).ToString();
month = pcalender.GetMonth(DateTime.Now).ToString();
day = pcalender.GetDayOfMonth(DateTime.Now).ToString();
if (month.Length == 1)
{
month = "0" + month;
}
if (day.Length == 1)
{
day = "0" + day;
}
toolStripStatusLabel4.Text = year + "/" + month + "/" + day;
//
FarsiLibrary.Win.Controls.FAMonthView fa = new FarsiLibrary.Win.Controls.FAMonthView();
fa.DefaultCalendar = fa.PersianCalendar;
fa.DefaultCulture = fa.PersianCulture;
//
}
private void Orders_Load(object sender, EventArgs e)
{
InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[1];
FarsiLibrary.Win.Controls.FAMonthView fa = new FarsiLibrary.Win.Controls.FAMonthView();
fa.DefaultCalendar = fa.PersianCalendar;
fa.DefaultCulture = fa.PersianCulture;
PersianCalendar pcalender = new PersianCalendar();
year = pcalender.GetYear(DateTime.Now).ToString();
month = pcalender.GetMonth(DateTime.Now).ToString();
day = pcalender.GetDayOfMonth(DateTime.Now).ToString();
if (month.Length == 1)
{
month = "0" + month;
}
if (day.Length == 1)
{
day = "0" + day;
}
toolStripStatusLabel4.Text = year + "/" + month + "/" + day;
faDatePicker1.Text = year + "/" + month + "/" + day;
//call clear
clear();
//Disable Controls
btn_newproduct.Enabled = false;
btn_save.Enabled = false;
btn_cancel.Enabled = false;
//Create Table
//colomn 1
objcol = new DataColumn("ProductID");
objcol.DataType = System.Type.GetType("System.Int32");
objtable.Columns.Add(objcol);
//column 2
objcol = new DataColumn("SellPrice");
objcol.DataType = System.Type.GetType("System.Int64");
objtable.Columns.Add(objcol);
//column 3
objcol = new DataColumn("Teadad");
objcol.DataType = System.Type.GetType("System.Int32");
objtable.Columns.Add(objcol);
//column 4
objcol = new DataColumn("Discount");
objcol.DataType = System.Type.GetType("System.Single");
objcol.DefaultValue = 0;
objtable.Columns.Add(objcol);
//set Primary kay on ProductID
DataColumn[] PrimaryKeyColumns = new DataColumn[1];
PrimaryKeyColumns[0] = objtable.Columns["ProductID"];
objtable.PrimaryKey = PrimaryKeyColumns;
}
private void frmReportCheque_Load(object sender, EventArgs e)
{
InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[1];
//Current Data
PersianCalendar pcalender = new PersianCalendar();
string year, month, day;
year = pcalender.GetYear(DateTime.Now).ToString();
month = pcalender.GetMonth(DateTime.Now).ToString();
day = pcalender.GetDayOfMonth(DateTime.Now).ToString();
if (month.Length == 1)
{
month = "0" + month;
}
if (day.Length == 1)
{
day = "0" + day;
}
toolStripStatusLabel4.Text = year + "/" + month + "/" + day;
//
FarsiLibrary.Win.Controls.FAMonthView fa = new FarsiLibrary.Win.Controls.FAMonthView();
fa.DefaultCalendar = fa.PersianCalendar;
fa.DefaultCulture = fa.PersianCulture;
//
textBox1.Text = "0";
textBox2.Text = "0";
textBox3.Text = "0";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox14.Text = "0";
textBox15.Text = "0";
textBox16.Text = "0";
textBox8.Text = "0";
textBox9.Text = "0";
textBox10.Text = "0";
textBox11.Text = "0";
textBox12.Text = "";
textBox13.Text = "";
comboBox1.Text = "";
}
private void EditOrders_Load(object sender, EventArgs e)
{
InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[1];
FarsiLibrary.Win.Controls.FAMonthView fa = new FarsiLibrary.Win.Controls.FAMonthView();
fa.DefaultCalendar = fa.PersianCalendar;
fa.DefaultCulture = fa.PersianCulture;
//Current Data
PersianCalendar pcalender = new PersianCalendar();
string year, month, day;
year = pcalender.GetYear(DateTime.Now).ToString();
month = pcalender.GetMonth(DateTime.Now).ToString();
day = pcalender.GetDayOfMonth(DateTime.Now).ToString();
if (month.Length == 1)
{
month = "0" + month;
}
if (day.Length == 1)
{
day = "0" + day;
}
toolStripStatusLabel7.Text = year + "/" + month + "/" + day;
//
//set EnterDetails in DataGridView
AnbarDataContext objBank = new AnbarDataContext();
var query = from table in objBank.OrderDetails
join table2 in objBank.Products on table.ProductID equals table2.ProductID
select new { table.OrderID, table.ProductID, table2.ProductName, table.SellPrice, table.teadad, table.Discount };
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objDataAdapter.SelectCommand.CommandText = query.ToString() + "where OrderID=" + Program.myOrderID + "";
objDataAdapter.Fill(objDataSet, "OrderDetail");
dataGridView1.DataSource = objDataSet.Tables["OrderDetail"];
//Prsentation information in DataGridView
DataGridViewCellStyle objCellStyle = new DataGridViewCellStyle();
objCellStyle.BackColor = Color.WhiteSmoke;
dataGridView1.AlternatingRowsDefaultCellStyle = objCellStyle;
//Column Text to Persian
dataGridView1.Columns[0].HeaderCell.Value = "شماره فاكتور";
dataGridView1.Columns[1].HeaderCell.Value = "كد كالا";
dataGridView1.Columns[2].HeaderCell.Value = "نام كالا";
dataGridView1.Columns[3].HeaderCell.Value = "قيمت فروش";
dataGridView1.Columns[4].HeaderCell.Value = "تعداد صادره";
dataGridView1.Columns[5].HeaderCell.Value = "درصد تخفيف";
if (dataGridView1.SelectedRows.Count != 0)
{
dataGridView1.SelectedRows[0].Selected = false;
}
//
//Customer Code
SqlDataReader objDataReader;
Int32 CustomerID = 0;
objCommand.CommandText = "select CustomerID,[Date] from Orders where OrderID=" + Program.myOrderID + "";
objCommand.Connection = objcon;
objcon.Open();
objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read())
{
CustomerID = Convert.ToInt32(objDataReader[0]);
textBox3.Text = objDataReader[0].ToString();
faDatePicker1.Text = objDataReader[1].ToString();
}
objDataReader.Close();
objCommand.Dispose();
//
//Customer Name
objCommand.CommandType = CommandType.Text;
objCommand.CommandText = "select CustomerName from Customers where CustomerID=" + CustomerID + "";
objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read())
{
lbl_customername.Text = objDataReader[0].ToString();
}
objDataReader.Close();
objCommand.Dispose();
objcon.Close();
if (dataGridView1.SelectedRows.Count != 0)
{
dataGridView1.SelectedRows[0].Selected = false;
}
//call computemablaghkol and Clear TextBoxes
ComputePrice();
Clear();
}
private void frmExitAccountDay_Load(object sender, EventArgs e)
{
FarsiLibrary.Win.Controls.FAMonthView fa = new FarsiLibrary.Win.Controls.FAMonthView();
fa.DefaultCalendar = fa.PersianCalendar;
fa.DefaultCulture = fa.PersianCulture;
}
