/// <summary>
/// Create a new tbl_itsupport_arrangment object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="ref_personID">Initial value of the ref_personID property.</param>
public static tbl_itsupport_arrangment Createtbl_itsupport_arrangment(global::System.Int32 id, global::System.Int32 ref_personID)
{
tbl_itsupport_arrangment tbl_itsupport_arrangment = new tbl_itsupport_arrangment();
tbl_itsupport_arrangment.id = id;
tbl_itsupport_arrangment.ref_personID = ref_personID;
return(tbl_itsupport_arrangment);
}
public static bool InsertItSupportArrangement(int userID, int shiftID, string sProject, int nMonth, out string errmsg)
{
bool bOk = false;
using (FavLinkEntities context = new FavLinkEntities())
{
var items = from x in context.tbl_itsupport_arrangment
where x.ref_personID == userID &&
x.shift == shiftID &&
x.month == nMonth &&
0 == x.project.CompareTo(sProject)
select x;
if (items.Any())
{
errmsg = string.Format("The arrangement already exist!");
return(false);
}
//insert
var entity = new tbl_itsupport_arrangment()
{
ref_personID = userID,
shift = shiftID,
project = sProject,
month = nMonth,
};
try
{
context.tbl_itsupport_arrangment.AddObject(entity);
context.SaveChanges();
bOk = true;
errmsg = string.Empty;
}
catch (Exception ex)
{
errmsg = ex.Message;
}
}
return(bOk);
}
/// <summary>
/// Deprecated Method for adding a new object to the tbl_itsupport_arrangment EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotbl_itsupport_arrangment(tbl_itsupport_arrangment tbl_itsupport_arrangment)
{
base.AddObject("tbl_itsupport_arrangment", tbl_itsupport_arrangment);
}