Esempio n. 1
0
        /// <summary>
        /// Saves a record to the T_RecDet table.
        /// </summary>
        public Boolean Savet_RecDetSP(T_RecDet t_RecDet, int formMode)
        {
            SqlCommand scom;
            bool       retvalue = false;

            try
            {
                scom             = new SqlCommand();
                scom.CommandType = CommandType.StoredProcedure;
                scom.CommandText = "T_RecDetSave";

                scom.Parameters.Add("@Docno", SqlDbType.VarChar, 10).Value            = t_RecDet.Docno;
                scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value       = t_RecDet.locationId;
                scom.Parameters.Add("@Sequence", SqlDbType.Int, 4).Value              = t_RecDet.Sequence;
                scom.Parameters.Add("@Paytype", SqlDbType.VarChar, 20).Value          = t_RecDet.Paytype;
                scom.Parameters.Add("@HeadAmt", SqlDbType.Decimal, 9).Value           = t_RecDet.HeadAmt;
                scom.Parameters.Add("@Amt", SqlDbType.Decimal, 9).Value               = t_RecDet.Amt;
                scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value            = t_RecDet.InvNo;
                scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value            = t_RecDet.Datex;
                scom.Parameters.Add("@CQno", SqlDbType.VarChar, 20).Value             = t_RecDet.CQno;
                scom.Parameters.Add("@Bank", SqlDbType.VarChar, 20).Value             = t_RecDet.Bank;
                scom.Parameters.Add("@BankBranch", SqlDbType.VarChar, 20).Value       = t_RecDet.BankBranch;
                scom.Parameters.Add("@BankDate", SqlDbType.DateTime, 8).Value         = t_RecDet.BankDate;
                scom.Parameters.Add("@isReconsile", SqlDbType.Bit, 1).Value           = t_RecDet.isReconsile;
                scom.Parameters.Add("@ReconsileDate", SqlDbType.DateTime, 8).Value    = t_RecDet.ReconsileDate;
                scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value         = t_RecDet.Customer;
                scom.Parameters.Add("@isreturned", SqlDbType.Bit, 1).Value            = t_RecDet.isreturned;
                scom.Parameters.Add("@ReturnDate", SqlDbType.DateTime, 8).Value       = t_RecDet.ReturnDate;
                scom.Parameters.Add("@ReturnUpdateUSer", SqlDbType.VarChar, 20).Value = t_RecDet.ReturnUpdateUSer;
                scom.Parameters.Add("@ReasontoRtn", SqlDbType.VarChar, 120).Value     = t_RecDet.ReasontoRtn;
                scom.Parameters.Add("@InsMode", SqlDbType.Int).Value  = formMode; // For insert
                scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;

                u_DBConnection dbcon = new u_DBConnection();
                retvalue = dbcon.RunQuery(scom);
                return(retvalue);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
Esempio n. 2
0
        public List <T_RecDet> SelectT_RecDetMulti(T_RecDet objt_RecDet2)
        {
            List <T_RecDet> retval = new List <T_RecDet>();

            try
            {
                strquery = @"select * from t_RecDet where Docno = '" + objt_RecDet2.Docno + "'";
                DataTable dtt_RecDet = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
                foreach (DataRow drType in dtt_RecDet.Rows)
                {
                    if (drType != null)
                    {
                        T_RecDet objt_RecDet = new T_RecDet();
                        objt_RecDet.Docno            = drType["Docno"].ToString();
                        objt_RecDet.locationId       = drType["locationId"].ToString();
                        objt_RecDet.Sequence         = int.Parse(drType["Sequence"].ToString());
                        objt_RecDet.Paytype          = drType["Paytype"].ToString();
                        objt_RecDet.HeadAmt          = decimal.Parse(drType["HeadAmt"].ToString());
                        objt_RecDet.Amt              = decimal.Parse(drType["Amt"].ToString());
                        objt_RecDet.InvNo            = drType["InvNo"].ToString();
                        objt_RecDet.Datex            = DateTime.Parse(drType["Datex"].ToString());
                        objt_RecDet.CQno             = drType["CQno"].ToString();
                        objt_RecDet.Bank             = drType["Bank"].ToString();
                        objt_RecDet.BankBranch       = drType["BankBranch"].ToString();
                        objt_RecDet.BankDate         = DateTime.Parse(drType["BankDate"].ToString());
                        objt_RecDet.isReconsile      = bool.Parse(drType["isReconsile"].ToString());
                        objt_RecDet.ReconsileDate    = DateTime.Parse(drType["ReconsileDate"].ToString());
                        objt_RecDet.Customer         = drType["Customer"].ToString();
                        objt_RecDet.isreturned       = bool.Parse(drType["isreturned"].ToString());
                        objt_RecDet.ReturnDate       = DateTime.Parse(drType["ReturnDate"].ToString());
                        objt_RecDet.ReturnUpdateUSer = drType["ReturnUpdateUSer"].ToString();
                        objt_RecDet.ReasontoRtn      = drType["ReasontoRtn"].ToString();
                        retval.Add(objt_RecDet);
                    }
                }
                return(retval);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 3
0
 private void button4_Click(object sender, EventArgs e)
 {
     if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
     {
         foreach (DataGridViewRow drow in dte_cheques.Rows)
         {
             if (drow.Cells[0].Value.ToString().Trim() != null)
             {
                 T_RecDet det = new T_RecDet();
                 det = new T_RecDetDL().Selectt_RecDet(det, drow.Cells[0].Value.ToString().Trim(), drow.Cells[1].Value.ToString().Trim());
                 if (det != null)
                 {
                     det.isReconsile = Convert.ToBoolean(drow.Cells[6].Value);
                     det.isreturned  = Convert.ToBoolean(drow.Cells[7].Value);
                     new T_RecDetDL().Savet_RecDetSP(det, 3);
                 }
             }
         }
     }
 }
Esempio n. 4
0
 public T_RecDet Selectt_RecDet(T_RecDet objt_RecDet, string docno, string cqno)
 {
     try
     {
         strquery = @"select * from t_RecDet where Docno = '" + docno.Trim() + "' AND CQno = '" + cqno.Trim() + "'";
         DataRow drType = u_DBConnection.ReturnDataRow(strquery);
         if (drType != null)
         {
             objt_RecDet.Docno            = drType["Docno"].ToString();
             objt_RecDet.locationId       = drType["locationId"].ToString();
             objt_RecDet.Sequence         = int.Parse(drType["Sequence"].ToString());
             objt_RecDet.Paytype          = drType["Paytype"].ToString();
             objt_RecDet.HeadAmt          = decimal.Parse(drType["HeadAmt"].ToString());
             objt_RecDet.Amt              = decimal.Parse(drType["Amt"].ToString());
             objt_RecDet.InvNo            = drType["InvNo"].ToString();
             objt_RecDet.Datex            = DateTime.Parse(drType["Datex"].ToString());
             objt_RecDet.CQno             = drType["CQno"].ToString();
             objt_RecDet.Bank             = drType["Bank"].ToString();
             objt_RecDet.BankBranch       = drType["BankBranch"].ToString();
             objt_RecDet.BankDate         = DateTime.Parse(drType["BankDate"].ToString());
             objt_RecDet.isReconsile      = bool.Parse(drType["isReconsile"].ToString());
             objt_RecDet.ReconsileDate    = DateTime.Parse(drType["ReconsileDate"].ToString());
             objt_RecDet.Customer         = drType["Customer"].ToString();
             objt_RecDet.isreturned       = bool.Parse(drType["isreturned"].ToString());
             objt_RecDet.ReturnDate       = DateTime.Parse(drType["ReturnDate"].ToString());
             objt_RecDet.ReturnUpdateUSer = drType["ReturnUpdateUSer"].ToString();
             objt_RecDet.ReasontoRtn      = drType["ReasontoRtn"].ToString();
             return(objt_RecDet);
         }
         return(null);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }