public Task <string> Save(ClinicalChartModel mClinicalChart)
{
try
{
const string query = @"INSERT INTO tbl_CLINICAL_CHART (PCode,Description, Charge, ServiceCharge, ServiceChargePcOrTk, Vat, VatPcOrTk, LessAmount, RefFee, RefFeePcOrTk, ReportFee, ReportFeePcOrTk, CollectionFee, CollectionFeePcOrTk, OthersFee, OthersFeePcOrTk, ReportDeliverDuration, OutTest, CanChangePrice, ShowDoctorCode, CanGiveLess, ReportFileName, SubSubPnoId,IndoorBillGroupId, ReportGroupId, IsShow, DiscountGroupId, AccountReportId, UserName, BranchId, EntryTime,IsAdjustAmt)
VALUES (@PCode, @Description, @Charge, @ServiceCharge, @ServiceChargePcOrTk, @Vat, @VatPcOrTk, @LessAmount, @RefFee, @RefFeePcOrTk, @ReportFee, @ReportFeePcOrTk, @CollectionFee, @CollectionFeePcOrTk, @OthersFee, @OthersFeePcOrTk, @ReportDeliverDuration, @OutTest, @CanChangePrice, @ShowDoctorCode, @CanGiveLess, @ReportFileName, @SubSubPnoId, @IndoorBillGroupId, @ReportGroupId, @IsShow, @DiscountGroupId, @AccountReportId, @UserName, @BranchId, @EntryTime,@IsAdjustAmt)";
Con.Open();
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@PCode", mClinicalChart.PCode);
cmd.Parameters.AddWithValue("@Description", mClinicalChart.Description);
cmd.Parameters.AddWithValue("@Charge", mClinicalChart.Charge);
cmd.Parameters.AddWithValue("@ServiceCharge", mClinicalChart.ServiceCharge);
cmd.Parameters.AddWithValue("@ServiceChargePcOrTk", mClinicalChart.ServiceChargePcOrTkId);
cmd.Parameters.AddWithValue("@Vat", mClinicalChart.Vat);
cmd.Parameters.AddWithValue("@VatPcOrTk", mClinicalChart.VatPcOrTkId);
cmd.Parameters.AddWithValue("@LessAmount", mClinicalChart.LessFixedAmount);
cmd.Parameters.AddWithValue("@RefFee", mClinicalChart.ReferelFee);
cmd.Parameters.AddWithValue("@RefFeePcOrTk", mClinicalChart.ReferelFeePcOrTkId);
cmd.Parameters.AddWithValue("@ReportFee", mClinicalChart.ReportFee);
cmd.Parameters.AddWithValue("@ReportFeePcOrTk", mClinicalChart.ReportFeePcOrTkId);
cmd.Parameters.AddWithValue("@CollectionFee", mClinicalChart.CollectionFee);
cmd.Parameters.AddWithValue("@CollectionFeePcOrTk", mClinicalChart.CollectionFeePcOrTkId);
cmd.Parameters.AddWithValue("@OthersFee", mClinicalChart.OthersFee);
cmd.Parameters.AddWithValue("@OthersFeePcOrTk", mClinicalChart.OthersFeePcOrTkId);
cmd.Parameters.AddWithValue("@ReportDeliverDuration", mClinicalChart.DeliveryDuration);
cmd.Parameters.AddWithValue("@OutTest", mClinicalChart.OutTest);
cmd.Parameters.AddWithValue("@CanChangePrice", mClinicalChart.CanChangePrice);
cmd.Parameters.AddWithValue("@ShowDoctorCode", mClinicalChart.ShowDoctorCode);
cmd.Parameters.AddWithValue("@CanGiveLess", mClinicalChart.CanGiveLess);
cmd.Parameters.AddWithValue("@ReportFileName", mClinicalChart.ReportFileName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@SubSubPnoId", mClinicalChart.SubSubPnoId);
cmd.Parameters.AddWithValue("@IndoorBillGroupId", mClinicalChart.InDoorBillGroupId);
cmd.Parameters.AddWithValue("@ReportGroupId", mClinicalChart.ReportGroupId);
cmd.Parameters.AddWithValue("@IsShow", mClinicalChart.IsShowId);
cmd.Parameters.AddWithValue("@DiscountGroupId", mClinicalChart.DiscountGroupId);
cmd.Parameters.AddWithValue("@AccountReportId", mClinicalChart.AccountReportGroupId);
cmd.Parameters.AddWithValue("@UserName", mClinicalChart.UserName);
cmd.Parameters.AddWithValue("@BranchId", ReturnFieldValueOpenCon("tbl_USER_BRANCH_INFO", "UserName='******'", "BranchId"));//System.Web.HttpContext.Current.Session["BranchId"]);
cmd.Parameters.AddWithValue("@EntryTime", DateTime.Now.ToShortTimeString());
cmd.Parameters.AddWithValue("@IsAdjustAmt", mClinicalChart.IsAdjustAmtId);
cmd.ExecuteNonQuery();
Con.Close();
return(Task.FromResult <string>("Save Successful"));
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(Task.FromResult(exception.Message));
}
}
public async Task <HttpResponseMessage> Post([FromBody] ClinicalChartModel mClinicalChart)
{
try
{
var formatter = RequestFormat.JsonFormaterString();
if (string.IsNullOrEmpty(mClinicalChart.Description))
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = "Name is Empty"
}, formatter));
}
if (string.IsNullOrEmpty(mClinicalChart.PCode))
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = "PCode is Empty"
}, formatter));
}
if (string.IsNullOrEmpty(mClinicalChart.UserName))
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = "UserName is Empty"
}, formatter));
}
if (Math.Abs(mClinicalChart.Charge) < 1)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = "Charge Must Be Positive"
}, formatter));
}
else
{
if (_chartGateway.FncSeekRecordNew("tbl_CLINICAL_CHART", "Id=" + mClinicalChart.ItemId + "") == false)
{
if (_chartGateway.FncSeekRecordNew("tbl_CLINICAL_CHART", "PCode='" + mClinicalChart.PCode + "'"))
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = "PCode Already Exists"
}, formatter));
}
else
{
string msg = await _chartGateway.Save(mClinicalChart);
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "success", Msg = msg
}, formatter));
}
}
else
{
string msg = await _chartGateway.Update(mClinicalChart);
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "success", Msg = msg
}, formatter));
}
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = ex.ToString()
}, formatter));
}
}
