public void AccessTableAdd()
{
String Criteria;
Criteria = "PartnerID =" + textBox1.Text;
Rs.MoveFirst();
//go to the beginning to start serach
Rs.Find(Criteria);
//Either We find the record(s), which is the first record if there are more than one
//If record is found the file pointer stays at it
//if not found, the file pointer has passed eof meaning eof = true
if (Rs.EOF == true)
{
//not found
Rs.AddNew();
SaveinTable();
Rs.Update();
MessageBox.Show("Record Added succesfully");
ClearBoxes();
return;
}
else
{
//found
MessageBox.Show("Duplicate Record, try another PartnerID");
return;
}
}
private void rent_Click(object sender, EventArgs e)
{
Rscar.MoveFirst();
Rsuser.MoveFirst();
while (!Rscar.EOF)
{
if (carID.Text.Equals(Rscar.Fields["CarID"].Value))
{
Rscar.Fields["Availability"].Value = "No";
Rsuser.AddNew();
Rsuser.Fields["CarID"].Value = Convert.ToInt32(carID.Text);
Rsuser.Fields["FirstName"].Value = firstName.Text;
Rsuser.Fields["LastName"].Value = lastName.Text;
Rsuser.Fields["PhoneNumber"].Value = phoneNumber.Text;
Rsuser.Fields["RentDate"].Value = Convert.ToDateTime(rentDate.Text);
Rsuser.Fields["ReturnDate"].Value = Convert.ToDateTime(returnDate.Text);
Rsuser.Fields["Rent"].Value = "Yes";
Rscar.Update();
Rsuser.Update();
MessageBox.Show("You rent car successfully");
return;
}
Rscar.MoveNext();
}
MessageBox.Show("Something wrong....");
}
private void submit_Click(object sender, EventArgs e)
{
Boolean flag = false;
RsAccount.MoveFirst();
if (amountbox.Text.Equals("") || numbox.Text.Equals("") || typebox.Text.Equals("") || branchnumbox.Text.Equals(""))
{
MessageBox.Show("Please enter full of your infomation.");
Clear();
}
else
{
while (!RsAccount.EOF)
{
if (Convert.ToInt32(numbox.Text) == RsAccount.Fields["AccountNumber"].Value && Convert.ToInt32(branchnumbox.Text) == RsAccount.Fields["BranchNumber"].Value)
{
flag = true;
break;
}
RsAccount.MoveNext();
}
if (flag == true)
{
RsTranscript.AddNew();
RsTranscript.Fields["Date"].Value = datebox.Text;
RsTranscript.Fields["Time"].Value = timebox.Text;
RsTranscript.Fields["Amount"].Value = Convert.ToInt32(amountbox.Text);
RsTranscript.Fields["AccountNumber"].Value = Convert.ToInt32(numbox.Text);
RsTranscript.Fields["TransactionType"].Value = typebox.Text;
RsTranscript.Fields["BranchNumber"].Value = Convert.ToInt32(branchnumbox.Text);
if (typebox.Text.Equals("Deposit"))
{
int total = Convert.ToInt32(amountbox.Text) + RsAccount.Fields["Balance"].Value;
RsAccount.Fields["Balance"].Value = total;
}
else if (typebox.Text.Equals("Withdraw"))
{
int total = RsAccount.Fields["Balance"].Value - Convert.ToInt32(amountbox.Text);
RsAccount.Fields["Balance"].Value = total;
}
RsAccount.Update();
RsTranscript.Update();
MessageBox.Show("Your transaction completed successfully!!!!");
Show();
info.Parent = tabControl1;
transcript.Parent = null;
createAccount.Parent = null;
}
else
{
MessageBox.Show("Your transaction faild....");
Clear();
}
}
}
private void edt_Click_1(object sender, EventArgs e)
{
if (edt.Text == "&Edit")
{
LockUnLockMe(false);
addcust.Enabled = false;
prev.Enabled = false;
nxt.Enabled = false;
fnd.Text = "&Cancel";
edt.Text = "&Update";
prename = textname.Text;
return;
}
else if (edt.Text == "&Update")
{
if (textname.Text == "")
{
XtraMessageBox.Show("Invaild Name");
textname.Focus();
textname.Select();
return;
}
if (textid.Text == "")
{
XtraMessageBox.Show("Invaild ID");
textid.Focus();
textid.Select();
return;
}
if (textmobile.Text == "")
{
XtraMessageBox.Show("Invaild Base Weight");
textmobile.Focus();
textmobile.Select();
return;
}
GetData();
comm_tb.Update();
int rowlist = commidities_list.Items.Count;
for (int i = 0; i < rowlist; i++)
{
if (commidities_list.Items[i].ToString() == prename)
{
commidities_list.Items[i] = textname.Text;
commidities_list.Update();
break;
}
}
SetButton();
LockUnLockMe(true);
}
}
//Adding new record into DB
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" ||
textBox2.Text == "" ||
textBox3.Text == "" ||
textBox4.Text == "" ||
textBox5.Text == "" ||
textBox6.Text == "" ||
textBox7.Text == "" ||
textBox8.Text == "" ||
textBox9.Text == "" ||
textBox10.Text == "" ||
textBox11.Text == "" ||
textBox12.Text == "" ||
textBox13.Text == "" ||
textBox14.Text == "" ||
textBox15.Text == "" ||
textBox16.Text == "" ||
textBox17.Text == "" ||
textBox18.Text == "")
{
MessageBox.Show("Please Fill up all boxes");
return;
}
String Criteria;
Criteria = "ContactID =" + textBox1.Text;
Rs.MoveFirst();
//go to the beginning to start serach
Rs.Find(Criteria);
//Either We find the record(s), which is the first record if there are more than one
//If record is found the file pointer stays at it
//if not found, the file pointer has passed eof meaning eof = true
if (Rs.EOF == true)
{
//not found
Rs.AddNew();
SaveinTable();
Rs.Update();
MessageBox.Show("Record Added succesfully");
ClearBoxes();
return;
}
else
{
//found
MessageBox.Show("Duplicate Record, try another ISBN");
return;
}
}
private void coletadados()
{
ADODB.Recordset dados = new ADODB.Recordset();
ADODB.Recordset itens = new ADODB.Recordset();
String SQL = "SELECT * FROM SAÍDA WHERE (COD_SAI = " + _id + ");";
String SQLProdutos = "SELECT * FROM PRODUTOS;";
//Buscando os itens
dados.Open(SQL, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
itens.Open(SQLProdutos, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
while (!(dados.EOF || dados.BOF))
{
itens.Find("cod =" + dados.Fields[dados.Fields[0].Name].Value, 0, ADODB.SearchDirectionEnum.adSearchForward);
if (!(itens.BOF || itens.EOF))
{
itens.Fields[36].Value = Convert.ToInt64(itens.Fields[36].Value) + Convert.ToInt64(dados.Fields[1].Value);
itens.Update();
}
dados.MoveNext();
}
//EXcluindo ITENS
SQL = "DELETE FROM SAÍDA WHERE (COD_SAI = " + _id + ");";
dados.Close();
dados.Open(SQL, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
//Excluindo capa
SQL = "DELETE FROM cod_sai WHERE(COD_SAI = " + _id + ");";
dados.Open(SQL, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
}
public bool ChangeEmail(string cookieid, string email)
{
bool updated = false;
string sqlString = "SELECT usercred.id, usercred.mail FROM usercred INNER JOIN userlist ON usercred.id = userlist.id WHERE userlist.sessionid = '" + cookieid + "';";
conn = new ADODB.Connection();
rec = new ADODB.Recordset();
bool openedCon = DbUse.OpenAdoMysql(conn);
bool openedRec = DbUse.OpenAdoRec(conn, rec, sqlString);
try {
if (!openedCon || !openedRec)
{
throw new Exception("An error has occured. Please try again.");
}
else if (rec.EOF)
{
throw new Exception("An internal error has occured. Missing data.");
}
else
{
rec.Fields["mail"].Value = email;
rec.Update();
updated = true;
}
} catch (Exception ex) {
logFiles.ErrorLog(ex);
Master.ShowErrorMessage(ex.Message);
} finally {
DbUse.CloseAdoRec(rec);
DbUse.CloseAdo(conn);
}
return(updated);
}
public void CallingCLRMethodsThatHaveValueTypeParametersWorksWithReferenceTypes()
{
var recordset = new ADODB.Recordset();
recordset.Fields.Append("name", ADODB.DataTypeEnum.adVarChar, 20, ADODB.FieldAttributeEnum.adFldUpdatable);
recordset.Open(CursorType: ADODB.CursorTypeEnum.adOpenUnspecified, LockType: ADODB.LockTypeEnum.adLockUnspecified, Options: 0);
recordset.AddNew();
recordset.Fields["name"].Value = "TestName";
recordset.Update();
var _ = DefaultRuntimeSupportClassFactory.DefaultVBScriptValueRetriever;
object objField = _.CALL(
context: null,
target: recordset,
members: new string[0],
argumentProviderBuilder: _.ARGS.Val("name")
);
Assert.Equal(
"TestName",
_.CALL(
context: null,
target: this,
member1: "MockMethodReturningInputString",
argumentProviderBuilder: _.ARGS.Ref(objField, v => { objField = v; })
)
);
}
public static void AddData <T>(this IDatabaseObject <T> source) where T : class
{
string name = typeof(T).Name;
string sql = "[" + name + "]";
ADODB.Recordset rs = DataSeverConnection.Instance.Recordset(sql, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
rs.AddNew();
PropertyInfo[] properties = typeof(T).GetProperties();
for (int i = 0; i < rs.Fields.Count; i++)
{
PropertyInfo property = null;
properties.Each(f =>
{
if (f.Name == rs.Fields[i].Name)
{
property = f;
return;
}
});
rs.Fields[i].Value = property.GetValue(source);
}
rs.Update();
rs.Close();
}
private void createButton_Click(object sender, EventArgs e)
{
if (clientIN.Text.Equals("") || accountIN.Text.Equals("") || typeIN.Text.Equals("") || balanceIN.Text.Equals("") || limitIN.Text.Equals("") || branchIN.Text.Equals(""))
{
MessageBox.Show("Please enter full of your infomation.");
}
else
{
RsAccount.AddNew();
RsUser.AddNew();
RsUser.Fields["ClientID"].Value = clientIN.Text;
RsUser.Fields["Password"].Value = passIN.Text;
RsAccount.Fields["ClientID"].Value = Convert.ToInt32(clientIN.Text);
RsAccount.Fields["AccountNumber"].Value = Convert.ToInt32(accountIN.Text);
RsAccount.Fields["AccountType"].Value = typeIN.Text;
RsAccount.Fields["Balance"].Value = Convert.ToInt32(balanceIN.Text);
RsAccount.Fields["CreditLimit"].Value = Convert.ToInt32(limitIN.Text);
RsAccount.Fields["BranchNumber"].Value = Convert.ToInt32(branchIN.Text);
RsUser.Update();
RsAccount.Update();
Show();
createAccount.Parent = null;
login.Parent = tabControl1;
}
}
private ADODB.Recordset CreateInMemoryADORS(IGTKeyObjects DDCKeyObjects)
{
ADODB.Recordset shapeADORecordset = new ADODB.Recordset();
try
{
shapeADORecordset.Fields.Append("G3E_FNO", ADODB.DataTypeEnum.adInteger, 0, ADODB.FieldAttributeEnum.adFldFixed, null);
shapeADORecordset.Fields.Append("G3E_FID", ADODB.DataTypeEnum.adInteger, 0, ADODB.FieldAttributeEnum.adFldFixed, null);
shapeADORecordset.Open(System.Type.Missing, System.Type.Missing, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockUnspecified, 0);
foreach (IGTKeyObject keyObject in DDCKeyObjects)
{
shapeADORecordset.AddNew(System.Type.Missing, System.Type.Missing);
shapeADORecordset.Fields["G3E_FNO"].Value = keyObject.FNO;
shapeADORecordset.Fields["G3E_FID"].Value = keyObject.FID;
shapeADORecordset.Update(System.Type.Missing, System.Type.Missing);
}
}
catch (Exception ex)
{
string exMsg = string.Format("Error occurred in {0} of {1}.{2}{3}", System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString(), Environment.NewLine, ex.Message);
throw new Exception(exMsg);
}
return(shapeADORecordset);
}
private void edt_Click(object sender, EventArgs e)
{
if (edt.Text == "&Edit")
{
LockUnLockMe(false);
textBox1.ReadOnly = true;
addcust.Enabled = false;
prev.Enabled = false;
nxt.Enabled = false;
fnd.Text = "&Cancel";
edt.Text = "&Update";
prename = textname.Text;
return;
}
else if (edt.Text == "&Update")
{
if (textname.Text == "")
{
XtraMessageBox.Show("Invaild Name");
return;
}
GetData();
cstmr_tb.Update();
int rowlist = customers_list.Items.Count;
for (int i = 0; i < rowlist; i++)
{
if (customers_list.Items[i].ToString() == prename)
{
customers_list.Items[i] = textname.Text;
customers_list.Update();
break;
}
}
SetButton();
LockUnLockMe(true);
}
}
private static bool InsertIntoAsketPorTimeEntries()
{
string Select = "select з.IdPorAsket, тз.IssueId, ТЗ.Spent_On,тз.Hours, Ф.UserName , тз.Comments + ' Импортировано из Redmine. ' as Comments, тз.id" +
" from " + DB.TABLE_REDMINE_TIME_ENTRIES + " as ТЗ " +
" left join " + DB.TABLE_REDMINE_USERS + " as П on тз.UserId = п.id " +
" left join " + DB.TABLE_ASKET_USERS + " as Ф On п.IdUserFromFam = Ф.код " +
" left join " + DB.TABLE_REDMINE_ISSUES + " as З on ТЗ.IssueId = З.id " +
" where Deleted = 0 and InsertIntoAsketPor = 0 and з.idPorAsket is not null ";
ADODB.Recordset rsSelect = DB.Select(Select);
if (rsSelect == null)
{
return(false);
}
ADODB.Recordset RsAddPor = DB.Update("select top 1 Код, КодПоручения, Дата, Часов, Кто, Примечания from " + DB.TABLE_REPORT_DEVELOPER);
if (RsAddPor == null)
{
return(false);
}
ADODB.Recordset RsUpdateTimeEntries = DB.Update("Select Id, InsertIntoAsketPor,IdRazrabAsket from " + DB.TABLE_REDMINE_TIME_ENTRIES + " where Deleted = 0 and InsertIntoAsketPor = 0 and IdRazrabAsket =0");
if (RsUpdateTimeEntries == null)
{
return(false);
}
while (!(rsSelect.EOF))
{
RsAddPor.AddNew();
RsAddPor.Fields["КодПоручения"].Value = rsSelect.Fields["IdPorAsket"].Value;
RsAddPor.Fields["Дата"].Value = rsSelect.Fields["Spent_On"].Value;
RsAddPor.Fields["Часов"].Value = rsSelect.Fields["Hours"].Value;
RsAddPor.Fields["Кто"].Value = rsSelect.Fields["UserName"].Value;
RsAddPor.Fields["Примечания"].Value = rsSelect.Fields["Comments"].Value;
RsAddPor.Update();
RsUpdateTimeEntries.Filter = "id = " + rsSelect.Fields["id"].Value;
if (RsUpdateTimeEntries.RecordCount == 1)
{
RsUpdateTimeEntries.Fields["InsertIntoAsketPor"].Value = true;
RsUpdateTimeEntries.Fields["IdRazrabAsket"].Value = RsAddPor.Fields["Код"].Value;
RsUpdateTimeEntries.Update();
}
rsSelect.MoveNext();
}
rsSelect.Close();
RsAddPor.Close();
return(true);
}
public bool salvar()
{
String SQL;
if (alterado)
{
ADODB.Recordset RSDados = new ADODB.Recordset();
RSDados.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
RSDados.LockType = ADODB.LockTypeEnum.adLockOptimistic;
RSDados.CursorType = ADODB.CursorTypeEnum.adOpenKeyset;
if (cod != 0)
{
SQL = "SELECT Duplicatas.* FROM Duplicatas WHERE (((Duplicatas.Código)=" + cod + "));";
}
else
{
SQL = "SELECT Duplicatas.* FROM Duplicatas;";
}
RSDados.Open(SQL, new Conexao().getContas());
if (cod == 0)
{
RSDados.AddNew();
}
RSDados.Fields["data"].Value = Vencimento.ToShortDateString();
RSDados.Fields["Origem"].Value = Origem;
RSDados.Fields["informação"].Value = Informacao;
RSDados.Fields["complemento"].Value = Complemento;
RSDados.Fields["Valor"].Value = Valor;
RSDados.Fields["Pago"].Value = Pago;
RSDados.Fields["Classificação"].Value = Classificacao;
RSDados.Fields["DataNota"].Value = DataNota.ToShortDateString();
RSDados.Fields["Empresa"].Value = Empresa;
RSDados.Update();
if (cod == 0)
{
cod = Convert.ToInt32(RSDados.Fields["cod"].Value);
}
RSDados.Close();
return(true);
}
return(false);
}
private static bool ConnectUsersFromRedmineWithAsket()
{
string SqlSelect = "select Код,email from " + DB.TABLE_ASKET_USERS + " where уволен = 0 and email in( select mail from " + DB.TABLE_REDMINE_USERS + " where IdUserFromFam = 0)";
ADODB.Recordset rs = DB.Select(SqlSelect);
ADODB.Recordset users = DB.Update("Select * from " + DB.TABLE_REDMINE_USERS);
while (!rs.EOF)
{
users.Filter = "mail = '" + rs.Fields["email"].Value + "'";
users.Fields["IdUserFromFam"].Value = rs.Fields["Код"].Value;
rs.MoveNext();
}
users.Update();
users.Close();
rs.Close();
rs = null;
return(true);
}
public virtual void Update()
{
try
{
string[] keys = GetPrimaryKeyColumns();
string tblName = typeof(T).Name;
int idx = tblName.IndexOf("'");
if (idx > 0)
{
tblName = tblName.Substring(0, idx);
}
string sql = "SELECT * FROM [" + typeof(T).Name + "] WHERE " + GetSQLCriteria(GetPrimaryKeys(keys));
ADODB.Recordset rs = DataSeverConnection.Instance.Recordset(sql, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
FillRecordset(false, rs, keys);
rs.Update();
}
catch (Exception err) { MessageBox.Show("Error Updating Database: " + err.Message); }
}
public void ADORecordsetSupportsDefaultFieldAccess()
{
var recordset = new ADODB.Recordset();
recordset.Fields.Append("name", ADODB.DataTypeEnum.adVarChar, 20, ADODB.FieldAttributeEnum.adFldUpdatable);
recordset.Open(CursorType: ADODB.CursorTypeEnum.adOpenUnspecified, LockType: ADODB.LockTypeEnum.adLockUnspecified, Options: 0);
recordset.AddNew();
recordset.Fields["name"].Value = "TestName";
recordset.Update();
var _ = DefaultRuntimeSupportClassFactory.DefaultVBScriptValueRetriever;
Assert.Equal(
recordset.Fields["name"],
_.CALL(
context: null,
target: recordset,
members: new string[0],
argumentProviderBuilder: _.ARGS.Val("name")
),
new ADOFieldObjectComparer()
);
}
public virtual void Add(bool addAll = false, ProgressReporter pg = null)
{
//lock (DataSeverConnection.Instance.Connection)
//{
try
{
string sql = "SELECT * FROM [" + typeof(T).Name.SanitizeTypeName() + "]";
ADODB.Recordset rs = DataSeverConnection.Instance.Recordset(sql, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic);
string[] keys = GetPrimaryKeyColumns();
try
{
rs.AddNew();
FillRecordset(addAll, rs, keys);
rs.Update();
}
catch (Exception) { return; }
if (addAll == false)
{
keys.Each(k =>
{
int pos = rs.GetFieldPosition(k);
PropertyInfo temp = typeof(T).GetProperty(k);
object val = rs.Fields[pos].Value;
temp.SetValue(this, Convert.ChangeType(val, temp.PropertyType));
});
}
rs.Close();
NeedsToSave = false;
if (pg != null)
{
pg.ReportProgress(pg.ReportAction);
}
}
catch (Exception err) { MessageBox.Show("Error adding to Database: " + err.Message); }
//}
}
public static void SaveDatabase()
{
ADODB.Connection cn = new ADODB.Connection();
cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\mdb\\" + CComLibrary.GlobeVal.filesave.methodname + ".mdb", null, null, -1);
ADODB.Recordset rs;
rs = new ADODB.Recordset();
rs.LockType = ADODB.LockTypeEnum.adLockPessimistic;
rs.CursorType = ADODB.CursorTypeEnum.adOpenDynamic;
string sql = "select * from FirstTable";
rs.Open(sql, cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, (int)ADODB.CommandTypeEnum.adCmdText);
if ((rs.RecordCount > 0))
{
rs.MoveFirst();
}
string mshiyanghao = "";
string myangpinmingcheng = "";
int nshiyanhao = 0;
int nyangpinmingcheng = 0;
int nRecordId = 0;
for (int j = 0; j < CComLibrary.GlobeVal.filesave.mdatabaseitemselect.Count; j++)
{
if (CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Name == "试样号")
{
mshiyanghao = CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value;
nshiyanhao = j;
}
if (CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Name == "样品名称")
{
myangpinmingcheng = CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value;
nyangpinmingcheng = j;
}
}
bool mb = false;
string wshiyanghao = "";
string wyangpinmingcheng = "";
for (int i = 0; i < rs.RecordCount; i++)
{
wshiyanghao = Convert.ToString(rs.Fields[nshiyanhao + 1].Value);
wyangpinmingcheng = Convert.ToString(rs.Fields[nyangpinmingcheng + 1].Value);
if ((wshiyanghao == mshiyanghao) && (wyangpinmingcheng == myangpinmingcheng))
{
mb = true;
nRecordId = Convert.ToInt32(rs.Fields[0].Value);
break;
}
else
{
rs.MoveNext();
}
}
for (int i = 0; i < 1; i++)
{
object missing = System.Reflection.Missing.Value;
if (mb == false)
{
rs.AddNew(missing, missing);
rs.Fields["RecordId"].Value = rs.RecordCount;
}
else
{
rs.Delete(ADODB.AffectEnum.adAffectCurrent);
rs.AddNew(missing, missing);
rs.Fields["RecordId"].Value = nRecordId;
}
for (int j = 0; j < CComLibrary.GlobeVal.filesave.mdatabaseitemselect.Count; j++)
{
if (CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value == null)
{
rs.Fields[j + 1].Value = "";
}
else
{
rs.Fields[j + 1].Value = CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value;
}
}
rs.Update();
}
rs.Close();
cn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox2.Text == "")
{
MessageBox.Show("PAY Type can't be empty");
comboBox2.Select();
comboBox2.Focus();
return;
}
if (comboBox2.Text == "CHEQUE")
{
if (textBox5.Text == "")
{
MessageBox.Show("Enter Cheque Details");
textBox5.Select();
textBox5.Focus();
return;
}
}
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j <= 2; j++)
{
if (dataGridView1.Rows[i].Cells[j] == null || dataGridView1.Rows[i].Cells[j].Value == "")
{
MessageBox.Show("Field can't be empty");
dataGridView1.CurrentCell = dataGridView1.Rows[i].Cells[j];
return;
}
}
}
Temp1.Open(@"select * from farmerpayment", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
Temp1.AddNew();
Temp1.Fields["fpayId"].Value = Int64.Parse(textBox1.Text);
if (comboBox2.Text == "CASH")
{
Temp1.Fields["fpaytype"].Value = "CASH";
}
else if (comboBox2.Text == "CHEQUE")
{
Temp1.Fields["fpaytype"].Value = "CHEQUE : " + textBox5.Text;
}
Temp2.Open(@"select * from farmerdetails WHERE fNames='" + dataGridView1.Rows[i].Cells[0].EditedFormattedValue + "'", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
Temp1.Fields["fID"].Value = Temp2.Fields["fID"].Value;
Temp2.Close();
Temp1.Fields["pattiId"].Value = Int64.Parse(dataGridView1.Rows[i].Cells[1].EditedFormattedValue.ToString());
Temp1.Fields["Amount"].Value = decimal.Parse(dataGridView1.Rows[i].Cells[2].EditedFormattedValue.ToString());
Temp2.Open(@"select * from pattirefer WHERE pattiID = " + Int64.Parse(dataGridView1.Rows[i].Cells[1].EditedFormattedValue.ToString()) + "", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
Temp2.Fields["payable"].Value = Temp2.Fields["payable"].Value - decimal.Parse(dataGridView1.Rows[i].Cells[2].EditedFormattedValue.ToString());
Temp2.Update();
Temp2.Close();
Temp1.Fields["PayDay"].Value = dateTimePicker1.Value.ToShortDateString();
Temp1.Fields["TotalAmount"].Value = decimal.Parse(textBox2.Text);
Temp1.Update();
}
Temp1.Close();
MessageBox.Show("SAVED");
textBox1.Text = (Int64.Parse(textBox1.Text) + 1).ToString();
comboBox2.SelectedIndex = -1;
label7.Visible = false;
textBox5.Visible = false;
textBox2.Text = "";
dataGridView1.Rows.Clear();
}
/// <summary>
/// Creates an ADODB.Recordset from an System.Collections.Generic.IEnumerable(T).
/// </summary>
/// <typeparam name="T">The type of the elements of input.</typeparam>
/// <param name="input">The System.Collections.Generic.IEnumerable(T) to create an ADODB.Recordset from.</param>
/// <returns>An ADODB.Recordset that contains elements from the input sequence.</returns>
public static ADODB.Recordset ToRecordset <T>(this IEnumerable <T> input)
{
var adoType = new ADODB.DataTypeEnum();
if (DataTypes.TryGetAdoTypeForClrType(typeof(T), out adoType))
{
throw new ArgumentException("The T of IEnumerable<T> must be a custom POCO, not an ADO compatible type.", "input");
}
var rs = new ADODB.Recordset();
var type = typeof(T);
BindingFlags flags = BindingFlags.Public | BindingFlags.Instance;
PropertyInfo[] properties = type.GetProperties(flags);
// create properties
foreach (var property in properties)
{
if (DataTypes.TryGetAdoTypeForClrType(property.PropertyType, out adoType))
{
int definedSize = 0;
if (property.PropertyType == typeof(string))
{
// TODO: set string size to length of longest string in POCO?
definedSize = 1000;
}
if (property.PropertyType == typeof(Guid))
{
definedSize = 38;
}
rs.Fields.Append(property.Name, adoType, definedSize, ADODB.FieldAttributeEnum.adFldIsNullable);
}
}
// insert data
rs.Open();
if (input.Any())
{
foreach (var item in input)
{
rs.AddNew();
foreach (var property in properties)
{
var value = property.GetValue(item, null);
if (property.PropertyType == typeof(Guid))
{
value = value.ToString();
}
if (value != null)
{
rs.Fields[property.Name].Value = value;
}
}
rs.Update();
}
}
return(rs);
}
private void btnsave_Click(object sender, EventArgs e)
{
ADODB.Recordset tmp = new ADODB.Recordset();
try
{
if (ADOconn.State == 0)
{
ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0);
}
ADODB.Recordset rec = new ADODB.Recordset();
Conn.Close();
// Conn.Open();
bool isempty;
isempty = false;
if (isedit)
{
if (txtpriv.Text.Substring(1, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
else
{
if (txtpriv.Text.Substring(0, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
if (isempty)
{
MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry");
return;
}
try
{
// ADOconn.BeginTrans();
//if (cmbmonth.SelectedIndex<0)
//{
// MessageBox.Show("Invalid Salary Month, Please Select a Valid Month", "Invalid Entry");
// return;
//}
ADOconn.BeginTrans();
int i = 0;
string entry_no = dtentry.Value.Date.ToString("yyyyMMdd");
if (isedit)
{
sql = "delete from reconcil_det where Reconcil_No = '" + entry_no + "'";
object a;
ADOconn.Execute(sql, out a);
}
sql = "select * from reconcil_det where Reconcil_No = '" + entry_no + "'";
rec = new ADODB.Recordset();
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
// rec.AddNew();
}
else
{
MessageBox.Show("Entry Already Exist , Cannot enter as a New entry", "Invalid Entry");
return;
}
for (i = 0; i < dgv1.Rows.Count; i++)
{
if (dgv1[0, i].Value != null)
{
rec.AddNew();
if (dgv1[3, i].Value == null)
{
dgv1[3, i].Value = 0;
}
if (dgv1[4, i].Value == null)
{
dgv1[4, i].Value = 0;
}
double amt = Convert.ToDouble(dgv1[3, i].Value) + Convert.ToDouble(dgv1[4, i].Value);
rec.Fields["Reconcil_No"].Value = entry_no;
rec.Fields["Reconcil_Date"].Value = dtentry.Value.Date;
rec.Fields["Reconcil_user"].Value = Gvar.username;
rec.Fields["Amount"].Value = Math.Abs(amt);
rec.Fields["Bank_No"].Value = cmbbank.SelectedValue;
rec.Fields["DR_CR"].Value = dgv1[2, i].Value;
rec.Fields["plus_minus"].Value = "";
rec.Fields["pay_date"].Value = dgv1[0, i].Value;
rec.Fields["SNO"].Value = i + 1;
rec.Fields["trn_type"].Value = "A";
rec.Fields["NARRATION"].Value = dgv1[5, i].Value;
rec.Update();
}
}
for (i = 0; i < dgvbank.Rows.Count; i++)
{
if (dgvbank[2, i].Value != null)
{
rec.AddNew();
if (dgvbank[0, i].Value == null)
{
dgvbank[0, i].Value = "";
}
if (dgvbank[1, i].Value == null)
{
dgvbank[1, i].Value = 0;
}
double amt = Convert.ToDouble(dgvbank[2, i].Value);
rec.Fields["Reconcil_No"].Value = entry_no;
rec.Fields["Reconcil_Date"].Value = dtentry.Value.Date;
rec.Fields["Reconcil_user"].Value = Gvar.username;
rec.Fields["Amount"].Value = Math.Abs(amt);
rec.Fields["Bank_No"].Value = cmbbank.SelectedValue;
if (dgvbank[1, i].Value == "+")
{
rec.Fields["DR_CR"].Value = "D";
}
else
{
rec.Fields["DR_CR"].Value = "C";
}
rec.Fields["plus_minus"].Value = dgvbank[1, i].Value;
rec.Fields["pay_date"].Value = "";
rec.Fields["SNO"].Value = i + 1;
rec.Fields["trn_type"].Value = "B";
rec.Fields["NARRATION"].Value = dgvbank[0, i].Value;
rec.Update();
}
}
for (i = 0; i < dgvbook.Rows.Count; i++)
{
if (dgvbook[2, i].Value != null)
{
rec.AddNew();
if (dgvbook[0, i].Value == null)
{
dgvbook[0, i].Value = "";
}
if (dgvbook[1, i].Value == null)
{
dgvbook[1, i].Value = 0;
}
double amt = Convert.ToDouble(dgvbook[2, i].Value);
rec.Fields["Reconcil_No"].Value = entry_no;
rec.Fields["Reconcil_Date"].Value = dtentry.Value.Date;
rec.Fields["Reconcil_user"].Value = Gvar.username;
rec.Fields["Amount"].Value = Math.Abs(amt);
rec.Fields["Bank_No"].Value = cmbbank.SelectedValue;
if (dgvbook[1, i].Value == "+")
{
rec.Fields["DR_CR"].Value = "D";
}
else
{
rec.Fields["DR_CR"].Value = "C";
}
rec.Fields["plus_minus"].Value = dgvbook[1, i].Value;
rec.Fields["pay_date"].Value = "";
rec.Fields["SNO"].Value = i + 1;
rec.Fields["trn_type"].Value = "C";
rec.Fields["NARRATION"].Value = dgvbook[0, i].Value;
rec.Update();
}
}
ADOconn.CommitTrans();
isedit = true;
MessageBox.Show("Successfully Saved");
}
catch (Exception ex)
{
ADOconn.RollbackTrans();
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//string sql;
private void save_form()
{
ADODB.Connection ADOconn = new ADODB.Connection();
try
{
//if (tooltip.Text.Trim().Length < 3)
//{
// MessageBox.Show("Invalid Length of Code, Must Be 3 Digit!!");
// return;
//}
ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0);
ADODB.Recordset rec = new ADODB.Recordset();
Conn.Close();
// Conn.Open();
bool isempty;
isempty = false;
if (isedit)
{
if (txtpriv.Text.Substring(1, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
else
{
if (txtpriv.Text.Substring(0, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
foreach (Control gb in this.Controls)
{
if (gb is GroupBox)
{
foreach (Control tb in gb.Controls)
{
if (tb is TextBox)
{
if (tb.Tag == "1")
{
tb.BackColor = System.Drawing.Color.White;
if (string.IsNullOrEmpty(tb.Text.Trim()))
{
tb.BackColor = System.Drawing.Color.Yellow;
isempty = true;
}
}
}
}
}
}
if (isempty)
{
MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry");
return;
}
//if (txtvehno.Text.Trim() == "") txtvehno.Text = "0";
if (txtcuscode.Text.Trim() == "")
{
txtcuscode.Text = "0";
}
//sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim());
Int64 acno = 0;
try
{
sql = "SELECT * FROM Veh_Customer where Cus_code =" + Convert.ToDouble(txtcuscode.Text.Trim());
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
sql = "SELECT MAX(cus_code)+1 FROM Veh_Customer";
ADODB.Recordset tmp = new ADODB.Recordset();
tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (tmp.Fields[0].Value != DBNull.Value)
{
txtcuscode.Text = tmp.Fields[0].Value.ToString();
}
else
{
txtcuscode.Text = "1";
}
tmp = new ADODB.Recordset();
sql = "update ACC_TYPE SET CUR_NO = " + acno + " WHERE ACC_TYPE_CODE=1";
tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
rec.AddNew();
}
acno = Convert.ToInt64(txtcuscode.Text.Trim());
rec.Fields["Cus_code"].Value = Convert.ToDouble(txtcuscode.Text.Trim());
//rec.Fields["Cus_code"].Value = txtcuscode.Text.Trim();
rec.Fields["Cus_cat"].Value = cmbcat.SelectedValue;
rec.Fields["Cus_Name"].Value = txtcusname.Text.Trim();
rec.Fields["Sponsor_code"].Value = cmbsponsor.SelectedValue;
rec.Fields["Id_Number"].Value = txtidnumber.Text.Trim();
rec.Fields["Mobile"].Value = txtmobileno.Text.Trim();
rec.Fields["Address"].Value = txtcusadd.Text.Trim();
rec.Fields["office_no"].Value = txtofficeno.Text.Trim();
rec.Fields["careof"].Value = txtcareof.Text.Trim();
rec.Fields["contact_no"].Value = txtcontactno.Text.Trim();
rec.Fields["ID_issued_at"].Value = txtissueplace.Text.Trim();
rec.Fields["License_No"].Value = txtlicno.Text.Trim();
rec.Fields["ID_Expiry_Date"].Value = txtidexiry.Text.Trim();
rec.Fields["Licence_Issued_at"].Value = txtlicissueplace.Text.Trim();
rec.Fields["Licence_exp_date"].Value = txtlicexpiry.Text.Trim();
rec.Fields["Nationality"].Value = txtnationality.Text.Trim();
rec.Fields["EmailId"].Value = txtemailid.Text.Trim();
rec.Update();
//if (txtvehno.Text.Trim() == "") txtvehno.Text = "0";
//if (txtvalue.Text.Trim() == "") txtvalue.Text = "0";
//sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim());
sql = "SELECT * FROM Accounts where Acc_no ='" + acno + "'";
rec = new ADODB.Recordset();
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
rec.AddNew();
}
//rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim());
rec.Fields["ACC_NO"].Value = txtcuscode.Text.Trim();
rec.Fields["ACC_NAME"].Value = txtcusname.Text.Trim();
rec.Fields["ACC_CATEGORY"].Value = 1;
rec.Fields["ACC_TYPE_CODE"].Value = 1;
rec.Fields["ACC_TELE_NO"].Value = txtofficeno.Text.Trim();
rec.Fields["ACC_FAX_NO"].Value = txtofficeno.Text.Trim();
rec.Fields["ACC_ADDRESS"].Value = txtcusadd.Text.Trim();
rec.Fields["CONTACT_PERSON"].Value = txtcusname.Text.Trim();
rec.Fields["Id_Number"].Value = txtidnumber.Text.Trim();
rec.Fields["ACC_Mobile_NO"].Value = txtmobileno.Text.Trim();
rec.Fields["flag"].Value = "A";
rec.Update();
MessageBox.Show("Successfully Saved");
load_leaders();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//string sql;
private void save_form()
{
ADODB.Connection ADOconn = new ADODB.Connection();
try
{
//if (tooltip.Text.Trim().Length < 3)
//{
// MessageBox.Show("Invalid Length of Code, Must Be 3 Digit!!");
// return;
//}
ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0);
ADODB.Recordset rec = new ADODB.Recordset();
Conn.Close();
// Conn.Open();
bool isempty;
isempty = false;
if (isedit)
{
if (txtpriv.Text.Substring(1, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
else
{
if (txtpriv.Text.Substring(0, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
foreach (Control gb in this.Controls)
{
if (gb is GroupBox)
{
foreach (Control tb in gb.Controls)
{
if (tb is TextBox)
{
if (tb.Tag == "1")
{
tb.BackColor = System.Drawing.Color.White;
if (string.IsNullOrEmpty(tb.Text.Trim()))
{
tb.BackColor = System.Drawing.Color.Yellow;
isempty = true;
}
}
}
}
}
}
if (isempty)
{
MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry");
return;
}
//if (txtcuscode.Text.Trim() == "")
//{
// MessageBox.Show("Invalid SponsorCode , Please enter a Valid Numeber!!", "Invalid Entry");
// return;
//}
if (txtcusname.Text.Trim() == "")
{
MessageBox.Show("Invalid Sponsor Name , Please enter a Valid Name!!", "Invalid Entry");
return;
}
//txtvehno.Text = "0";
if (txtcuscode.Text.Trim() == "")
{
txtcuscode.Text = "-0";
}
//sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim());
sql = "SELECT * FROM veh_sponsor where sponsor_code ='" + txtcuscode.Text.Trim() + "'";
try
{
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
rec.AddNew();
}
//rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim());
//rec.Fields["sponsor_code"].Value = Convert.ToDouble(txtcuscode.Text.Trim());
rec.Fields["sponsor_name"].Value = txtcusname.Text.Trim();
rec.Fields["contact_name"].Value = txtcontact.Text.Trim();
rec.Fields["Id_Number"].Value = txtidnumber.Text.Trim();
rec.Fields["Mobile"].Value = txtmobileno.Text.Trim();
rec.Fields["Address"].Value = txtcusadd.Text.Trim();
rec.Update();
rec = new ADODB.Recordset();
rec.Open("SELECT @@IDENTITY", ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
//rec.GetRows();
txtcuscode.Text = rec.Fields[0].Value.ToString();
//rec.Requery();
//txtcuscode.Text = rec.Fields["sponsor_code"].Value.ToString();
MessageBox.Show("Successfully Saved");
load_leaders();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//string sql;
private void save_form()
{
ADODB.Connection ADOconn = new ADODB.Connection();
ADODB.Recordset tmp = new ADODB.Recordset();
try
{
//if (tooltip.Text.Trim().Length < 3)
//{
// MessageBox.Show("Invalid Length of Code, Must Be 3 Digit!!");
// return;
//}
ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0);
ADODB.Recordset rec = new ADODB.Recordset();
Conn.Close();
// Conn.Open();
bool isempty;
isempty = false;
if (isedit)
{
if (txtpriv.Text.Substring(1, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
else
{
if (txtpriv.Text.Substring(0, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
foreach (Control gb in this.Controls)
{
if (gb is GroupBox)
{
foreach (Control tb in gb.Controls)
{
if (tb is TextBox)
{
if (tb.Tag == "1")
{
tb.BackColor = System.Drawing.Color.White;
if (string.IsNullOrEmpty(tb.Text.Trim()))
{
tb.BackColor = System.Drawing.Color.Yellow;
isempty = true;
}
}
}
}
}
}
if (isempty)
{
MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry");
return;
}
try
{
ADOconn.BeginTrans();
if (!isedit)
{
gen_accno();
tmp = new ADODB.Recordset();
//sql = "update ACC_TYPE SET CUR_NO = CUR_NO+1 WHERE ACC_TYPE_CODE=" + cmbCostCode.SelectedValue;
// tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
}
if (txtProjectAmt.Text.Trim() == "")
{
txtProjectAmt.Text = "0";
}
//if (txtvalue.Text.Trim() == "") txtvalue.Text = "0";
//sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim());
sql = "SELECT * FROM project_master where project_code ='" + txtprojectcode.Text.Trim() + "'";
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
rec.AddNew();
}
if (txtProjectAmt.Text == "")
{
txtProjectAmt.Text = "0";
}
if (txtpercent.Text == "")
{
txtpercent.Text = "0";
}
//rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim());
rec.Fields["Project_Code"].Value = txtprojectcode.Text.Trim();
rec.Fields["Project_Name"].Value = txtProjectname.Text.Trim();
rec.Fields["Client_code"].Value = cmbacc.SelectedValue;
rec.Fields["Cost_Code"].Value = Convert.ToInt32(txtprojectcode.Text); //cmbCostCode.SelectedValue;
rec.Fields["Start_date"].Value = dt1.Value.Date.ToString("yyyy-MM-dd");;
rec.Fields["End_Date"].Value = dtend.Value.Date.ToString("yyyy-MM-dd");
rec.Fields["Project_det"].Value = txtDescription.Text.Trim();
rec.Fields["completed"].Value = Convert.ToDouble(txtpercent.Text);
rec.Fields["Status"].Value = cmbstatus.Text.Trim();
rec.Fields["Incharge"].Value = cmbincharge.Text.Trim();
rec.Fields["Location"].Value = cmblocaltion.Text.Trim();
rec.Fields["Project_Amt"].Value = Convert.ToDouble(txtProjectAmt.Text);
rec.Update();
sql = "select Cost_Code,Cost_name from Cost_Master where cost_code= " + Convert.ToInt32(txtprojectcode.Text);
rec = new ADODB.Recordset();
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
rec.AddNew();
}
rec.Fields["Cost_Code"].Value = Convert.ToInt32(txtprojectcode.Text);
rec.Fields["Cost_name"].Value = txtProjectname.Text.Trim();
rec.Update();
ADOconn.CommitTrans();
isedit = true;
MessageBox.Show("Successfully Saved");
load_leaders();
}
catch (Exception ex)
{
ADOconn.RollbackTrans();
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
if (dataGridView1.RowCount > 1)
{
patti_entry.Open(@"select * from pattirefer", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
patti_entry.AddNew();
patti_entry.Fields["pattiId"].Value = pattilbl.Text;
patti_entry.Fields["fID"].Value = int.Parse(textBox1.Text);
patti_entry.Fields["comm"].Value = float.Parse(txtbcomm.Text);
patti_entry.Fields["bardan"].Value = float.Parse(txtbbardan.Text);
patti_entry.Fields["hamali"].Value = float.Parse(txtbhamali.Text);
patti_entry.Fields["freight"].Value = float.Parse(txtbfreight.Text);
patti_entry.Fields["packing"].Value = float.Parse(txtbpacking.Text);
patti_entry.Fields["other"].Value = float.Parse(txtbother.Text);
patti_entry.Fields["netsale"].Value = float.Parse(txtbnetsale.Text);
patti_entry.Fields["exp"].Value = float.Parse(txtbexp.Text);
patti_entry.Fields["grosssale"].Value = float.Parse(txtbgrosssale.Text);
patti_entry.Fields["patti_date"].Value = dateTimePicker1.Value.ToShortDateString();
transact_entry.Open(@"select * from transactions", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
int rc = dataGridView1.RowCount - 1;
for (int i = 0; i < rc; i++)
{
transact_entry.AddNew();
transact_entry.Fields["tID"].Value = transact_entry.RecordCount + 1;
transact_entry.Fields["pattiID"].Value = pattilbl.Text;
transact_entry.Fields["coID"].Value = dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString();
transact_entry.Fields["coweight"].Value = dataGridView1.Rows[i].Cells[4].EditedFormattedValue.ToString();
transact_entry.Fields["coprice"].Value = dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString();
transact_entry.Fields["rate"].Value = dataGridView1.Rows[i].Cells[5].EditedFormattedValue.ToString();
transact_entry.Fields["qty"].Value = dataGridView1.Rows[i].Cells[2].EditedFormattedValue.ToString();
string query1 = "select * from customerdetails where CName='" + dataGridView1.Rows[i].Cells[3].EditedFormattedValue + "'";
Temp1.Open(query1, Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
transact_entry.Fields["cID"].Value = Temp1.Fields["cID"].Value;
string query2 = "select * from billrefer where cID = " + Temp1.Fields["cID"].Value + " AND bill_date = #" + dateTimePicker1.Value.ToShortDateString() + "#";
bill_entry.Open(query2, Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
if (bill_entry.RecordCount == 0)
{
bill_entry.AddNew();
Temp2.Open(@"select * from billrefer", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
if (Temp2.RecordCount == 0)
{
bill_entry.Fields["billID"].Value = 1;
transact_entry.Fields["billId"].Value = 1;
}
else
{
bill_entry.Fields["billID"].Value = Temp2.RecordCount + 1;
transact_entry.Fields["billId"].Value = Temp2.RecordCount + 1;
}
Temp2.Close();
bill_entry.Fields["saleamt"].Value = dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString();
bill_entry.Fields["totalamt"].Value = dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString();
bill_entry.Fields["cID"].Value = Temp1.Fields["cID"].Value;
bill_entry.Fields["bill_date"].Value = dateTimePicker1.Value.ToShortDateString();
decimal oldbalance = decimal.Parse(Temp1.Fields["cbalance"].Value.ToString());
Temp1.Fields["cbalance"].Value = decimal.Parse(dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString()) + oldbalance;
Temp1.Update();
}
else
{
transact_entry.Fields["billId"].Value = bill_entry.Fields["billID"].Value;
decimal tempsaleamnt;
tempsaleamnt = bill_entry.Fields["saleamt"].Value + decimal.Parse(dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString());
bill_entry.Fields["saleamt"].Value = decimal.Parse(tempsaleamnt.ToString());
bill_entry.Fields["totalamt"].Value = decimal.Parse(tempsaleamnt.ToString());
decimal oldbalance = decimal.Parse(Temp1.Fields["cbalance"].Value);
Temp1.Fields["cbalance"].Value = decimal.Parse(dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString()) + oldbalance;
Temp1.Update();
}
Temp1.Close();
bill_entry.Update();
bill_entry.Close();
}
transact_entry.Update();
transact_entry.Close();
patti_entry.Update();
patti_entry.Close();
dataGridView1.Rows.Clear();
pattinum += 1;
pattilbl.Text = pattinum.ToString();
textBox1.Clear();
textBox2.Clear();
txtbbardan.ResetText();//Clear();
txtbcomm.ResetText();
txtbexp.ResetText();
txtbfreight.ResetText();
txtbgrosssale.ResetText();
txtbhamali.ResetText();
txtbnetsale.ResetText();
txtbother.ResetText();
txtbpacking.ResetText();
Program.DB.Close();
Program.DB.Open();
/* pattireportprint PP = new pattireportprint();
* PP.PrintDialog();
* PP.BeginUpdate();
* int b=pattinum-1;
* PP.FilterString = "[npattiid] = "+ b +"";
* PP.EndUpdate();
*
* using (ReportPrintTool printTool = new ReportPrintTool(PP))
* {
*
* printTool. showPreviewDialog(UserLookAndFeel.Default);
*
* }*/
}
else
{
MessageBox.Show("can't generate patti on empty list");
dataGridView1.CurrentCell = dataGridView1.Rows[0].Cells[0];
}
}
else
{
MessageBox.Show("Enter farmer Id");
textBox1.Focus();
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("SELECT A CUSTOMER");
comboBox1.Select();
comboBox1.Focus();
return;
}
if (comboBox2.Text == "")
{
MessageBox.Show("SELECT PAY TYPE");
comboBox2.Select();
comboBox2.Focus();
return;
}
if (textBox4.Text == "")
{
MessageBox.Show("DISCOUNT CAN'T BE EMPTY");
textBox4.Select();
textBox4.Focus();
return;
}
if (textBox3.Text == "")
{
MessageBox.Show("AMOUNT CAN'T BE EMPTY");
textBox3.Select();
textBox3.Focus();
return;
}
if (comboBox2.Text == "CHEQUE" && textBox5.Text == "")
{
MessageBox.Show("ENTER CHEQUE NUMBER");
textBox5.Select();
textBox5.Focus();
return;
}
Temp1.Open(@"select * from payments", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
Temp1.AddNew();
Temp1.Fields["payID"].Value = Int64.Parse(textBox1.Text);
Temp2.Open("SELECT * FROM customerdetails WHERE CName='" + comboBox1.Text + "'", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic);
Temp1.Fields["custID"].Value = Temp2.Fields["cID"].Value;
if (comboBox2.Text == "CASH")
{
Temp1.Fields["paytype"].Value = "CASH";
}
else
{
Temp1.Fields["paytype"].Value = "CHEQUE : " + textBox5.Text;
}
Temp1.Fields["payday"].Value = dateTimePicker1.Value.ToShortDateString();
Temp1.Fields["amount"].Value = Int64.Parse(textBox3.Text);
Temp1.Fields["discount"].Value = Int64.Parse(textBox4.Text);
Temp1.Fields["payamount"].Value = Int64.Parse(textBox4.Text) + Int64.Parse(textBox3.Text);
Temp1.Update();
Temp1.Close();
Temp2.Fields["cbalance"].Value = Temp2.Fields["cbalance"].Value - (Int64.Parse(textBox4.Text) + Int64.Parse(textBox3.Text));
Temp2.Update();
Temp2.Close();
MessageBox.Show("PAYMENT SUCCESSFUL");
textBox4.Text = "0";
textBox3.Text = "0";
textBox2.Text = "0";
textBox5.Text = "";
comboBox1.SelectedIndex = -1;
comboBox2.SelectedIndex = -1;
textBox1.Text = (Int64.Parse(textBox1.Text) + 1).ToString();
}
protected void UpdateEntity(string Entity, string ID, string Field, string Value)
{
object oMissing = System.Reflection.Missing.Value;
//get the DataService to get a connection string to the database
Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>();
ADODB.Connection objConn = new ADODB.Connection();
ADODB.Recordset objRS = new ADODB.Recordset();
string strSQL = "SELECT " + Field + " FROM " + Entity + " WHERE " +Entity + "ID = '" + ID + "'";
try
{
objConn.Open(datasvc.GetConnectionString(),null, null,0 );
objRS.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
objRS.CursorType = ADODB.CursorTypeEnum.adOpenDynamic;
objRS.LockType = ADODB.LockTypeEnum.adLockOptimistic;
objRS.Open(strSQL, objConn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic,-1);
if (!objRS.EOF)
{
//updating
try
{
objRS.Fields[Field].Value = Value;
}
catch (Exception ex)
{
}
}
objRS.Update(oMissing ,oMissing );
objRS.Close();
}
catch (Exception ex)
{
}
}
/// <param name="file"></param>
public static void WriteData(string file)
{
//Objekt aus XML-File erstellenaa
XmlSerializer serializer = new XmlSerializer(typeof(results));
results resultingMessage = (results)serializer.Deserialize(new XmlTextReader(file));
//Recordset
ADODB.Connection cn = new ADODB.Connection();
ADODB.Recordset rs = new ADODB.Recordset();
ADODB.Recordset rsDelete = new ADODB.Recordset();
string cnStr;
//Connection string.
cnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PPS-Datenbank.mdb";
//Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
try
{
cn.Open(cnStr);
}
catch (Exception test)
{
string dbFehler = Thread.CurrentThread.CurrentUICulture.Name == "de" ? "Datenbank konnte nicht geöffnet werden!" : "Database could not be loaded";
MessageBox.Show(dbFehler + " " + test);
}
//Überprüfung ob Periode drin
try
{
rs.Open("Select * From warehousestock_article WHERE period = '" + resultingMessage.period + "'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (!rs.EOF)
{
string periodeFehler = Thread.CurrentThread.CurrentUICulture.Name == "de" ? "Diese Periode wurde bereits importiert!" : "You can not import a period twice.";
MessageBox.Show(periodeFehler);
return;
}
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle warehousestock_article
try
{
rs.Open("Select * From warehousestock_article", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsWarehousestockArticle myElement in resultingMessage.warehousestock.article)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["amount"].Value = myElement.amount;
rs.Fields["startamount"].Value = myElement.startamount;
rs.Fields["pct"].Value = myElement.pct;
rs.Fields["price"].Value = myElement.price;
rs.Fields["stockvalue"].Value = myElement.stockvalue;
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle warehousestock_totalvalue
try
{
rs.Open("Select * From warehousestock_totalvalue", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["stockvalue"].Value = resultingMessage.warehousestock.totalstockvalue;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle inwardstockmovement
try
{
rs.Open("Select * From inwardstockmovement", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsOrder myElement in resultingMessage.inwardstockmovement)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["orderperiod"].Value = myElement.orderperiod;
rs.Fields["mode"].Value = myElement.mode;
rs.Fields["article"].Value = myElement.article;
rs.Fields["amount"].Value = myElement.amount;
rs.Fields["time"].Value = myElement.time;
rs.Fields["materialcosts"].Value = myElement.materialcosts;
rs.Fields["ordercosts"].Value = myElement.ordercosts;
rs.Fields["entirecosts"].Value = myElement.entirecosts;
rs.Fields["piececosts"].Value = myElement.piececosts;
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle futureinwardstockmovement
try
{
rs.Open("Select * From futureinwardstockmovement", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsOrder1 myElement in resultingMessage.futureinwardstockmovement)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["orderperiod"].Value = myElement.orderperiod;
rs.Fields["mode"].Value = myElement.mode;
rs.Fields["article"].Value = myElement.article;
rs.Fields["amount"].Value = myElement.amount;
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle idletimecosts_workplace
try
{
rs.Open("Select * From idletimecosts_workplace", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsIdletimecostsWorkplace myElement in resultingMessage.idletimecosts.workplace)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["setupevents"].Value = myElement.setupevents;
rs.Fields["idletime"].Value = myElement.idletime;
rs.Fields["wageidletimecosts"].Value = myElement.wageidletimecosts;
rs.Fields["wagecosts"].Value = myElement.wagecosts;
rs.Fields["machineidletimecosts"].Value = myElement.machineidletimecosts;
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle idletimecosts_sum
try
{
rs.Open("Select * From idletimecosts_sum", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["setupevents"].Value = resultingMessage.idletimecosts.sum.setupevents;
rs.Fields["idletime"].Value = resultingMessage.idletimecosts.sum.idletime;
rs.Fields["wageidletimecosts"].Value = resultingMessage.idletimecosts.sum.wageidletimecosts;
rs.Fields["wagecosts"].Value = resultingMessage.idletimecosts.sum.wagecosts;
rs.Fields["machineidletimecosts"].Value = resultingMessage.idletimecosts.sum.machineidletimecosts;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle waitinglistworkstations
try
{
rs.Open("Select * From waitinglistworkstations", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsWorkplace myElement in resultingMessage.waitinglistworkstations)
{
if (myElement.waitinglist == null)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["timeneed_sum"].Value = myElement.timeneed;
}
else
{
foreach (resultsWorkplaceWaitinglist myUnterelement in myElement.waitinglist)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["timeneed_sum"].Value = myElement.timeneed;
rs.Fields["period_wp"].Value = myUnterelement.period;
rs.Fields["order"].Value = myUnterelement.order;
rs.Fields["firstbatch"].Value = myUnterelement.firstbatch;
rs.Fields["lastbatch"].Value = myUnterelement.lastbatch;
rs.Fields["item"].Value = myUnterelement.item;
rs.Fields["amount"].Value = myUnterelement.amount;
rs.Fields["timeneed"].Value = myUnterelement.timeneed;
}
}
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//TODO WaitinglistStock
try
{
rs.Open("Select * From waitingliststock", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsMissingpart missingpart in resultingMessage.waitingliststock)
{
foreach (resultsMissingpartWaitinglist myWaitingListElement in missingpart.waitinglist)
{
rs.AddNew();
rs.Fields["missingpart"].Value = missingpart.id;
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["item"].Value = myWaitingListElement.item;
rs.Fields["amount"].Value = myWaitingListElement.amount;
rs.Fields["order"].Value = myWaitingListElement.order;
rs.Fields["firstbatch"].Value = myWaitingListElement.firstbatch;
rs.Fields["lastbatch"].Value = myWaitingListElement.lastbatch;
}
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//TODO orders inwrok mit liste?
//Tabelle ordersinwork
try
{
rs.Open("Select * From ordersinwork", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsWorkplace1 myElement in resultingMessage.ordersinwork)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["period_oiw"].Value = myElement.period;
rs.Fields["order"].Value = myElement.order;
rs.Fields["batch"].Value = myElement.batch;
rs.Fields["item"].Value = myElement.item;
rs.Fields["amount"].Value = myElement.amount;
rs.Fields["timeneed"].Value = myElement.timeneed;
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle completedorders
try
{
rs.Open("Select * From completedorders", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsOrder2 myElement in resultingMessage.completedorders)
{
foreach (resultsOrderBatch myUnterelement in myElement.batch)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["o_period"].Value = myElement.period;
rs.Fields["o_id"].Value = myElement.id;
rs.Fields["o_item"].Value = myElement.item;
rs.Fields["o_quantity"].Value = myElement.quantity;
rs.Fields["o_cost"].Value = myElement.cost;
rs.Fields["o_averageunitcosts"].Value = myElement.averageunitcosts;
rs.Fields["b_id"].Value = myUnterelement.id;
rs.Fields["b_amount"].Value = myUnterelement.amount;
rs.Fields["b_cycletime"].Value = myUnterelement.cycletime;
rs.Fields["b_cost"].Value = myUnterelement.cost;
}
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle cycletimes
try
{
rs.Open("Select * From cycletimes", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["startedorders"].Value = resultingMessage.cycletimes.startedorders;
rs.Fields["waitingorders"].Value = resultingMessage.cycletimes.waitingorders;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle cycletimes_order
try
{
rs.Open("Select * From cycletimes_order", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
foreach (resultsCycletimesOrder myElement in resultingMessage.cycletimes.order)
{
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["id"].Value = myElement.id;
rs.Fields["period_order"].Value = myElement.period;
rs.Fields["starttime"].Value = myElement.starttime;
rs.Fields["finishtime"].Value = myElement.finishtime;
rs.Fields["cycletimemin"].Value = myElement.cycletimemin;
rs.Fields["cycletimefactor"].Value = myElement.cycletimefactor;
}
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle general
try
{
rs.Open("Select * From tbl_general", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["capacity_current"].Value = resultingMessage.result.general.capacity.current;
rs.Fields["capacity_average"].Value = resultingMessage.result.general.capacity.average;
rs.Fields["capacity_all"].Value = resultingMessage.result.general.capacity.all;
rs.Fields["possiblecapacity_current"].Value = resultingMessage.result.general.possiblecapacity.current;
rs.Fields["possiblecapacity_average"].Value = resultingMessage.result.general.possiblecapacity.average;
rs.Fields["possiblecapacity_all"].Value = resultingMessage.result.general.possiblecapacity.all;
rs.Fields["relpossiblenormalcapacity_current"].Value = resultingMessage.result.general.relpossiblenormalcapacity.current;
rs.Fields["relpossiblenormalcapacity_average"].Value = resultingMessage.result.general.relpossiblenormalcapacity.average;
rs.Fields["relpossiblenormalcapacity_all"].Value = resultingMessage.result.general.relpossiblenormalcapacity.all;
rs.Fields["productivetime_current"].Value = resultingMessage.result.general.productivetime.current;
rs.Fields["productivetime_average"].Value = resultingMessage.result.general.productivetime.average;
rs.Fields["productivetime_all"].Value = resultingMessage.result.general.productivetime.all;
rs.Fields["effiency_current"].Value = resultingMessage.result.general.effiency.current;
rs.Fields["effiency_average"].Value = resultingMessage.result.general.effiency.average;
rs.Fields["effiency_all"].Value = resultingMessage.result.general.effiency.all;
rs.Fields["sellwish_current"].Value = resultingMessage.result.general.sellwish.current;
rs.Fields["sellwish_average"].Value = resultingMessage.result.general.sellwish.average;
rs.Fields["sellwish_all"].Value = resultingMessage.result.general.sellwish.all;
rs.Fields["salesquantity_current"].Value = resultingMessage.result.general.salesquantity.current;
rs.Fields["salesquantity_average"].Value = resultingMessage.result.general.salesquantity.average;
rs.Fields["salesquantity_all"].Value = resultingMessage.result.general.salesquantity.all;
rs.Fields["deliveryreliability_current"].Value = resultingMessage.result.general.deliveryreliability.current;
rs.Fields["deliveryreliability_average"].Value = resultingMessage.result.general.deliveryreliability.average;
rs.Fields["deliveryreliability_all"].Value = resultingMessage.result.general.deliveryreliability.all;
rs.Fields["idletime_current"].Value = resultingMessage.result.general.idletime.current;
rs.Fields["idletime_average"].Value = resultingMessage.result.general.idletime.average;
rs.Fields["idletime_all"].Value = resultingMessage.result.general.idletime.all;
rs.Fields["idletimecosts_current"].Value = resultingMessage.result.general.idletimecosts.current;
rs.Fields["idletimecosts_average"].Value = resultingMessage.result.general.idletimecosts.average;
rs.Fields["idletimecosts_all"].Value = resultingMessage.result.general.idletimecosts.all;
rs.Fields["storevalue_current"].Value = resultingMessage.result.general.storevalue.current;
rs.Fields["storevalue_average"].Value = resultingMessage.result.general.storevalue.average;
rs.Fields["storevalue_all"].Value = resultingMessage.result.general.storevalue.all;
rs.Fields["storagecosts_current"].Value = resultingMessage.result.general.storagecosts.current;
rs.Fields["storagecosts_average"].Value = resultingMessage.result.general.storagecosts.average;
rs.Fields["storagecosts_all"].Value = resultingMessage.result.general.storagecosts.all;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle normalsale
try
{
rs.Open("Select * From normalsale", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["salesprice_current"].Value = resultingMessage.result.normalsale.salesprice.current;
rs.Fields["salesprice_average"].Value = resultingMessage.result.normalsale.salesprice.average;
rs.Fields["salesprice_all"].Value = resultingMessage.result.normalsale.salesprice.all;
rs.Fields["profit_current"].Value = resultingMessage.result.normalsale.profit.current;
rs.Fields["profit_average"].Value = resultingMessage.result.normalsale.profit.average;
rs.Fields["profit_all"].Value = resultingMessage.result.normalsale.profit.all;
rs.Fields["profitperunit_current"].Value = resultingMessage.result.normalsale.profitperunit.current;
rs.Fields["profitperunit_average"].Value = resultingMessage.result.normalsale.profitperunit.average;
rs.Fields["profitperunit_all"].Value = resultingMessage.result.normalsale.profitperunit.all;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle directsale
try
{
rs.Open("Select * From directsale", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["profit_current"].Value = resultingMessage.result.directsale.profit.current;
rs.Fields["profit_average"].Value = resultingMessage.result.directsale.profit.average;
rs.Fields["profit_all"].Value = resultingMessage.result.directsale.profit.all;
rs.Fields["contractpenalty_current"].Value = resultingMessage.result.directsale.contractpenalty.current;
rs.Fields["contractpenalty_average"].Value = resultingMessage.result.directsale.contractpenalty.average;
rs.Fields["contractpenalty_all"].Value = resultingMessage.result.directsale.contractpenalty.all;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle marketplacesale
try
{
rs.Open("Select * From marketplacesale", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["profit_current"].Value = resultingMessage.result.marketplacesale.profit.current;
rs.Fields["profit_average"].Value = resultingMessage.result.marketplacesale.profit.average;
rs.Fields["profit_all"].Value = resultingMessage.result.marketplacesale.profit.all;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
//Tabelle summary
try
{
rs.Open("Select * From summary", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rs.AddNew();
rs.Fields["period"].Value = resultingMessage.period;
rs.Fields["profit_current"].Value = resultingMessage.result.summary.profit.current;
rs.Fields["profit_average"].Value = resultingMessage.result.summary.profit.average;
rs.Fields["profit_all"].Value = resultingMessage.result.summary.profit.all;
rs.Update();
}
catch (Exception)
{
}
finally
{
rs.Close();
}
/// <summary>
/// Überflüssige Werte aus der DB löschen, wenn Initialer Stand hochgeladen wird
/// </summary>
try
{
rs.Open("Select distinct period from warehousestock_article ORDER BY period Desc", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
int periode = Convert.ToInt32(rs.Fields["period"].Value);
if (periode == 0)
{
rsDelete.Open("Delete From inwardstockmovement", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From futureinwardstockmovement Where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
//rsDelete.Open("Delete From idletimecosts", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From idletimecosts_workplace where period ='0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From idletimecosts_sum where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From waitinglistworkstations where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From waitingliststock where period = 0", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From ordersinwork where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From completedorders where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From cycletimes where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From cycletimes_order where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From tbl_general where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From normalsale where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From directsale where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From marketplacesale where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
rsDelete.Open("Delete From summary where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);
}
}
catch (Exception test)
{
MessageBox.Show(test.Message);
}
finally
{
rs.Close();
}
MessageBox.Show("XML-File importiert");
cn.Close();
}
private void btnsave_Click(object sender, EventArgs e)
{
ADODB.Recordset tmp = new ADODB.Recordset();
try
{
if (!Program.session_valid(dt1.Value.Date.ToString("yyyy-MM-dd")))
{
MessageBox.Show("There is no valid Finance Session Found, Please check the Entry Date or Contact Admin ", "Invalid Transaction Date ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (ADOconn.State == 0)
{
ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0);
}
ADODB.Recordset rec = new ADODB.Recordset();
Conn.Close();
// Conn.Open();
bool isempty;
isempty = false;
if (isedit)
{
if (txtpriv.Text.Substring(1, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
else
{
if (txtpriv.Text.Substring(0, 1) == "0")
{
MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges ");
return;
}
}
//if (isempty)
//{
// MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry");
// return;
//}
try
{
// ADOconn.BeginTrans();
// if (!isedit)
// {
// if (txtismanual.Text == "0")
// {
// gen_accno();
// tmp = new ADODB.Recordset();
// sql = "update ACC_TYPE SET CUR_NO = CUR_NO+1 WHERE ACC_TYPE_CODE=" + cmbtype.SelectedValue;
// tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
// }
// }
if (txtsalacno.Text == "")
{
MessageBox.Show("Invalid Salary Account Number, Please Enter a Valid Number", "Invalid Entry");
return;
}
if (cmbmonth.SelectedIndex < 0)
{
MessageBox.Show("Invalid Salary Month, Please Select a Valid Month", "Invalid Entry");
return;
}
if (txtnet.Text.Trim() == "")
{
txtnet.Text = "0";
}
// //if (txtvalue.Text.Trim() == "") txtvalue.Text = "0";
isini = true;
if (txtbasic.Text == "")
{
txtbasic.Text = "0";
}
if (txtempid.Text == "")
{
txtempid.Text = "0";
}
if (txthousing.Text == "")
{
txthousing.Text = "0";
}
if (txttransport.Text == "")
{
txttransport.Text = "0";
}
if (txtother.Text == "")
{
txtother.Text = "0";
}
if (txtdeduction.Text == "")
{
txtdeduction.Text = "0";
}
if (txtloan.Text == "")
{
txtloan.Text = "0";
}
if (txtcontractno.Text == "")
{
txtcontractno.Text = "0";
}
if (txtworkeddays.Text == "")
{
txtworkeddays.Text = "0";
}
if (txtnet.Text == "")
{
txtnet.Text = "0";
}
if (txtsalacno.Text == "")
{
txtsalacno.Text = "0";
}
if (txtempid.Text == "")
{
txtempid.Text = "0";
}
if (txtpaidamt.Text == "")
{
txtpaidamt.Text = "0";
}
if (txtbrncode.Text == "")
{
txtbrncode.Text = Gvar.brn_code.ToString();
}
if (txtcontractno.Text == "0")
{
MessageBox.Show("Invalid Contract Numebr, Please check and Try Again", "Invalid Entry");
return;
}
if (Convert.ToDecimal(txtpaidamt.Text) > Convert.ToDecimal(txtnet.Text))
{
MessageBox.Show("There is already a higher Paid amount found, Please check and Try Again", "Invalid Entry");
return;
}
isini = false;
find_total();
//rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim());
ADOconn.BeginTrans();
int TRN_BY = 13;
sql = "select * from TRN_accounts where trn_NO = '" + txtactrnno.Text.Trim() + "' AND TRN_BY = 13 and Sno = 1";
rec = new ADODB.Recordset();
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
long trnno = 0;
long trnno2 = 0;
if (rec.RecordCount == 0)
{
rec.AddNew();
tmp = new ADODB.Recordset();
sql = "SELECT * FROM TRNNO";
tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
//if (tmp.Fields[0].Value)
// txttrn.Text="1";
//else
if (tmp.Fields[0].Value == DBNull.Value)
{
trnno = 1;
}
else
{
trnno = Convert.ToInt64(tmp.Fields[0].Value.ToString());
trnno2 = trnno + 1;
}
rec.Fields["trn_no"].Value = trnno;
rec.Fields["trn_no2"].Value = trnno + 1;
}
trnno = Convert.ToInt64(rec.Fields["trn_no"].Value);
double amt = Convert.ToDouble(txtnet.Text);
long doc_no = -1 * trnno;
string DR_CR = "D";
string DR_CR1 = "C";
rec.Fields["acc_no"].Value = txtempacno.Text;
rec.Fields["EntrY_no"].Value = 0;
double rate = 1;
rec.Fields["PAY_AMOUNT"].Value = Math.Abs(amt * rate);
rec.Fields["F_PAY_AMOUNT"].Value = Math.Abs(amt);
rec.Fields["F_RATE"].Value = 1;
rec.Fields["TRN_BY"].Value = TRN_BY;
rec.Fields["DR_CR"].Value = DR_CR;
rec.Fields["user_ID"].Value = Gvar.Userid;
rec.Fields["PAYBY"].Value = txtsalacno.Text;
//rec.Fields["RQTY"].Value = 0;
rec.Fields["SNO"].Value = 1;
// rec.Fields["FRACTION"].Value = dgv1["fraction", i].Value;
rec.Fields["NARRATION"].Value = "Salary Process of " + cmbmonth.Text;
rec.Fields["Voucher_No"].Value = 0;
rec.Fields["cost_code"].Value = 0;
rec.Fields["dept_code"].Value = 0;
rec.Fields["pay_date"].Value = dt1.Value;
rec.Fields["doc_no"].Value = doc_no;
rec.Fields["NYEAR"].Value = dt1.Value.Year;
rec.Fields["brn_code"].Value = Gvar.brn_code;
rec.Fields["currency"].Value = "SR";
rec.Fields["brn_code"].Value = txtbrncode.Text;
rec.Fields["trn_type"].Value = TRN_BY;
rec.Update();
sql = "select * from TRN_accounts where trn_NO2 = '" + txtactrnno.Text.Trim() + "' AND TRN_BY = 13 and Sno = 2";
rec = new ADODB.Recordset();
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
rec.AddNew();
tmp = new ADODB.Recordset();
sql = "SELECT * FROM TRNNO";
tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
//if (tmp.Fields[0].Value)
// txttrn.Text="1";
//else
if (tmp.Fields[0].Value == DBNull.Value)
{
trnno2 = 1;
}
else
{
trnno2 = Convert.ToInt64(tmp.Fields[0].Value.ToString());
}
rec.Fields["trn_no"].Value = trnno2;
rec.Fields["trn_no2"].Value = trnno;
}
trnno2 = Convert.ToInt64(rec.Fields["trn_no"].Value);
rec.Fields["acc_no"].Value = txtsalacno.Text;
rec.Fields["EntrY_no"].Value = 0;
rec.Fields["PAY_AMOUNT"].Value = Math.Abs(amt * rate);
rec.Fields["F_PAY_AMOUNT"].Value = Math.Abs(amt);
rec.Fields["F_RATE"].Value = 1;
rec.Fields["TRN_BY"].Value = TRN_BY;
rec.Fields["DR_CR"].Value = DR_CR1;
rec.Fields["user_ID"].Value = Gvar.Userid;
rec.Fields["PAYBY"].Value = txtempacno.Text;
//rec.Fields["RQTY"].Value = 0;
rec.Fields["SNO"].Value = 2;
// rec.Fields["FRACTION"].Value = dgv1["fraction", i].Value;
rec.Fields["NARRATION"].Value = "Salary Process of " + cmbmonth.Text + " for " + lblname.Text;
rec.Fields["Voucher_No"].Value = 0;
rec.Fields["cost_code"].Value = 0;
rec.Fields["dept_code"].Value = 0;
rec.Fields["pay_date"].Value = dt1.Value;
rec.Fields["doc_no"].Value = doc_no;
rec.Fields["NYEAR"].Value = dt1.Value.Year;
rec.Fields["brn_code"].Value = txtbrncode.Text;
rec.Fields["trn_type"].Value = TRN_BY;
rec.Fields["currency"].Value = "SR";
rec.Update();
rec = new ADODB.Recordset();
sql = "SELECT * FROM salary_det where salary_month = '" + cmbmonth.Text + "' and emp_id =" + txtempid.Text;
// sql = "SELECT * FROM Accounts where Acc_no ='" + txtaccno.Text.Trim() + "'";
rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1);
if (rec.RecordCount == 0)
{
rec.AddNew();
}
rec.Fields["EMP_ID"].Value = txtempid.Text.Trim();
rec.Fields["SALARY_MONTH"].Value = cmbmonth.Text.Trim();
rec.Fields["EFFECT_DATE"].Value = dt1.Value.Date.ToString("yyyy-MM-dd");
rec.Fields["FULLNAME"].Value = lblname.Text;
rec.Fields["BASIC"].Value = txtbasic.Text;
rec.Fields["HOUSING"].Value = txthousing.Text.Trim();
rec.Fields["TRANSPORTATION"].Value = txttransport.Text.Trim();
rec.Fields["OTHER"].Value = txtother.Text.Trim();
rec.Fields["DEDUCTION"].Value = txtdeduction.Text.Trim();
rec.Fields["LOAN_AMT"].Value = txtloan.Text.Trim();
rec.Fields["REMARKS"].Value = txtremarks.Text.Trim();
rec.Fields["NET_AMOUNT"].Value = txtnet.Text.Trim();
rec.Fields["SAL_ACNO"].Value = txtsalacno.Text.Trim();
rec.Fields["EMP_ACNO"].Value = txtempacno.Text.Trim();
rec.Fields["worked_days"].Value = txtworkeddays.Text.Trim();
rec.Fields["CONTRACT_ID"].Value = txtcontractno.Text.Trim();
rec.Fields["NYEAR"].Value = dt1.Value.Year.ToString();
rec.Fields["TRN_NO1"].Value = trnno;
rec.Fields["TRN_NO2"].Value = trnno2;
rec.Fields["EMP_BraNCH"].Value = txtbrncode.Text.Trim();
rec.Update();
ADOconn.CommitTrans();
populate_empdet();
//DataGridViewRow row = dgv1.CurrentRow;
//if (txtempid.Text.ToString() == dgv1[1, dgv1.CurrentRow.Index].Value.ToString())
//{
// dgv1.Rows.Remove(row);
//}
isedit = true;
MessageBox.Show("Successfully Saved");
}
catch (Exception ex)
{
ADOconn.RollbackTrans();
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
