// public DsMaster.STOREMASTRow StoremastRow;
public string DoSave()
{
string retval="0";
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection {ConnectionString = _constr};
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var dt = new DsMaster().STOREMAST;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter();
ta.Connection.ConnectionString = _constr;
ta.Fill(dt);
ta.AssignConnection(cn, tran);
var dr = dt.FindBySTORECODE(storecode);
if (dr != null)
{
dr.BeginEdit();
dr.EditedBy = Utils.Userid;
}
else
{
dr = (DsMaster.STOREMASTRow) dt.NewRow();
isnew = true;
var autoid = new DataManager().GetAutoId(9);
autoid++;
storecode = String.Format("{0,-2:D2}", autoid);
dr.CREATEDBY = Utils.Userid;
dr.CREATEDATE = System.DateTime.Now.Date;
}
dr.STORECODE = storecode;
dr.STORETYPE = storetype;
dr.STORENAME = storename;
dr.ADDRESSS = address;
dr.PHONENO = phono;
dr.FAXNO = fax;
dr.COMM = communicationtype;
dr.COMPANY = COMPANY;
if (isnew)
{
dt.Rows.Add(dr);
ta.Update(dt);
}
else
{
dr.EndEdit();
ta.Update(dt);
}
new DataManager().UpdateAutoNum(9);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
if (tran != null) tran.Rollback();
}
return retval;
}
public DsMaster.STOREMASTDataTable GetAllSalesStore()
{
var dt = new DsMaster().STOREMAST;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter { Connection = { ConnectionString = _constr } };
ta.FillByALLSalesStore(dt);
return dt;
}
public DsMaster.STOREMASTDataTable GetMyWareHouses()
{
var dt = new DsMaster().STOREMAST;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter { Connection = { ConnectionString = _constr } };
ta.FillByMyWareHouse(dt,Utils.Company);
return dt;
}
public string GetStoreType(string scode)
{
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter {Connection = {ConnectionString = _constr}};
return ta.GetStoreType(scode).ToString();
}
public string GetSalesStore()
{
var retval = string.Empty;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster().STOREMAST;
ta.FillBySalesStore(ds, Utils.Company);
if (ds.Rows.Count > 0)
retval = ds[0][0].ToString();
return retval;
}
public string GetSalesStore()
{
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster().STOREMAST;
ta.FillBySalesStore(ds, Utils.Company);
string scode = string.Empty;
foreach (DataRow dr in ds.Rows)
{
scode = dr["STORECODE"].ToString();
}
return scode;
}
