private bool CheckIsServiceSessionTimeNoOverLap(int nEmployeeID, DateTime dtDateToBook,
DateTime dtStartTimeToBook, DateTime dtEndTimeToBook, string strBranchCode)
{
TblRoster roster = new TblRoster();
string cmdText = " Select Count(*) from tblServiceSession Where nServiceEmployeeID = @nEmployeeID and (nStatusID <> 7 AND nStatusID <> 6 AND nStatusID <> 1) " +
" and dtDate = @dtDate and " +
" ((@dtStartTimeToBook Between dtStartTime AND dtEndTime ) or (@dtEndTimeToBook Between dtStartTime AND dtEndTime))";
object obj = roster.ExecuteScalar(cmdText, new string[] { "@nEmployeeID", "@dtDate", "@dtStartTimeToBook", "@dtEndTimeToBook" },
new object[] { nEmployeeID, dtDateToBook, dtStartTimeToBook, dtEndTimeToBook });
if (obj != null)
{
Int32 r = (Int32)obj;
if (r > 0)
{
throw new Exception(" The Time period you choose is been used by others. Please choose other time period.");
}
else
{
return(true);
}
}
else
{
return(true);
}
}
private void btnOk_Click(object sender, System.EventArgs e)
{
DataRow row = gvRoster.GetDataRow(gvRoster.FocusedRowHandle);
ACMSDAL.TblRoster myRoster = new TblRoster();
myRoster.StrRemarks = row["strRemarks"].ToString();
myRoster.NRosterID = System.Convert.ToInt32(row["nRosterID"]);
myRoster.Update2();
}
private void Init()
{
myRoster = new TblRoster();
//myDataTable = myCategory.SelectAll();
}
