private void Dis_KeyDown(object sender, KeyEventArgs e)
 {
     if (e.Key == Key.Enter)
     {
         this.CalculateNetAmount();
         OtherCharges.Focus();
     }
 }
 protected void GridInword_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     try
     {
         if (e.Row.RowType == DataControlRowType.DataRow && !string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "InwardNo"))))
         {
             //Taxamt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "DiscAmnt"));
             SubTotal     += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "SubTotal"));
             Discount     += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Discount"));
             Vat          += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Vat"));
             DekhrekhAmt  += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "DekhrekhAmt"));
             HamaliAmt    += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "HamaliAmt"));
             CESSAmt      += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "CESSAmt"));
             FreightAmt   += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "FreightAmt"));
             PackingAmt   += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PackingAmt"));
             PostageAmt   += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PostageAmt"));
             OtherCharges += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "OtherCharges"));
             GrandTotal   += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "GrandTotal"));
         }
         if (e.Row.RowType == DataControlRowType.Footer)
         {
             e.Row.Cells[6].Text  = "Total";
             e.Row.Cells[7].Text  = SubTotal.ToString("0.00");
             e.Row.Cells[8].Text  = Discount.ToString("0.00");
             e.Row.Cells[9].Text  = Vat.ToString("0.00");
             e.Row.Cells[10].Text = DekhrekhAmt.ToString("0.00");
             e.Row.Cells[11].Text = HamaliAmt.ToString("0.00");
             e.Row.Cells[12].Text = CESSAmt.ToString("0.00");
             e.Row.Cells[13].Text = FreightAmt.ToString("0.00");
             e.Row.Cells[14].Text = PackingAmt.ToString("0.00");
             e.Row.Cells[15].Text = PostageAmt.ToString("0.00");
             e.Row.Cells[16].Text = OtherCharges.ToString("0.00");
             e.Row.Cells[17].Text = GrandTotal.ToString("0.00");
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Esempio n. 3
0
        public OtherCharges GetOtherChargesRecord(string recordID, string UserSNo)
        {
            OtherCharges  otherCharges = new OtherCharges();
            SqlDataReader dr           = null;

            try
            {
                SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@UserID", Convert.ToInt32(UserSNo)) };
                dr = SqlHelper.ExecuteReader(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetOtherChargesRecord", Parameters);
                if (dr.Read())
                {
                    //SNo,AirlineSNo,AirLine,OtherChargesSNo,OtherCharges,IsOtherChargeMandatory,OriginLevelSNo,OriginLevel,DestinationLevelSNo,DestinationLevel,DueChargeType,
                    //Status,StatusText,UnitText,CurrencySNo,Currency,ChargeType,ChargeTypeText,PaymentType,PaymentText,MinimumCharge,Charge,IsTaxable,
                    //IsCommissionable,ValidFrom,ValidTo,OriginSNo,OriginText,DestinationSNo,DestinationText,CreatedUser,UpdatedUser
                    otherCharges.SNo                        = Convert.ToInt32(dr["SNo"]);
                    otherCharges.AirlineSNo                 = Convert.ToString(dr["AirlineSNo"]);
                    otherCharges.Text_AirlineSNo            = Convert.ToString(dr["AirLine"]);
                    otherCharges.DueCarrierCodeSNo          = Convert.ToString(dr["OtherChargesSNo"]);
                    otherCharges.Text_OCCodeSNo             = Convert.ToString(dr["OtherCharges"]);
                    otherCharges.IsOtherChargeMandatory     = Convert.ToBoolean(dr["IsOtherChargeMandatory"]);
                    otherCharges.OtherChargeMandatory       = Convert.ToString(dr["OtherChargeMandatory"]);
                    otherCharges.OriginType                 = Convert.ToInt32(dr["OriginLevelSNo"]);
                    otherCharges.Text_OriginType            = Convert.ToString(dr["OriginLevel"]);
                    otherCharges.DestinationType            = Convert.ToInt32(dr["DestinationLevelSNo"]);
                    otherCharges.Text_DestinationType       = Convert.ToString(dr["DestinationLevel"]);
                    otherCharges.DueChargeTypeText          = Convert.ToString(dr["DueChargeType"]);
                    otherCharges.Text_ApplicableOn          = Convert.ToString(dr["Text_ApplicableOn"]);
                    otherCharges.DueChargeType              = Convert.ToString(dr["DueChargeTypeText"]);
                    otherCharges.Status                     = Convert.ToInt32(dr["Status"]);
                    otherCharges.Text_Active                = Convert.ToString(dr["StatusText"]);
                    otherCharges.UnitText                   = Convert.ToString(dr["UnitText"]);
                    otherCharges.CurrencySNo                = Convert.ToInt32(dr["CurrencySNo"]);
                    otherCharges.Text_CurrencySNo           = Convert.ToString(dr["Currency"]);
                    otherCharges.ChargeType                 = Convert.ToInt32(dr["ChargeType"]);
                    otherCharges.Text_ChargeType            = Convert.ToString(dr["ChargeTypeText"]);
                    otherCharges.PaymentType                = Convert.ToInt32(dr["PaymentType"]);
                    otherCharges.Text_PaymentType           = Convert.ToString(dr["PaymentText"]);
                    otherCharges.MinimumCharge              = Convert.ToDecimal(dr["MinimumCharge"]);
                    otherCharges.Charge                     = Convert.ToDecimal(dr["Charge"]);
                    otherCharges.IsTaxable                  = Convert.ToBoolean(dr["IsTaxable"]);
                    otherCharges.Taxable                    = Convert.ToString(dr["Taxable"]);
                    otherCharges.IsCommissionable           = Convert.ToBoolean(dr["IsCommissionable"]);
                    otherCharges.ReferenceNumber            = Convert.ToString(dr["ReferenceNumber"]);
                    otherCharges.Commissionable             = Convert.ToString(dr["Commissionable"]);
                    otherCharges.ValidFrom                  = Convert.ToDateTime(dr["ValidFrom"]);
                    otherCharges.ValidTo                    = Convert.ToDateTime(dr["ValidTo"]);
                    otherCharges.OriginAirPortSNo           = Convert.ToInt32(dr["OriginSNo"]);
                    otherCharges.Text_OriginAirPortSNo      = Convert.ToString(dr["OriginText"]);
                    otherCharges.Text_OriginSNo             = Convert.ToString(dr["OriginText"]);
                    otherCharges.DestinationAirPortSNo      = Convert.ToInt32(dr["DestinationSNo"]);
                    otherCharges.Text_DestinationAirPortSNo = Convert.ToString(dr["DestinationText"]);
                    otherCharges.Text_DestinationSNo        = Convert.ToString(dr["DestinationText"]);
                    otherCharges.CreatedUser                = Convert.ToString(dr["CreatedUser"]);
                    otherCharges.UpdatedUser                = Convert.ToString(dr["UpdatedUser"]);
                    otherCharges.IsReplanCharges            = Convert.ToBoolean(dr["IsReplanCharges"]);
                    otherCharges.Text_IsReplanCharges       = Convert.ToString(dr["Text_IsReplanCharges"]);
                    otherCharges.SlabCount                  = 0;
                    otherCharges.RemarksCount               = 0;
                }
            }
            catch (Exception ex)    //
            {
                dr.Close();
                throw ex;
            }

            return(otherCharges);
        }