public void UpdateNotes()
{
bool saved = false;
var ta = new NOTESMASTTableAdapter {Connection = {ConnectionString = _constr}};
saved = ta.Update(DNotesmastRow) > 0;
}
public void SaveNotes()
{
bool saved = false;
var ta = new NOTESMASTTableAdapter {Connection = {ConnectionString = _constr}};
saved = ta.Insert(Notes, Supid, Sourceid, Utils.Userid, System.DateTime.Now, Utils.Company) > 0;
}
public void GetNotes(string supid,int sourceid)
{
var ta = new NOTESMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsInventory().NOTESMAST;
ta.FillByID(ds, supid, sourceid);
foreach (DsInventory.NOTESMASTRow d in ds.Rows)
{
DNotesmastRow = d;
}
}
public bool DeleteNotes(int noteid)
{
var ta = new NOTESMASTTableAdapter { Connection = { ConnectionString = _constr } };
return ta.DeleteQuery(noteid) > 0;
}
public int GetNotesCount(string supid,int sourceid)
{
var ta = new NOTESMASTTableAdapter {Connection = {ConnectionString = _constr}};
return ta.GetNotesCount(supid, sourceid) ?? 0;
}
