public DsMaster.PROFILESDataTable LoadProfiles(int profileid = 0)
{
var ta = new DsMasterTableAdapters.PROFILESTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster.PROFILESDataTable();
if (profileid == 0)
ta.Fill(ds);
else
{
ta.FillByProfileId(ds, profileid);
}
return ds;
}
public string DoSave()
{
string retval;
try
{
var cn = new SqlConnection {ConnectionString = _constr};
cn.Open();
var dt = new DsMaster().PROFILES;
bool isnew = false;
var ta = new DsMasterTableAdapters.PROFILESTableAdapter {Connection = cn};
ta.Fill(dt);
var dr = dt.FindByPROFILEID(ProfilenamesRow.PROFILEID);
if (dr != null)
{
dr.BeginEdit();
dr.EUSERID = Utils.Userid;
dr.EDATE = DateTime.Now.Date;
}
else
{
dr = (DsMaster.PROFILESRow) dt.NewRow();
isnew = true;
dr.PROFILEID = ProfilenamesRow.PROFILEID;
dr.CUSERID = Utils.Userid;
dr.CDATE = DateTime.Now.Date;
}
dr.DETAILS = ProfilenamesRow.DETAILS;
if (isnew)
{
dt.Rows.Add(dr);
ta.Update(dt);
}
else
{
dr.EndEdit();
ta.Update(dt);
}
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
}
return retval;
}
