public void insertData(resp_message rm)
{
using (var ctx = new cdiEntities())
{
ctx.AddToresp_message(rm);
ctx.SaveChanges();
}
}
public void InsertData(decl_message dm)
{
using (var ctx = new cdiEntities())
{
ctx.AddTodecl_message(dm);
ctx.SaveChanges();
}
}
public void updateRespMsgDetail(string outId, string msgDetail, string recMsgId ,int type, int place)
{
using (var ctx = new cdiEntities())
{
var results = ctx.resp_message.Where(c => c.out_decl_no == outId && c.message_type == type && c.send_place == place);
foreach (resp_message c in results)
{
c.message_detail = msgDetail;
c.receive_message_id = recMsgId;
}
ctx.SaveChanges();
}
}
public String queryMessageDetail(string id, int type, int place)
{
using (var ctx = new cdiEntities())
{
var results = ctx.resp_message.SingleOrDefault(c => c.send_message_id == id && c.message_type == type && c.send_place == place);
ctx.SaveChanges();
if (results == null)
{
return null;
}
return results.message_detail;
}
}
public string getRespMsgDetailByMsgId(string msgId, int type, int place)
{
using (var ctx = new cdiEntities())
{
var results = ctx.resp_message.SingleOrDefault(c => c.send_message_id == msgId && c.message_type == type && c.send_place == place);
ctx.SaveChanges();
if (results == null)
{
return null;
}
return results.message_detail;
}
}
