public ActionResult TaxInformationCompany(TaxInformationCompany obj, FormCollection fc)
{
if (bl_tax.Check_TaxCompany(obj.taxInformationTypeID, obj.code))
{
if (bl_tax.SAVE(obj))
{
if (obj.taxInformationTypeID > 0)
{
ModelState.Clear();
TempData["Msg"] = "Tax Information Company Updated Successfully !";
return(RedirectToAction("TaxInformationCompany", "TaxInformationCompany"));
}
else
{
ModelState.Clear();
TempData["Msg"] = "Tax Information Company Saved Successfully !";
return(RedirectToAction("TaxInformationCompany", "TaxInformationCompany"));
}
}
else
{
TempData["Msg"] = "Tax Information Company Not Saved !";
}
}
else
{
ViewData["flag"] = "Error";
TempData["Msg"] = "Tax Information Company Already Exist ";
}
return(RedirectToAction("TaxInformationCompany", "TaxInformationCompany"));
}
public bool SAVE(TaxInformationCompany obj)
{
try
{
Connect();
SqlCommand cmd = new SqlCommand("IUTaxInformation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.taxInformationTypeID == 0)
{
cmd.Parameters.AddWithValue("@TaxTypeInformationID", 0);
cmd.Parameters.AddWithValue("@Mode", "ADD");
}
else
{
cmd.Parameters.AddWithValue("@TaxTypeInformationID", obj.taxInformationTypeID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@Code", obj.code);
if (obj.taxInformationType == null || obj.taxInformationType == "False")
{
cmd.Parameters.AddWithValue("@TaxTypeInformation", "");
}
else
{
cmd.Parameters.AddWithValue("@TaxTypeInformation", obj.taxInformationType);
}
cmd.Parameters.AddWithValue("@TaxType", obj.taxType);
if (obj.taxInforamtionTypeTaxRate == null || obj.taxInforamtionTypeTaxRate == "")
{
cmd.Parameters.AddWithValue("@InformationTaxRate", "");
}
else
{
cmd.Parameters.AddWithValue("@InformationTaxRate", obj.taxInforamtionTypeTaxRate);
}
if (obj.interStateTaxRate == null || obj.interStateTaxRate == "")
{
cmd.Parameters.AddWithValue("@InterstateTaxRate", "");
}
else
{
cmd.Parameters.AddWithValue("@InterstateTaxRate", obj.interStateTaxRate);
}
if (obj.interState == "on" || obj.interState == "True")
{
cmd.Parameters.AddWithValue("@InterState", true);
}
else
{
cmd.Parameters.AddWithValue("@InterState", false);
}
if (obj.formType == null || obj.formType == "")
{
cmd.Parameters.AddWithValue("@FormType", "");
}
else
{
cmd.Parameters.AddWithValue("@FormType", obj.formType);
}
if (obj.description == null || obj.description == "")
{
cmd.Parameters.AddWithValue("@Discription", "");
}
else
{
cmd.Parameters.AddWithValue("@Discription", obj.description);
}
if (obj.postingAccountID == null || obj.postingAccountID == "")
{
cmd.Parameters.AddWithValue("@PostingAccount", "");
}
else
{
cmd.Parameters.AddWithValue("@PostingAccount", obj.postingAccountID);
}
if (obj.taxInformationDetailTaxRate == null || obj.taxInformationDetailTaxRate == "")
{
cmd.Parameters.AddWithValue("@TaxRate", "");
}
else
{
cmd.Parameters.AddWithValue("@TaxRate", obj.taxInformationDetailTaxRate);
}
if (obj.surcharge == null || obj.surcharge == "")
{
cmd.Parameters.AddWithValue("@Surcharge", "");
}
else
{
cmd.Parameters.AddWithValue("@Surcharge", obj.surcharge);
}
if (obj.rateInclusiveInTax == "on" || obj.rateInclusiveInTax == "True")
{
cmd.Parameters.AddWithValue("@RateInclusive", true);
}
else
{
cmd.Parameters.AddWithValue("@RateInclusive", false);
}
if (obj.taxInclusiveInRates == null || obj.taxInclusiveInRates == "")
{
cmd.Parameters.AddWithValue("@TaxInclusiveInRates", 0);
}
else
{
cmd.Parameters.AddWithValue("@TaxInclusiveInRates", obj.taxInclusiveInRates);
}
if (obj.taxInclusiveInRatesForLTE == "on" || obj.taxInclusiveInRatesForLTE == "True")
{
cmd.Parameters.AddWithValue("@TaxInclusiveInRatesForLTE", true);
}
else
{
cmd.Parameters.AddWithValue("@TaxInclusiveInRatesForLTE", false);
}
if (obj.taxInformationDetailTaxAccountID == null || obj.taxInformationDetailTaxAccountID == "")
{
cmd.Parameters.AddWithValue("@TaxAC", 0);
}
else
{
cmd.Parameters.AddWithValue("@TaxAC", obj.taxInformationDetailTaxAccountID);
}
if (obj.surchargeAccountID == null || obj.surchargeAccountID == "")
{
cmd.Parameters.AddWithValue("@SurchargeAC", 0);
}
else
{
cmd.Parameters.AddWithValue("@SurchargeAC", obj.surchargeAccountID);
}
if (obj.addCharge == null || obj.addCharge == "")
{
cmd.Parameters.AddWithValue("@AddICharge", 0);
}
else
{
cmd.Parameters.AddWithValue("@AddICharge", obj.addCharge);
}
if (obj.discount == null || obj.discount == "False")
{
cmd.Parameters.AddWithValue("@Discount", "");
}
else
{
cmd.Parameters.AddWithValue("@Discount", obj.discount);
}
if (obj.addICOnFreeGoods == "on" || obj.addICOnFreeGoods == "True")
{
cmd.Parameters.AddWithValue("@AddICOnFreeGoods", true);
}
else
{
cmd.Parameters.AddWithValue("@AddICOnFreeGoods", false);
}
if (obj.calculateTaxBeforeDiscount == "on" || obj.calculateTaxBeforeDiscount == "True")
{
cmd.Parameters.AddWithValue("@CalculateTaxBeforeDiscount", true);
}
else
{
cmd.Parameters.AddWithValue("@CalculateTaxBeforeDiscount", false);
}
if (obj.chargeTaxOnFreeGoods == "on" || obj.chargeTaxOnFreeGoods == "True")
{
cmd.Parameters.AddWithValue("@ChargeTaxOnFreeGoods", true);
}
else
{
cmd.Parameters.AddWithValue("@ChargeTaxOnFreeGoods", false);
}
if (obj.taxOfFreeGoodsOnGrossValue == "on" || obj.taxOfFreeGoodsOnGrossValue == "True")
{
cmd.Parameters.AddWithValue("@TaxOfFreeGoodsOnGrossValue", true);
}
else
{
cmd.Parameters.AddWithValue("@TaxOfFreeGoodsOnGrossValue", false);
}
if (obj.taxCalculateBasedOnMRP == "on" || obj.taxCalculateBasedOnMRP == "True")
{
cmd.Parameters.AddWithValue("@TaxCalculationBasedOnMRP", true);
}
else
{
cmd.Parameters.AddWithValue("@TaxCalculationBasedOnMRP", false);
}
if (obj.abatementRebateForLTE == "on" || obj.abatementRebateForLTE == "True")
{
cmd.Parameters.AddWithValue("@AbateMentRebateForLTE", true);
}
else
{
cmd.Parameters.AddWithValue("@AbateMentRebateForLTE", false);
}
if (obj.abatementRate == null || obj.abatementRate == "")
{
cmd.Parameters.AddWithValue("@AbatementRate", 0);
}
else
{
cmd.Parameters.AddWithValue("@AbatementRate", obj.abatementRate);
}
if (obj.chargePromotionalRate == null || obj.chargePromotionalRate == "")
{
cmd.Parameters.AddWithValue("@ChargePromotionalRate", 0);
}
else
{
cmd.Parameters.AddWithValue("@ChargePromotionalRate", obj.chargePromotionalRate);
}
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
