public static void Update(BRStatusView bRStatusView, int ID)
{
const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";
string connection = Common.GetSQLonnectionString("ReferenceData");
ULSLoggingService.LogMessage(string.Format("server name is {0}", ServerName));
ULSLoggingService.LogMessage(string.Format("secure store connection string is {0}", connection));
ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
(connection);
Recl_BRstatus BRStatus = (from Recl_BRstatus in dataContext.Recl_BRstatus.AsEnumerable().Take(20)
where Recl_BRstatus.ID == ID
select Recl_BRstatus).Single();
if (BRStatus != null)
{
//BRStatus.ID = bRStatusView.ID;
BRStatus.BlockID = bRStatusView.BlockID;
BRStatus.Phase = bRStatusView.Phase;
BRStatus.BRstatus = bRStatusView.BRStatus;
BRStatus.DateInitiated = bRStatusView.DateInitiated;
BRStatus.DateApproved = bRStatusView.DateApproved;
BRStatus.Notes = bRStatusView.Notes;
}
dataContext.SubmitChanges();
}
public static BRStatusView Create(BRStatusView newBRStatusView)
{
const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";
string connection = Common.GetSQLonnectionString("ReferenceData");
ULSLoggingService.LogMessage(string.Format("server name is {0}", ServerName));
ULSLoggingService.LogMessage(string.Format("secure store connection string is {0}", connection));
ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
(connection);
Recl_BRstatus BRStatus = new Recl_BRstatus();
BRStatus.ID = newBRStatusView.ID;
BRStatus.Notes = newBRStatusView.Notes;
BRStatus.Phase = newBRStatusView.Phase;
BRStatus.BlockID = newBRStatusView.BlockID;
BRStatus.BRstatus = newBRStatusView.BRStatus;
BRStatus.DateApproved = newBRStatusView.DateApproved;
BRStatus.DateInitiated = newBRStatusView.DateApproved;
dataContext.Recl_BRstatus.InsertOnSubmit(BRStatus);
dataContext.SubmitChanges();
string connection1 = Common.GetSQLonnectionString("TWCC");
ULSLoggingService.LogMessage(string.Format("server name is {0}", connection1));
TWCCClasses1DataContext dataContentTWCC = new TWCCClasses1DataContext
(connection1);
SmallBlock smallBlock = new SmallBlock();
smallBlock.MineArea = newBRStatusView.MineArea;
smallBlock.SmallAC = newBRStatusView.SmallAC;
dataContentTWCC.SmallBlocks.InsertOnSubmit(smallBlock);
dataContentTWCC.SubmitChanges();
return(newBRStatusView);
}
