public void LoadDetailsData(string code)
{
DataTable dt = Connstring.SqlDataTable(@"SELECT Item AS 'Item Name', Quantity, 'Remove' AS Action
FROM dbo.OrderItem
WHERE (OrderNo = '" + code + "')");
dgvOrderData.DataSource = dt;
dgvOrderData.Columns[0].Width = 212;
}
private void btnSave_Click(object sender, EventArgs e)
{
string Code = txtOrderNo.Text;
if (Code != "")
{
DataTable dt = Connstring.SqlDataTable(@"SELECT COUNT(*) AS CheckData FROM [dbo].[Order] WHERE (OrderNo = N'" + Code + "')");
int CheckData = Convert.ToInt32(dt.Rows[0]["CheckData"].ToString());
if (CheckData == 0)
{
string CustomerName = txtCustomerName.Text;
string strDate = txtDate.Value.ToString("yyyy-MM-dd");
if (CustomerName != "" && strDate != "0")
{
string sql = @"INSERT INTO dbo.[Order]
(OrderNo, Date, CustomerName)
VALUES (@OrderNo,@Date,@CustomerName)";
SqlCommand MyCommand = new SqlCommand(sql, Connstring.conn);
MyCommand.Parameters.AddWithValue("@OrderNo", Code);
MyCommand.Parameters.AddWithValue("@Date", strDate);
MyCommand.Parameters.AddWithValue("@CustomerName", CustomerName);
Connstring.conn.Open();
int Result = MyCommand.ExecuteNonQuery();
Connstring.conn.Close();
if (Result == 1)
{
SaveDetailsData(Code);
lblMessage.Text = "Successfully saved.";
}
else
{
MessageBox.Show("Save failed.");
}
}
else
{
lblMessage.Text = "Please fill all required fields.";
}
}
else
{
MessageBox.Show("Already exist.");
}
}
else
{
MessageBox.Show("Please select code.");
}
}
//Genarate XML and insert into another table one by one row.
public bool DBtoXML()
{
try
{
int count = 0;
DataTable dt = Connstring.SqlDataTable(@"SELECT id, name, age
FROM dbo.Users");
List <User> Users = new List <User>();
if (dt.Rows.Count < 1)
{
MessageBox.Show("No data found");
return(false);
}
foreach (DataRow row in dt.Rows)
{
var user = new User();
int id;
int age;
int.TryParse(row["id"].ToString(), out id);
user.Name = row["name"].ToString();
int.TryParse(row["age"].ToString(), out age);
user.Age = age.ToString();
var XmlData = XmlManager.SerializetoXML <User>(user);
string sql = @"INSERT INTO dbo.[Xml]
(xmldata, userID)
VALUES (@XmlData, @userID)";
SqlCommand MyCommand = new SqlCommand(sql, Connstring.conn);
MyCommand.Parameters.AddWithValue("@XmlData", XmlData);
MyCommand.Parameters.AddWithValue("@userID", id);
Connstring.conn.Open();
int Result = MyCommand.ExecuteNonQuery();
Connstring.conn.Close();
if (Result == 1)
{
count++;
label2.Text = count + " data updated";
}
else
{
label2.Text = "Data Sync failed";
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
//.........Auto selected value for Press combobox(dropdown).........
private void GetPressCodeData()
{
DataTable dt = Connstring.SqlDataTable(@"SELECT [Press Code] AS Code, [Press Name] AS Name
FROM prd.[Press Info]");
DataRow Drw;
Drw = dt.NewRow();
Drw.ItemArray = new object[] { 0, " Please Select " };
dt.Rows.InsertAt(Drw, 0);
cboPressCode.ValueMember = "Code";
cboPressCode.DisplayMember = "Name";
cboPressCode.DataSource = dt;
}
private void Form4_Load(object sender, EventArgs e)
{
db_ppl Connstring = new db_ppl();
DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[hrd].[Employee]");
pplDataGridView1.DataSource = dt;
}
private void Form8_Load(object sender, EventArgs e)
{
db_ppl Connstring = new db_ppl();
DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[dbo].[Users]");
this.pplDataNavigation1.Datatable = dt;
}
//------------
public void voucher_no()
{
try
{
string year = DateTime.Now.ToString("yy");
string month = DateTime.Now.ToString("MM");
string Newmonth = month;
if (month == "11" || month == "12" || month == "10")
{
Newmonth = month;
}
else
{
Newmonth = month.Substring(1);
}
DataTable dt = Connstring.SqlDataTable(@"SELECT MAX(No) AS Max, MONTH(AddDate) AS Month
FROM Inv.OpeningStock
GROUP BY MONTH(AddDate)
HAVING (MONTH(AddDate) = '" + Newmonth + "')");
if (dt.Rows.Count >= 1)
{
string sqldata = dt.Rows[0]["MAX"].ToString();
string[] tokens = sqldata.Split('-');
string middle = tokens[tokens.Length - 2];
string increment = Convert.ToString(Convert.ToInt32(middle.ToString()) + 1);
string zero = "00000";
int get_lengt = zero.Length - increment.Length;
string lenght = zero.Substring(0, get_lengt);
string cash_memo = lenght + increment;
Txt_cash_memo_no.Text = year + "-" + cash_memo + "-" + month;
}
else
{
Txt_cash_memo_no.Text = year + "-" + "00001" + "-" + month;
}
}
catch
{
MessageBox.Show("Database Connection Faild OR User is out of SalesCounter", "Alart", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//btn_save.Enabled = false;
//btn_report.Enabled = false;
}
Connstring.conn.Close();
}
private void btn_save_Click(object sender, EventArgs e)
{
string Code = txtSubjectCode.Text;
string Name = txtSubjectName.Text;
if (Code != "" && Name != "")
{
DataTable dt = Connstring.SqlDataTable(@"SELECT [Subject Code], [Subject Name]
FROM RND.[Subject Information]
WHERE ([Subject Code] = N'" + Code + "') AND ([Subject Name] = N'" + Name + "')");
if (dt.Rows.Count == 0)
{
string sql = @"INSERT
INTO RND.[Subject Information]([Subject Code], [Subject Name])
VALUES (@SubjectCode,@SubjectName)";
SqlCommand MyCommand = new SqlCommand(sql, Connstring.conn);
MyCommand.Parameters.AddWithValue("@SubjectCode", Code);
MyCommand.Parameters.AddWithValue("@SubjectName", Name);
Connstring.conn.Open();
int a = MyCommand.ExecuteNonQuery();
Connstring.conn.Close();
if (a == 1)
{
lbl_sell.Text = "Save Successfully.";
}
else
{
MessageBox.Show("Save Faild.");
}
}
else
{
MessageBox.Show("Already exist.");
}
}
else
{
lbl_sell.Text = "Please fill all required fields.";
}
SubjectList();
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[dbo].[Users]");
BindingSource bs = new BindingSource();
DataNamesMapper <User> mappaer = new DataNamesMapper <User>();
List <User> users = mappaer.Map(dt).ToList();
bs.DataSource = users;
pplNavigation1.BindingSource = bs;
pplNavigation2.BindingSource = bs;
}
public void GenarateHierarchy()
{
var root = new RootItem();
DataTable dt = Connstring.SqlDataTable(@"SELECT [id], RTRIM(LTRIM([name])) AS name, RTRIM(LTRIM([parentID])) AS parentID, weight
FROM [PPLDEV].[dbo].[hierarchy];");
var parents = GetTopLevelRows(dt);
root.nodeStructure = CreateItem(dt, parents);
var serializer = new JavaScriptSerializer();
serializer.RegisterConverters(new JavaScriptConverter[] { new NullPropertiesConverter() });
var json = serializer.Serialize(root);
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[hrd].[Employee]");
BindingSource bs = new BindingSource();
bs.DataSource = dt;
pplNavigation1.BindingSource = bs;
sampleBindingSource = bs;
//var model = this.sampleBindingSource.DataSource as Sample;
//var item = model.Count;
//var AnotherSample = new Sample();
//AnotherSample.Count = "ddddddddd";
//AnotherSample.FirstName = "ddddddddd";
//AnotherSample.LastName = "ddddddddd";
//this.sampleBindingSource.DataSource = AnotherSample;
}
//---Product Category Load
public void Category()
{
try
{
cboCategory.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cboCategory.AutoCompleteSource = AutoCompleteSource.ListItems;
DataTable dataTable = Connstring.SqlDataTable(@"SELECT ID, Name FROM Inv.ProductCategory ORDER BY ID");
if (dataTable.Rows.Count > 0)
{
cboCategory.DataSource = dataTable;
cboCategory.DisplayMember = "Name";
cboCategory.ValueMember = "ID";
cboCategory.SelectedIndex = cboCategory.FindString("Name of a item");
cboCategory.SelectedText = "";
cboCategory.SelectedText = "---- Select Please ----";
txtItemName.Text = "1";
}
else
{
cboCategory.DataSource = dataTable;
cboCategory.ValueMember = "";
}
}
catch
{
}
}
