protected void loadUsers()
{
ClsITBA ba = new ClsITBA();
List <clsEDISpecialist> qShipMeth = SrvEDISpecialist.GetEDISpecialistView();
rgITBA.DataSource = qShipMeth;
}
public string InsertITBA(ClsITBA data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblITBA oNewRow = new tblITBA()
{
ITBAemail = data.ITBAEmail,
idEmployee = data.idEmployee,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag,
ReceiveNewReqEmail = data.ReceiveNewReqEmail,
login = data.login
};
puroTouchContext.GetTable <tblITBA>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
protected void loadUsers()
{
ClsITBA ba = new ClsITBA();
List <ClsITBA> itbaList = rep.GetITBAs();
rgITBA.DataSource = itbaList;
}
protected void GetITBAandEDICombined()
{
try
{
List <ClsITBA> FullList = repository.GetITBAandEDICombined();
List <int> EmployeeIDs = FullList.GroupBy(p => p.idEmployee).Select(p => p.Key).ToList();
List <ClsITBA> balist = new List <ClsITBA>();
foreach (int i in EmployeeIDs)
{
balist.Add(FullList.Where(p => p.idEmployee == i).FirstOrDefault());
}
ClsITBA all = new ClsITBA();
all.ITBA = "All";
all.idITBA = 0;
balist.Insert(0, all);
rddlITBA.DataSource = balist;
rddlITBA.DataTextField = "ITBA";
rddlITBA.DataValueField = "idITBA";
rddlITBA.DataBind();
rddlITBA.SelectedIndex = 0;
}
catch (Exception ex)
{
var msg = ex.Message;
pnlDanger.Visible = true;
lblDanger.Text = msg;
}
}
private ClsITBA populateObj(UserControl userControl)
{
ClsITBA oRow = new ClsITBA();
oRow.ITBAEmail = (userControl.FindControl("txtEmail") as RadTextBox).Text;
oRow.idEmployee = Convert.ToInt16((userControl.FindControl("rddlEmployee") as RadDropDownList).SelectedValue);
oRow.ITBAName = (userControl.FindControl("rddlEmployee") as RadDropDownList).SelectedText;
oRow.ActiveFlag = (userControl.FindControl("ActiveFlag") as RadButton).Checked;
oRow.ReceiveNewReqEmail = (userControl.FindControl("NewReqEmail") as RadButton).Checked;
oRow.login = (userControl.FindControl("txtLogin") as RadTextBox).Text;
oRow.UpdatedBy = (string)(Session["userName"]);
oRow.UpdatedOn = Convert.ToDateTime(DateTime.Now);
return(oRow);
}
public ClsITBA GetITBA(int idITBA)
{
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
ClsITBA oITBA = (from data in puroTouchContext.GetTable <vw_ITBA>()
where data.idITBA == idITBA
select new ClsITBA
{
idITBA = data.idITBA,
ITBAName = data.ITBA,
ITBA = data.ITBA,
ITBAEmail = data.ITBAemail,
idEmployee = data.idEmployee,
ReceiveNewReqEmail = data.ReceiveNewReqEmail,
login = data.login,
EDIFlag = data.EDIFlag
}).FirstOrDefault();
return(oITBA);
}
public string UpdateITBA(ClsITBA data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idEmployee > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblITBA>()
where qdata.idEmployee == data.idEmployee
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblITBA updRow in query)
{
updRow.ITBAemail = data.ITBAEmail;
updRow.idEmployee = data.idEmployee;
updRow.ActiveFlag = data.ActiveFlag;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
updRow.ReceiveNewReqEmail = data.ReceiveNewReqEmail;
updRow.login = data.login;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Product with ID = " + "'" + data.idEmployee + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
//protected void rgITBA_DeleteCommand(object source, GridCommandEventArgs e)
//{
//}
protected void rgITBA_UpdateCommand(object source, GridCommandEventArgs e)
{
try
{
UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
Label errorMsg = (Label)userControl.FindControl("lblErrorMessage");
ClsITBA oRow = populateObj(userControl);
oRow.idITBA = Convert.ToInt16((userControl.FindControl("hdnITBAID") as HiddenField).Value);
string updateMsg = "";
if (IsValid)
{
if (oRow != null)
{
updateMsg = cls.UpdateITBA(oRow);
if (updateMsg == "")
{
//pnlsuccess.Visible = true;
lblSuccess.Text = "Successfully updated information for " + "'" + oRow.ITBAName + "'";
}
else
{
errorMsg.Visible = true;
errorMsg.Text = updateMsg;
e.Canceled = true;
}
}
}
else
{
// display error
errorMsg.Visible = true;
errorMsg.Text = "Please enter Required fields";
e.Canceled = true;
}
}
catch (Exception ex)
{
pnlDanger.Visible = true;
lblDanger.Text = ex.Message.ToString();
e.Canceled = true;
}
}
protected void rgITBA_InsertCommand(object sender, GridCommandEventArgs e)
{
try
{
UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
Label errorMsg = (Label)userControl.FindControl("lblErrorMessage");
ClsITBA oRow = populateObj(userControl);
string insertMsg = "";
if (IsValid)
{
if (oRow != null)
{
insertMsg = cls.InsertITBA(oRow);
if (insertMsg == "")
{
//pnlsuccess.Visible = true;
lblSuccess.Text = "Successfully Added New Record " + oRow.ITBAName;
}
else
{
errorMsg.Visible = true;
errorMsg.Text = insertMsg;
e.Canceled = true;
}
}
}
else
{
// display error
errorMsg.Visible = true;
errorMsg.Text = "Please enter Required fields";
e.Canceled = true;
}
}
catch (Exception ex)
{
pnlDanger.Visible = true;
lblDanger.Text = ex.Message.ToString();
e.Canceled = true;
}
}
protected void getITBAs()
{
try
{
List <ClsITBA> balist = repository.GetITBAs();
ClsITBA all = new ClsITBA();
all.ITBA = "All";
all.idITBA = 0;
balist.Insert(0, all);
rddlITBA.DataSource = balist;
rddlITBA.DataTextField = "ITBA";
rddlITBA.DataValueField = "idITBA";
rddlITBA.DataBind();
rddlITBA.SelectedIndex = 0;
}
catch (Exception ex)
{
var msg = ex.Message;
pnlDanger.Visible = true;
lblDanger.Text = msg;
}
}
