public void addOverpaymentDetail(OverpaymentDetailAdd overpaymentDetail) { var conn = new mainEntities(); conn.Database.Connection.Open(); var overpaymentDetailDB = conn.OverpaymentDetails; var overpayment = new OverpaymentDetail() { OverPaymentID = overpaymentDetail.OverPyamentID, MemberId = overpaymentDetail.MemberId, ClaimNumber = overpaymentDetail.ClaimNumber, BalanceAmt = overpaymentDetail.BalanceAmt, OverPaymentAmt = overpaymentDetail.OverPaymentAmt, SysSrcSyncDate = DateTime.Today, LastUpdated = DateTime.Today }; overpaymentDetailDB.Add(overpayment); }
public void PostOverPaymentDetail([FromBody] OverpaymentDetailRequest overpaymentDetailRequest) { var overpaymentDetailAdd = new OverpaymentDetailAdd { OverPyamentID = overpaymentDetailRequest.OverPyamentID, MemberId = overpaymentDetailRequest.MemberId, ClaimNumber = overpaymentDetailRequest.ClaimNumber, BalanceAmt = overpaymentDetailRequest.BalanceAmt, OverPaymentAmt = overpaymentDetailRequest.OverPaymentAmt }; //overpaymentService.addOverpaymentDetail(overpaymentDetailAdd); var conn = new mainEntities(); conn.Database.Connection.Open(); var overpaymentDetailDB = conn.OverpaymentDetails; var overpayment = new OverpaymentDetail() { OverPaymentID = overpaymentDetailRequest.OverPyamentID, MemberId = overpaymentDetailRequest.MemberId, ClaimNumber = overpaymentDetailRequest.ClaimNumber, BalanceAmt = overpaymentDetailRequest.BalanceAmt, OverPaymentAmt = overpaymentDetailRequest.OverPaymentAmt, SysSrcSyncDate = DateTime.Today, LastUpdated = DateTime.Today }; overpaymentDetailDB.Add(overpayment); conn.SaveChanges(); conn.Dispose(); //var conn = new System.Data.SQLite.SQLiteConnection("data source=C:/inetpub/wwwroot/OverpaymentAPISite/OverpaymentDetail.db"); //using (var cmd = new SQLiteCommand(conn)) //{ // conn.Open(); // cmd.CommandText = "INSERT INTO OverPaymentDetail(OverPaymentID, ClaimNumber, MemberId, BalanceAmt, OverPaymentAmt) Values(" // + overpaymentDetailRequest.OverPyamentID.ToString() + ", " + overpaymentDetailRequest.ClaimNumber.ToString() + ", " + overpaymentDetailRequest.MemberId.ToString() + ", " + overpaymentDetailRequest.BalanceAmt.ToString() + ", " + overpaymentDetailRequest.OverPaymentAmt.ToString() + ")"; // cmd.ExecuteNonQuery(); // conn.Close(); //} }