string ICLRService.UpdateRoundingLogForRoom(CLRUpdateRoundingRoomEntity objCLRUpdateRoundingRoomEntity)
{
try
{
int RowInserterd = 0;
string UserName = ServiceSecurityContext.Current.PrimaryIdentity.Name;//Get Currtnt User Name.
objCLRUpdateRoundingRoomEntity.UpdateOpertr = UserName;
SqlConnection Conn = new SqlConnection(_ConnetctionString);//Create Connection with db.
Conn.Open();
SqlCommand Cmd = new SqlCommand("sp_UpdateRoundingLogForRoom", Conn);//Using SP from DB.
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.AddWithValue("@EnteredByID", UserName);
Cmd.Parameters.AddWithValue("@CLR_ID", Convert.ToInt32(objCLRUpdateRoundingRoomEntity.ClR_ID));
Cmd.Parameters.AddWithValue("@CLRStatusCode", objCLRUpdateRoundingRoomEntity.CLRStatusCode);
Cmd.Parameters.AddWithValue("@NurseNote", objCLRUpdateRoundingRoomEntity.NurseNote);
Cmd.Parameters.AddWithValue("@UpdateDate", Convert.ToDateTime(DateTime.Now.ToShortDateString()));
Cmd.Parameters.AddWithValue("@UpdateOpertr", objCLRUpdateRoundingRoomEntity.UpdateOpertr);
//Passing parameters to sp.
RowInserterd = Cmd.ExecuteNonQuery();// Get affected row index.
Conn.Close();//Connection Closed.
return RowInserterd.ToString();//Returning Result.
}
catch (Exception ex)
{
return ex.Message;
}
}
string LocalMarkStatusForRoom(CLRUpdateRoundingRoomEntity objCLRUpdateRoundingRoomEntity, SqlConnection Conn, SqlTransaction myTran)
{
int RowInserterd = 0;
SqlCommand Cmd = new SqlCommand("sp_InsertMarkStatusForRoom", Conn, myTran);//Using SP from DB.
string UserName = ServiceSecurityContext.Current.PrimaryIdentity.Name;//Get Currtnt User Name.
objCLRUpdateRoundingRoomEntity.UpdateOpertr = UserName;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.AddWithValue("@RoomID", Convert.ToInt32(objCLRUpdateRoundingRoomEntity.RoomID));
Cmd.Parameters.AddWithValue("@Date", objCLRUpdateRoundingRoomEntity.CLRDateTime);
Cmd.Parameters.AddWithValue("@EnteredByID", UserName);
Cmd.Parameters.AddWithValue("@RoundingRoomStatus", objCLRUpdateRoundingRoomEntity.RoomStatusCode);
Cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now.ToShortDateString());
Cmd.Parameters.AddWithValue("@UpdateOpertr", objCLRUpdateRoundingRoomEntity.UpdateOpertr);
//Passing parameters to sp.
RowInserterd = Cmd.ExecuteNonQuery();// Get affected row index.
Conn.Close();//Connection Closed.
//Conn = null;
//Cmd = null;
return RowInserterd.ToString();//Returning Result.
}
string ICLRService.MassUpdateRoundingRoomStatus(CLRMassUpdateRoundingRoomEntity objCLRMassUpdateRoundingRoomEntity)
{
SqlConnection Conn = null;
SqlTransaction myTran = null;
try
{
Conn = new SqlConnection(_ConnetctionString);//Create Connection with db.
Conn.Open();
myTran = Conn.BeginTransaction();
string strReturn = string.Empty;
//all rooms
string strMassUpdate = objCLRMassUpdateRoundingRoomEntity.MassUpdate;
if (strMassUpdate.Length > 0)
{
string[] SplitString = strMassUpdate.Split(';');
if (SplitString.Length > 0)
{
foreach (string strFields in SplitString)
{
//all fields
string[] strAllFields = strFields.Split(',');
if (strAllFields.Length == 3)
{
string roomid = string.Empty;
string roundingdate = string.Empty;
string roomstatus = string.Empty;
CLRUpdateRoundingRoomEntity obj = new CLRUpdateRoundingRoomEntity();
obj.RoomID = strAllFields[0];
obj.CLRDateTime = strAllFields[1];
obj.RoomStatusCode = strAllFields[2];
strReturn = strReturn + LocalMarkStatusForRoom(obj, Conn, myTran);
strReturn = strReturn + ",";
}
}
strReturn = strReturn.Remove(strReturn.Length - 1);
myTran.Commit();
Conn.Close();
}
}
return strReturn;
}
catch (Exception ex)
{
try
{
myTran.Rollback();
}
catch (Exception ex2)
{
return ex2.Message;
}
return ex.Message;
}
}