示例#1
0
 public bool UpdateCOAInformation(mdlAccounts obj_mdlAccounts)
 {
     return obj_dalCOA.UpdateCOAInformation(obj_mdlAccounts);
 }
示例#2
0
        public bool SaveCOAInformation(mdlAccounts obj_mdlAccounts)
        {
            bool functionReturnValue = false;

            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            conn.Open();
            try
            {
                SqlCommand cmd = new SqlCommand("stp_ERP_M_COA_Insert", conn);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Clear();
                cmd.Parameters.Add("@pk_ACCode", SqlDbType.VarChar, 14).Value = obj_mdlAccounts.pk_ACCode;
                cmd.Parameters.Add("@ACName", SqlDbType.VarChar, 150).Value = obj_mdlAccounts.ACName;
                cmd.Parameters.Add("@ACShortCut", SqlDbType.VarChar, 50).Value = obj_mdlAccounts.AccountShortCut;
                cmd.Parameters.Add("@Category", SqlDbType.VarChar, 50).Value = obj_mdlAccounts.Category;
                cmd.Parameters.Add("@CategoryDetail", SqlDbType.VarChar, 50).Value = obj_mdlAccounts.CategoryDetail;
                cmd.Parameters.Add("@ACLevel", SqlDbType.Decimal).Value = Convert.ToDouble(obj_mdlAccounts.ACLevel);
                cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 50).Value = obj_mdlAccounts.Remarks;
                cmd.Parameters.Add("@ConsolidationAC", SqlDbType.Bit).Value = Convert.ToBoolean(obj_mdlAccounts.ConsolidationAC);
                cmd.Parameters.Add("@ControlAC", SqlDbType.Bit).Value = Convert.ToBoolean(obj_mdlAccounts.ControlAC);
                cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = Convert.ToBoolean(obj_mdlAccounts.Active);
                if (obj_mdlAccounts.ActiveFrom.Replace("/", "").Trim() == "")
                {
                    cmd.Parameters.Add("@ActiveFrom", SqlDbType.Date).Value = Convert.ToDateTime("01-01-1900");
                }
                else
                {
                    cmd.Parameters.Add("@ActiveFrom", SqlDbType.Date).Value = Convert.ToDateTime(obj_mdlAccounts.ActiveFrom);
                }
                if (obj_mdlAccounts.ActiveTo.Replace("/", "").Trim() == "")
                {
                    cmd.Parameters.Add("@ActiveTo", SqlDbType.Date).Value = Convert.ToDateTime("01-01-1900");
                }
                else
                {
                    cmd.Parameters.Add("@ActiveTo", SqlDbType.Date).Value = Convert.ToDateTime(obj_mdlAccounts.ActiveTo);
                }
                cmd.Parameters.Add("@Inactive", SqlDbType.Decimal).Value = Convert.ToDouble(obj_mdlAccounts.Inactive);
                if (obj_mdlAccounts.InactiveFrom.Replace("/", "").Trim() == "")
                {
                    cmd.Parameters.Add("@InactiveFrom", SqlDbType.Date).Value = Convert.ToDateTime("01-01-1900");
                }
                else
                {
                    cmd.Parameters.Add("@InactiveFrom", SqlDbType.Date).Value = Convert.ToDateTime(obj_mdlAccounts.InactiveFrom);
                }
                if (obj_mdlAccounts.InactiveTo.Replace("/", "").Trim() == "")
                {
                    cmd.Parameters.Add("@InactiveTo", SqlDbType.Date).Value = Convert.ToDateTime("01-01-1900");
                }
                else
                {
                    cmd.Parameters.Add("@InactiveTo", SqlDbType.Date).Value = Convert.ToDateTime(obj_mdlAccounts.InactiveTo);
                }
                cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 50).Value = obj_mdlAccounts.UserName;
                cmd.Parameters.Add("@AddDate", SqlDbType.Date).Value = Convert.ToDateTime(obj_mdlAccounts.AddDate);

                if (cmd.ExecuteNonQuery() != 0)
                {
                    functionReturnValue = true;
                }
                else
                {
                    functionReturnValue = false;
                }
                cmd.Cancel();
                cmd.Dispose();
            }
            catch (Exception)
            {
                functionReturnValue = false;
            }
            return functionReturnValue;
        }
示例#3
0
 public bool SaveCOAInformation(mdlAccounts obj_mdlAccounts)
 {
     return obj_dalCOA.SaveCOAInformation(obj_mdlAccounts);
 }