public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ContactPosition a where ");
ContactPosition contactposition = (ContactPosition)data;
if (contactposition != null)
{
Parms = new List <Object[]>();
if (contactposition.ContactPositionID != 0)
{
sql.Append(" a.ContactPositionID = :id and ");
Parms.Add(new Object[] { "id", contactposition.ContactPositionID });
}
if (!String.IsNullOrEmpty(contactposition.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", contactposition.Name });
}
//if (contactposition.Status != null && contactposition.Status.StatusID != 0)
//{
// sql.Append(" a.Status.StatusID= :id1 and ");
// Parms.Add(new Object[] { "id1", contactposition.Status.StatusID });
//}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.contactPositionID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public ActionResult ContactPositionDelete(int?id)
{
ContactPosition cp = db.ContactPosition.Find(id);
db.ContactPosition.Remove(cp);
db.SaveChanges();
return(RedirectToAction("ContactsDetails", new { id = cp.ContactID }));
}
public IList <ContactPosition> Select(ContactPosition data)
{
IList <ContactPosition> datos = new List <ContactPosition>();
datos = GetHsql(data).List <ContactPosition>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public ActionResult PositionCreate(ContactPosition contactPosition)
{
if (ModelState.IsValid)
{
contactPosition.DistKey = GlobalVariables.DistKey;
db.ContactPosition.Add(contactPosition);
db.SaveChanges();
return(RedirectToAction("ContactsEdit", new { id = contactPosition.ContactID }));
}
return(View(contactPosition));
}
public ActionResult PositionCreate(int ID)
{
ContactPosition newPosition = new ContactPosition();
newPosition.ContactID = ID;
newPosition.DistKey = GlobalVariables.DistKey;
SelectList PositionList = new SelectList(db.Positions.ToList(), "pKey", "PositionName", db.Positions);
ViewData["PositionList"] = PositionList;
SelectList GroupList = new SelectList(db.Groups.Where(x => x.DistKey == GlobalVariables.DistKey).ToList(), "pKey", "GroupName", db.Groups);
ViewData["GroupList"] = GroupList;
return(View("PositionCreate", newPosition));
}
// GET: Groups/Details/5
public ActionResult GroupsDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Groups group = db.Groups.Find(id);
GroupViewModel gvm = new GroupViewModel();
gvm.pKey = group.pKey;
gvm.group = group;
ContactPosition cp = db.ContactPosition.Where(x => x.DistKey == GlobalVariables.DistKey).Where(x => x.GroupID == group.pKey).Where(x => x.PositionID == 2).FirstOrDefault();
if (cp != null)
{
int GSRID = cp.ContactID;
gvm.contact = db.Contacts.Where(x => x.pKey == GSRID).FirstOrDefault();
}
return(View(gvm));
}
// GET: Groups
public ActionResult GroupsIndex()
{
List <GroupViewModel> gvmList = new List <GroupViewModel>();
var groupList = db.Groups.Where(x => x.DistKey == GlobalVariables.DistKey).ToList();
foreach (Groups group in groupList)
{
GroupViewModel gvm = new GroupViewModel();
gvm.group = group;
gvm.pKey = group.pKey;
ContactPosition cp = db.ContactPosition.Where(x => x.DistKey == GlobalVariables.DistKey).Where(x => x.GroupID == group.pKey).Where(x => x.PositionID == 2).FirstOrDefault();
if (cp != null)
{
int GSRID = cp.ContactID;
gvm.contact = db.Contacts.Where(x => x.pKey == GSRID).FirstOrDefault();
}
gvmList.Add(gvm);
}
return(View(gvmList));
}
public ContactPosition SaveContactPosition(ContactPosition data)
{
try {
SetService(); return SerClient.SaveContactPosition(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public void DeleteContactPosition(ContactPosition data)
{
try {
SetService(); SerClient.DeleteContactPosition(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public ContactPosition SelectById(ContactPosition data)
{
return((ContactPosition)base.SelectById(data));
}
public Boolean Delete(ContactPosition data)
{
return(base.Delete(data));
}
public Boolean Update(ContactPosition data)
{
return(base.Update(data));
}
public ContactPosition Save(ContactPosition data)
{
return((ContactPosition)base.Save(data));
}
