public static void ReleaseLock(YellowstonePathology.Business.Domain.KeyLock keyLock, YellowstonePathology.Business.User.SystemUser systemUser)
{
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand("Delete tblLock where LockedBy = @UserName and KeyString = @KeyString");
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = systemUser.UserName;
cmd.Parameters.Add("@KeyString", SqlDbType.VarChar).Value = keyLock.Key;
cmd.ExecuteNonQuery();
}
}
public static void GetLock(YellowstonePathology.Business.Domain.KeyLock keyLock, YellowstonePathology.Business.User.SystemUser systemUser, YellowstonePathology.Business.Domain.Lock theLock)
{
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "pSetLock";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@KeyString", SqlDbType.VarChar).Value = keyLock.Key;
cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = systemUser.UserName;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
theLock.LockDate = dr.GetValue(1) as Nullable <DateTime>;
theLock.LockedBy = dr.GetValue(2) as string;
}
}
}
}
public Lock(YellowstonePathology.Business.User.SystemIdentity systemIdentity)
{
this.m_SystemIdentity = systemIdentity;
this.m_LockImage = this.m_LockedImagePath;
this.m_KeyLock = new KeyLock();
}
public Lock(YellowstonePathology.Business.User.SystemIdentity systemIdentity)
{
this.m_SystemIdentity = systemIdentity;
this.m_LockImage = this.m_LockedImagePath;
this.m_KeyLock = new KeyLock();
}
