public static void SetScreenshot(int extension, string path, Bitmap bitmap)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), extension);
return;
}
string command = "UPDATE phone SET "
+ "ScreenshotPath = '" + POut.String(path) + "', "
+ "ScreenshotImage = '" + POut.Bitmap(bitmap, ImageFormat.Png) + "' "//handles null
+ "WHERE Extension = " + POut.Long(extension);
Db.NonQ(command);
}
///<summary>Bitmap can be null. Computername will override ipAddress.</summary>
public static void SetWebCamImage(string ipAddress, Bitmap bitmap, string computerName)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), ipAddress, bitmap, computerName);
return;
}
//if(ipAddress=="") {
// return;
//}
string command = "SELECT * FROM phoneempdefault WHERE ComputerName='" + POut.String(computerName) + "'";
PhoneEmpDefault ped = Crud.PhoneEmpDefaultCrud.SelectOne(command);
if (ped != null) //we found that computername entered as an override
{
command = "UPDATE phone SET "
+ "WebCamImage = '" + POut.Bitmap(bitmap, ImageFormat.Png) + "' " //handles null
+ "WHERE Extension = " + POut.Long(ped.PhoneExt);
Db.NonQ(command);
return;
}
//there is no computername override entered by staff, so figure out what the extension should be
int extension = 0;
if (ipAddress.Contains("192.168.0.2"))
{
extension = PIn.Int(ipAddress.ToString().Substring(10)) - 100; //eg 205-100=105
}
else if (ipAddress.ToString().Contains("10.10.20.1"))
{
extension = PIn.Int(ipAddress.ToString().Substring(9)); //eg 105
}
if (extension == 0)
{
//we don't have a good extension
return;
}
command = "UPDATE phone SET "
+ "WebCamImage = '" + POut.Bitmap(bitmap, ImageFormat.Png) + "' " //handles null
+ "WHERE Extension = " + POut.Long(extension) + " "
//Example: this is computer .204, and ext 104 has a computername override. Don't update ext 104.
+ "AND NOT EXISTS(SELECT * FROM phoneempdefault WHERE PhoneExt= " + POut.Long(extension) + " "
+ "AND ComputerName!='')"; //there exists a computername override for the extension
Db.NonQ(command);
}
